Search Results okl_ext_csh_rcpts_b




Overview
Explore in AI Chat

Overview

The OKL_EXT_CSH_RCPTS_B table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as a staging and integration table for cash receipts received from customers. Its primary role is to hold receipt data before it is interfaced to the Oracle Receivables (AR) lockbox processing engine. This table is instrumental in the cash application flow, acting as a bridge between external receipt sources and the standard AR cash receipt (AR_CASH_RECEIPTS_ALL) and the OKL-specific transaction receipt (OKL_TRX_CSH_RECEIPT_B) structures. The "B" suffix indicates it is the base table for the entity.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the foreign key relationships and description reveal the critical identifiers stored. The table's primary key is the ID column. Crucially, it stores foreign key references to link the external receipt to other central entities: the ICR_ID links to the AR_CASH_RECEIPTS_ALL table, connecting it to the standard Receivables cash receipt. The RCT_ID links to the OKL_TRX_CSH_RECEIPT_B table, connecting it to the Leasing module's internal receipt record. The XCB_ID column indicates a relationship to another entity, though its target is unspecified in the provided data. The table's purpose implies it would also store core receipt information such as amount, receipt date, customer identifier, and remittance details.

Common Use Cases and Queries

The primary use case is the processing and reconciliation of customer payments within leasing contracts. A typical workflow involves data from a bank lockbox file being loaded into this table, followed by a process that validates and creates records in the linked OKL_TRX_CSH_RECEIPT_B and AR_CASH_RECEIPTS_ALL tables. Common queries involve identifying receipts pending interface or troubleshooting integration issues. For example, to find external receipts not yet fully processed in OKL, one might query:

  • SELECT * FROM OKL_EXT_CSH_RCPTS_B ext WHERE NOT EXISTS (SELECT 1 FROM OKL_TRX_CSH_RECEIPT_B rct WHERE rct.ID = ext.RCT_ID);

Reporting use cases include analyzing the volume and source of cash receipts flowing into the leasing system before they are applied to specific contracts or invoices.

Related Objects

The table has defined integration points with several key EBS objects, as per the provided relationship data:

  • Referenced By This Table (Foreign Keys):
    • AR_CASH_RECEIPTS_ALL: Linked via the ICR_ID column. This is the core Receivables table for cash receipts.
    • OKL_TRX_CSH_RECEIPT_B: Linked via the RCT_ID column. This is the OKL base table for cash receipt transactions.
    • Unspecified Table (XCB_ID): The table references another entity via the XCB_ID column, though the target table is not named in the excerpt.
  • References This Table (Foreign Key In):
    • OKL_XTL_CSH_APPS_B: This table references OKL_EXT_CSH_RCPTS_B via the XCR_ID_DETAILS column. This suggests OKL_XTL_CSH_APPS_B holds detailed application data for the external cash receipt.