Search Results cst_acct_lib_packages




Overview
Explore in AI Chat

Overview

CST_ACCT_LIB_PACKAGES is a configuration and mapping table owned by the BOM schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the associations between a GAAP accounting library and the PL/SQL package that must be invoked for a specific transaction event during the periodic distribution process. In effect, the table acts as a dispatch registry: when the Cost Management or Receiving accounting engine distributes accounting for a given event, it consults this table to determine which accounting program to execute for the selected accounting library.

The table is classified as VALID and is a core control table within the BOM - Bills of Material product family, although its operational relevance extends into the Cost Management and Receiving subledger accounting flows. From a data modeling perspective, the metadata's heuristic Data Vault classification is link. This suggests modeling the table as a relationship (link) entity resolving the many-to-many associations among accounting libraries, accounting packages, and receiving accounting event types, rather than as a transactional hub or descriptive satellite.

Key Information Stored

The documented physical schema contains 13 columns. The most significant are the three business keys plus the edition discriminator and the standard audit columns.

The unique index CST_ACCT_LIB_PACKAGES_U1 is defined over (ACCOUNTING_LIB_ID, ACCOUNTING_PACKAGE_ID, EVENT_TYPE_ID, ZD_EDITION_NAME). This composite constitutes the business-key candidate and enforces that a given library-to-package mapping for a given event type is unique within an edition. No separate surrogate primary key column is documented beyond this composite; the composite unique index effectively serves as the row's business identifier.

Common Use Cases and Queries

Typical uses include auditing which accounting packages are active for each GAAP library, troubleshooting periodic distribution failures by confirming a package is registered for the failing event type, and validating configuration after a patch or upgrade.

  • List all packages configured for a library: SELECT p.ACCOUNTING_PACKAGE_ID, e.EVENT_TYPE_ID FROM CST_ACCT_LIB_PACKAGES p, RCV_ACCOUNTING_EVENT_TYPES e WHERE p.EVENT_TYPE_ID = e.EVENT_TYPE_ID AND p.ACCOUNTING_LIB_ID = :lib_id;
  • Detect orphan or duplicate mappings using GROUP BY on the business-key columns.
  • Reconcile the configured set of packages against CST_ACCOUNTING_PACKAGES to find library references pointing to inactive packages.
  • Compare associations across editions using ZD_EDITION_NAME as a filter for EBR-aware environments.

Related Objects

  • CST_ACCOUNTING_LIBRARIES — joined via ACCOUNTING_LIB_ID; defines the GAAP libraries referenced here.
  • CST_ACCOUNTING_PACKAGES — joined via ACCOUNTING_PACKAGE_ID; holds the callable PL/SQL packages.
  • RCV_ACCOUNTING_EVENT_TYPES — joined via EVENT_TYPE_ID; enumerates the receiving accounting events driving periodic distribution.
  • CST_ACCOUNTING_LIBRARIES / CST_ACCOUNTING_PACKAGES — parent tables whose keys form the composite unique index with EVENT_TYPE_ID and ZD_EDITION_NAME.
  • SLA and Cost Management distribution programs that consume these associations during periodic distribution processing.