CSB Related Table Info And Related Table Status & Queries - Doyensys

Maybe your like

ServicesOpen menu
- Enterprise Platform
  - Oracle Enterprise Business Suite
  - Oracle Fusion Cloud Application
  - Microsoft Dynamics
- Digital Services
  - Artificial Intelligence
  - Application Development and Modernization
  - Software Engineering
- Infrastructure Services
  - Hybrid Cloud Management
  - Database & Middleware
  - Network Management
  - End User Computing Services
  - Consult & Transform
- Managed Services
- Software Testing & Quality Assurance
- Data Engineering, BI & Analytics
SolutionsOpen menu
- Smart Manufacturing
- Cloud Transformation
- Value Innovation
CompanyOpen menu
- About
- Culture
- Careers
- Jobs
- Governance
ResourcesOpen menu
- Books
- Blogs
- Case Studies
- White Papers
- Faq

CSB related table Info and related Table Status & Queries Home > AR > CSB related table Info and related Table Status & Queries

Some of the Important Tables related to CSB:

iby_trxn_summaries_all – Holds the information related the CSB current batch ( DEBIT_AUTHORIZATION_ID, MBATCHID (Holds CSB Msgid)).
iby_debit_authorizations – Holds the information related to Debit authorization mapping (AUTH_CANCEL_DATE, CREDITOR_LEGAL_ENTITY_ID).
xle_entity_profiles – Holds the information related to the Legal entity name mapped to Debit authorization.
xle_firstparty_information_v
iby_fndcpt_tx_extensions – Any updates on Debit_debit_autorization_id in IBY_TRXN_SUMMARIES_ALL Table needs to be updated. (DEBIT_AUTHORIZATION_ID)

iby_trxn_summaries_all Table Status collum:

100 – Pending for process and will be picked in the next run.

0 – All lines were picked and a payment file got generated for these lines.

114 – Transactions was canceled in an open batch (void)

Some of the Important Queries related to CSB issue:

Query to know the Receipt number for that particular TRXNMID:

select RECEIPT_NUMBER from ar_cash_receipts_all where payment_trxn_extension_id in (

select trxn_extension_id from iby_fndcpt_tx_operations where transactionid in (

select transactionid from iby_trxn_summaries_all

where TRXNMID IN ()));

Query to know the Invoice for that particular TRXNMID:

select * from apps.ra_customer_trx_all where payment_trxn_extension_id in (

select trxn_extension_id from apps.iby_fndcpt_tx_operations where transactionid in (

select transactionid from apps.iby_trxn_summaries_all where TRXNMID = ))

Nikethan Reddy

Post navigation