Search Results populate_rows

Overview

ARRX_COGS_REP_INNER is an internal PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It supports the Cost of Goods Sold (COGS) reporting functionality within Oracle Receivables. Its principal role is to assemble the data set required to reconcile revenue recognized on customer transactions against the inventory and cost-of-goods-sold amounts associated with the underlying sales orders. The package provides the internal engine that populates the reporting interface and summary structures used by the COGS reconciliation report, matching receivable transaction lines to their corresponding inventory material transactions and cost records.

Key Procedures and Functions

The package exposes one function and two procedures, all classified under the OTHER API classification, meaning they are intended for internal consumption by the concurrent program or report that owns the COGS process rather than as a public integration API.

• POPULATE_ROWS — Populates the detailed COGS reconciliation rows. It accepts a GL date range, an optional sales order number range, and filter flags such as "posted lines only" and "unmatched items only", together with the requesting user and concurrent request identifiers. It returns the standard concurrent processing status and error buffer. The searched parameter p_gl_date_low is the lower bound of this GL date range and defines the earliest accounting date included in the extracted detail.
• GET_COST — Returns the cost amount for a given transaction line. It takes an account class, an offset flag, a line identifier, and a base transaction value, and resolves the applicable item cost for that line. It is invoked during row population to derive the cost figure that is compared against the receivable amount.
• POPULATE_SUMMARY — Populates the summarized COGS output, aggregating activity by chart of accounts and GL account range. It also accepts p_gl_date_low and p_gl_date_high as its accounting date boundaries, along with optional GL account low/high filters, the posted-lines-only flag, and the concurrent request context.

Tables Accessed

The package reads and writes through APPS synonyms across several functional areas. Receivables tables — RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_LINE_GL_DIST, and RA_CUST_TRX_LINE_GL_DIST_ALL — supply transactions, lines, and their accounting distributions. Inventory tables — MTL_MATERIAL_TRANSACTIONS, MTL_TRANSACTION_ACCOUNTS, MTL_SYSTEM_ITEMS_B, and MTL_PARAMETERS — provide the shipments and cost accounting entries that establish COGS. Costing data is drawn from CST_ITEM_COSTS. Customer and party information comes from HZ_CUST_ACCOUNTS and HZ_PARTIES. GL_CODE_COMBINATIONS and FND_CURRENCIES support account and currency validation, while AR_SYSTEM_PARAMETERS supplies Receivables setup options. AR_COGS_REV_ITF is the interface table that receives the populated rows, and the summary procedure consolidates results through it.

Usage Notes

This package is not a public API. It is invoked internally by the Receivables COGS reconciliation concurrent program and, indirectly, by the report or form that launches it. One other package references it, confirming it serves as a subordinate layer within the COGS reporting stack. Because p_gl_date_low and p_gl_date_high drive which accounting periods are included, callers must pass valid GL dates within open or closed periods as appropriate for the report's intent. The DEFAULT NULL parameters for sales order, posted-lines-only, unmatched-items-only, and GL account ranges mean those filters are optional; omitting them broadens the result set. Because the package relies on NOCOPY OUT parameters for the return code and error buffer, it follows standard concurrent program calling conventions and should be invoked only from within a concurrent manager context supplying valid user and request identifiers.