Results for “rca_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The table OKL.OKL_XTL_CSH_APPS_ALL_B is a core receipts application table within the Oracle E-Business Suite Lease and Finance Management (OKL) module. Its documented description — "Receipt application specifying amount applied to Receivables invoices" — establishes its purpose: each row records how a portion of a lease-related cash receipt has been applied against a specific Oracle Receivables (AR) invoice or invoice installment. The table therefore sits at the boundary between the OKL cash management sub-ledger and the AR transaction ledger, acting as the reconciliation bridge between lease contract billing and actual customer settlements.

The object is VALID and stored in the OKL schema in both EBS 12.1.1 and 12.2.2. It carries the "_B" suffix characteristic of a base (non-translated) table, and includes the standard multi-org column ORG_ID plus the full EBS WHO-column set (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and an OBJECT_VERSION_NUMBER for optimistic locking.

Following the Data Vault classification heuristic mined from its foreign-key structure, this table is best modeled as a link: it resolves a many-to-many association between upstream lease/contract cash streams and downstream receipt details, rather than functioning as a pure descriptive hub or satellite.

Key Information Stored

The surrogate primary key is ID (OKL_XTL_CSH_APPS_ALL_B_PK), also exposed as a unique business-key candidate via OKL_XTL_CSH_APPS_ALL_B_U1. The 40 documented columns break into three groups:

• Relationship keys: XCR_ID_DETAILS links to the receipt detail record; IRP_ID references the invoice-related payment; RCA_ID and CAT_ID tie the row to cash allocation. CAT_ID is a foreign key to OKL_CASH_ALLCTN_RLS_ALL, and LSM_ID is a foreign key to OKL_CNSLD_AR_STRMS_B.
• AR application details: INVOICE_NUMBER and INVOICE_INSTALLMENT identify the AR invoice and the specific installment being settled; AMOUNT_APPLIED holds the amount applied to that invoice; AMOUNT_APPLIED_FROM records the funding/source amount; INVOICE_CURRENCY_CODE and TRANS_TO_RECEIPT_RATE capture the invoice currency and the conversion rate used to translate to the receipt currency; TRX_DATE is the accounting/transaction date.
• Concurrent program / audit columns: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, ORG_ID, and the 15 ATTRIBUTE flex columns (ATTRIBUTE_CATEGORY, ATTRIBUTE1–15) provide extensibility and traceability.

Common Use Cases and Queries

Because this table records invoice-level cash application, it underpins lease receivables reconciliation, aged-balance reporting, and cash-to-contract traceability. A typical query joins the table to the consolidated AR streams to trace which contract stream a receipt settled:

• Invoice-level applied-cash report: SELECT INVOICE_NUMBER, INVOICE_INSTALLMENT, AMOUNT_APPLIED, INVOICE_CURRENCY_CODE FROM OKL_OKL_XTL_CSH_APPS_ALL_B WHERE TRX_DATE BETWEEN :p_from AND :p_to.
• Contract-to-receipt reconciliation: join OKL_XTL_CSH_APPS_ALL_B.LSM_ID = OKL_CNSLD_AR_STRMS_B.ID to identify the lease stream funded by each applied receipt.
• Currency translation audit: filter rows where TRANS_TO_RECEIPT_RATE differs from expected rates or where AMOUNT_APPLIED <> AMOUNT_APPLIED_FROM to detect partial or discounted applications.
• Concurrent program debugging: group by REQUEST_ID and PROGRAM_ID to audit cash-application batch runs.

Related Objects

• OKL_CASH_ALLCTN_RLS_ALL — referenced via OKL_XTL_CSH_APPS_ALL_B.CAT_ID; provides the cash allocation rule set that governed the application.
• OKL_CNSLD_AR_STRMS_B — referenced via OKL_XTL_CSH_APPS_ALL_B.LSM_ID; the consolidated AR stream representing the lease billing schedule.
• OKL_XTL_CSH_APPS_ALL_B (self-referencing) — via RCA_ID and XCR_ID_DETAILS, linking application rows to their parent receipt/cash allocation records.
• Receipt/cash detail tables surfaced through XCR_ID_DETAILS and IRP_ID, which hold the enveloping receipt header and detail context.
• Oracle Receivables (AR) invoice and payment tables, reconciled against INVOICE_NUMBER, INVOICE_INSTALLMENT, and AMOUNT_APPLIED.

In summary, OKL_XTL_CSH_APPS_ALL_B is the transactional link table that records, with full currency and installment granularity, how lease receivables invoices are settled by cash receipts in Oracle Lease and Finance Management.