Search Results cst_revenue_recognition_lines

Overview

CST_REVENUE_RECOGNITION_LINES is a table owned by the BOM (Bills of Material) schema in Oracle E-Business Suite, holding the latest revenue recognition percentage for a given order management line per accounting period. Despite residing in the Bills of Material product, its function is closely tied to the revenue recognition and cost accounting flows that connect Order Management, Receivables, and the inventory/costing engine. The table records a periodic snapshot of revenue recognition progress against a sales order line, enabling downstream processes to associate earned revenue amounts with the correct Open Management (OM) line and accounting period.

From a heuristic Data Vault modeling perspective, this object is best classified as a link. Its structure resolves a relationship between an order line and a receivables transaction line, timed to an accounting period, rather than simply describing a single business entity. The composite unique index CST_REV_REC_LINES_U1 on (REVENUE_OM_LINE_ID, ACCT_PERIOD_NUM) reinforces this by defining the grain of the record: one recognition percentage per order line per period.

Key Information Stored

The documented schema spans 18 columns. The most significant are as follows:

• REVENUE_OM_LINE_ID — Foreign key to OE_ORDER_LINES_ALL; identifies the order management line whose revenue is being recognized. It forms the leading column of the unique business key.
• ACCT_PERIOD_NUM — The accounting period to which the recognition percentage applies; the second column of the unique key CST_REV_REC_LINES_U1.
• REVENUE_RECOGNITION_PERCENT — The latest recognition percentage recorded for the line in that period.
• CUSTOMER_TRX_LINE_ID — Foreign key to RA_CUSTOMER_TRX_LINES_ALL, linking the recognition record to the corresponding receivables invoice line.
• POTENTIALLY_UNMATCHED_FLAG — A flag indicating records that may not have been reliably matched to their source transaction, useful in reconciliation reporting.
• LAST_EVENT_DATE — The date of the last recognition-related event for the line.
• OPERATING_UNIT_ID and LEDGER_ID — Org and ledger context for multi-org and multi-ledger environments.
• INVENTORY_ITEM_ID — The item associated with the recognition record.

The surrogate primary key is not separately documented; the business-key candidate is the unique index CST_REV_REC_LINES_U1. Standard audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) and concurrent request columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) complete the definition.

Common Use Cases and Queries

Typical usage centers on revenue recognition reporting, reconciliation between order lines and receivable lines, and period-end close. A common query retrieves the current recognition percentage for an order line:

• SELECT REVENUE_OM_LINE_ID, ACCT_PERIOD_NUM, REVENUE_RECOGNITION_PERCENT FROM CST_REVENUE_RECOGNITION_LINES WHERE REVENUE_OM_LINE_ID = :order_line_id;
• Joining to OE_ORDER_LINES_ALL to identify unmatched or partially recognized lines for a given period.
• Aggregating recognition percentages by LEDGER_ID or OPERATING_UNIT_ID for management reporting.
• Filtering on POTENTIALLY_UNMATCHED_FLAG to isolate records requiring investigation during close.

Related Objects

The most significant related objects, based on documented foreign keys and typical dependencies, include:

• OE_ORDER_LINES_ALL — joined via REVENUE_OM_LINE_ID; the source sales order line.
• RA_CUSTOMER_TRX_LINES_ALL — joined via CUSTOMER_TRX_LINE_ID; the receivables invoice line.
• OE_ORDER_HEADERS_ALL — reached through the order line for header-level reporting.
• RA_CUSTOMER_TRX_ALL — the invoice header for receivables context.
• GL_PERIODS / period reference — used to interpret ACCT_PERIOD_NUM.