Search Results pay_status_code

Overview

The OKL_CNSLD_AR_STRMS_B table is a core transaction-level table within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It persists the lowest level of detail included on a consolidated bill — that is, the individual financial "streams" or line-level transactions that roll up into a consolidated accounts receivable invoice generated by the OKL billing engine. Each row corresponds to a discrete component of a consolidated receivable, capturing the monetary amount, tax treatment, late-charge status, and disbursement state associated with that stream.

The object resides in the OKL schema and is valid in both EBS 12.1.1 and 12.2.2. The physical schema documents 44 columns. Because the table is keyed by a surrogate ID and carries a unique index (OKL_CNSLD_AR_STRMS_B_U1) on that same column, its heuristic Data Vault classification is hub-leaning. In a Data Vault modeling exercise, this object would best be treated as a hub, with its descriptive numeric and status columns (amount, tax, assessment dates) and its _ALL table counterparts modelled as satellites.

Key Information Stored

The following columns carry the semantic weight of the table:

• ID — Surrogate primary key (OKL_CNSLD_AR_STRMS_B_PK) and the sole documented business-key candidate via unique index OKL_CNSLD_AR_STRMS_B_U1.
• LLN_ID — Foreign key to OKL_CNSLD_AR_LINES_B, tying the stream to its parent consolidated AR line.
• KHR_ID / KLE_ID — Foreign keys to OKL_K_HEADERS and OKL_K_LINES, identifying the lease contract header and line that generated the transaction.
• STY_ID — Foreign key to OKL_STRM_TYPE_B, defining the stream type (for example, rent, interest, fee, tax).
• AMOUNT — The monetary value of the individual stream.
• TAX_AMOUNT — The tax component calculated for the stream.
• RECEIVABLES_INVOICE_ID — Link to the Oracle Receivables invoice created for the consolidated bill.
• LATE_CHARGE_ASSESS_DATE / LATE_INT_ASSESS_DATE — Dates on which late charges and late interest were assessed.
• LATE_CHARGE_ASS_YN / LATE_INT_ASS_YN — Flags indicating whether late charges or late interest apply.
• PAY_STATUS_CODE — Payment settlement status of the stream.
• INVESTOR_DISB_STATUS / INVESTOR_DISB_ERR_MG / DATE_DISBURSED / SEL_ID — Investor disbursement state, error messaging, disbursement date, and selection identifier.
• ORG_ID — Multi-org operating unit discriminator.
• OBJECT_VERSION_NUMBER — Optimistic locking control column.

Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the ATTRIBUTE_CATEGORY/ATTRIBUTE1..15 flexfield set are also present.

Common Use Cases and Queries

This table is queried primarily for reconciliation and reporting of consolidated billing and investor disbursement. A typical pattern joins the stream to its parent line, header, and contract to reconstruct the billed amount by contract:

• Reporting consolidated receivable amounts by lease contract and stream type.
• Reconciling the OKL billing output against the Oracle Receivables invoice via RECEIVABLES_INVOICE_ID.
• Auditing late charge and late interest assessment activity.
• Tracking investor disbursement status and error messages for securitization or funding reconciliation.

A representative query:

SELECT s.ID, s.AMOUNT, s.TAX_AMOUNT, s.PAY_STATUS_CODE,
       h.KHR_ID, t.STY_ID
FROM   OKL_CNSLD_AR_STRMS_B s,
       OKL_K_HEADERS h,
       OKL_STRM_TYPE_B t
WHERE  s.KHR_ID = h.ID
AND    s.STY_ID = t.ID
AND    s.ORG_ID = :org_id;

Related Objects

The most significant related objects, derived from the documented foreign key relationships, are:

• OKL_CNSLD_AR_LINES_B — parent line via OKL_CNSLD_AR_STRMS_B.LLN_ID.
• OKL_K_HEADERS and OKL_K_LINES — contract header and line via KHR_ID and KLE_ID.
• OKL_STRM_TYPE_B — stream type reference via STY_ID.
• OKL_TXL_RCPT_APPS_B and OKL_TXL_RCPT_APPS_ALL_B — receivable applications referencing this table via LSM_ID.
• OKL_TXL_AP_INV_LNS_B and OKL_TXL_AP_INV_LNS_ALL_B — AP invoice lines referencing via LSM_ID.
• OKL_XTL_CSH_APPS_B / OKL_XTL_CSH_APPS_ALL_B and OKL_XTL_SELL_INVS_B — cash applications and sell invoices referencing via LSM_ID.