Search Results okl_xtl_sell_invs_b

Overview

The OKL_XTL_SELL_INVS_B table is a core transaction table within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. It serves as the primary repository for "bill" type transactions, which are financial transactions where cash receipts are expected from customers. This table is integral to the accounts receivable and revenue recognition processes for lease and finance contracts, acting as the system of record for invoiced amounts that are due. Its role is to store the detailed transactional data that feeds into downstream financial reporting and cash application processes within the broader Oracle EBS financial architecture.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's primary key and foreign key relationships define its critical data elements. The table is uniquely identified by a primary key column, ID, which is enforced by the constraint OKL_XTL_SELL_INVS_B_PK. The foreign key relationships reveal the table's central role in linking transactional data to other key entities. Key reference columns include ILL_ID (linking to Receivables transaction lines in RA_CUSTOMER_TRX_LINES_ALL), LSM_ID (linking to consolidated receivable streams in OKL_CNSLD_AR_STRMS_B), TIL_ID (linking to transactional invoice lines in OKL_TXL_AR_INV_LNS_B), and TLD_ID (linking to transactional line details in OKL_TXD_AR_LN_DTLS_B). These relationships indicate the table stores identifiers that connect a bill transaction to its source contract line, its consolidated accounting stream, and its detailed invoice components.

Common Use Cases and Queries

This table is central to queries involving billed revenue, customer invoices, and receivable aging within the leasing context. Common operational and reporting use cases include reconciling billed amounts against cash receipts, analyzing revenue by contract or customer, and supporting month-end close activities for accounts receivable. A typical query pattern would join this table to its related detail and header tables to retrieve a comprehensive invoice record. For example, to list bill transactions with their linked Receivables line information, a query might join on the ILL_ID column.

• Sample Query Pattern: SELECT xsi.*, rctl.trx_line_number FROM okl. OKL_XTL_SELL_INVS_B xsi JOIN ra_customer_trx_lines_all rctl ON xsi.ill_id = rctl.customer_trx_line_id WHERE ...
• Reporting Use Case: Generating a report of all outstanding "bill" transactions (where cash is expected but not yet fully received) for a specific lease portfolio, often joined with OKL_CNSLD_AR_STRMS_B for accounting stream details.

Related Objects

The OKL_XTL_SELL_INVS_B table is a nexus within the OKL transactional schema, with dependencies to both core OKL objects and Oracle Receivables (AR). Key related objects, as defined by its foreign keys, include:

• RA_CUSTOMER_TRX_LINES_ALL: This critical link integrates the lease bill transaction with the standard Oracle Receivables subledger for proper accounting and cash management.
• OKL_CNSLD_AR_STRMS_B: Links the transaction to its consolidated accounting stream for financial reporting.
• OKL_TXL_AR_INV_LNS_B and OKL_TXD_AR_LN_DTLS_B: These tables provide the detailed invoice line information and transactional line details that underlie the bill transaction.
• OKL_XTD_SELL_INVS_B: The table has a recursive foreign key relationship to itself via the XSI_ID_DETAILS column and is also referenced by the OKL_XTD_SELL_INVS_B table via the XLS_ID column, indicating support for hierarchical or detailed transaction structures.