Search Results arrx_cogs_rep_inner




Overview
Explore in AI Chat

Overview

ARRX_COGS_REP_INNER is an internal PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It supports the Cost of Goods Sold (COGS) reporting functionality within Oracle Receivables, providing the procedural engine that assembles COGS data by matching revenue recognition records in Receivables against corresponding inventory cost records. The package name includes the suffix "_INNER," indicating that it is a helper or implementation package rather than a standalone API; it is typically called by an outer wrapper package that handles parameter validation, concurrent program registration, and output formatting.

The package is classified as VALID in the ETRM repository and is an "OTHER" API classification, meaning it is not part of Oracle's published public API surface. Documented subprograms number three: POPULATE_ROWS, GET_COST, and POPULATE_SUMMARY. The package is not referenced by any database object, but is itself referenced by one other package, consistent with its role as a subordinate implementation unit.

Key Procedures and Functions

  • POPULATE_ROWS — Drives the primary data collection pass. It reads transaction and distribution records, matches Receivables revenue lines against the corresponding interface cost rows, and populates the working data set that feeds the COGS report output.
  • GET_COST — Retrieves the item cost applicable to a given transaction line. It resolves cost information from inventory valuation data so that each revenue line can be paired with its associated cost of goods sold amount.
  • POPULATE_SUMMARY — Aggregates the detail rows produced by the other subprograms into summary-level totals suitable for report presentation, applying grouping and totaling logic across the collected records.

No parameter lists are documented for these subprograms; callers should not assume a callable interface, as the package is intended for internal invocation by its parent package.

Tables Accessed

The package reads and writes a defined set of application tables via APPS synonyms, spanning Receivables, Inventory, and general ledger data:

Usage Notes

ARRX_COGS_REP_INNER is an internal implementation package and is not intended for direct invocation by customer code. It is called by a single parent package (the outer COGS reporting wrapper), which in turn is typically launched from a Receivables concurrent program or a report submission path. Customers requiring COGS reporting should invoke the supported concurrent program or the parent package rather than this body directly.

Because the package writes to AR_COGS_REV_ITF, any direct execution outside the parent flow risks leaving orphaned interface rows requiring cleanup. For diagnostics, developers may query the package source to understand report logic, but modifications should be avoided since the package falls outside Oracle's supported API boundary. Behavior is consistent across 12.1.1 and 12.2.2, with no documented structural differences between the two releases.