Search Results cst_accounting_libraries




Overview
Explore in AI Chat

Overview

CST_ACCOUNTING_LIBRARIES is an Oracle EBS Bills of Material (BOM) schema table that stores information about the accounting library invoked during the periodic distribution process for GAAP (Generally Accepted Accounting Principles) accounting. In Oracle Cost Management, the periodic distribution process moves cost and accounting entries from source transactions into the general ledger, and the accounting library defines the procedural logic applied to determine how those entries are generated and distributed. Each row in CST_ACCOUNTING_LIBRARIES represents a registered accounting library and its association with a cost method, allowing the application to select the appropriate PL/SQL package at runtime based on the costing configuration.

The table resides in the BOM schema and contains 15 documented columns in the 12.2.2 physical schema. Its primary key, ACCOUNTING_LIB_ID, is defined by the CST_ACCOUNTING_LIBRARIES_PK constraint. A unique index, CST_ACCOUNTING_LIBRARIES_U1, covers ACCOUNTING_LIB_ID and ZD_EDITION_NAME, which reflects the Editioning View mechanism introduced in 12.2 online patching. From a Data Vault modeling perspective, the metadata heuristic classifies this object as hub-leaning: ACCOUNTING_LIB_ID acts as a durable business key, while the two foreign-key relationships (from CST_ACCT_LIB_PACKAGES and CST_LE_COST_TYPES) position it as a referenced hub surrounded by dependent satellite detail.

Key Information Stored

The most significant columns in CST_ACCOUNTING_LIBRARIES are the following:

  • ACCOUNTING_LIB_ID — Surrogate primary key (CST_ACCOUNTING_LIBRARIES_PK) that uniquely identifies each accounting library record and serves as the FK target for dependent tables.
  • LIB_NAME — Descriptive name of the accounting library, used for identification and reporting.
  • DESCRIPTION — Free-text description of the library's purpose or scope.
  • COST_METHOD_ID — References the cost method associated with the library, tying library selection to the costing configuration of the organization.
  • LIB_PKG_NAME — Name of the PL/SQL package that implements the library's accounting logic, invoked at periodic distribution time.
  • CREATION_DATE, CREATED_BY — Audit columns recording insert metadata.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Audit columns recording the most recent modification.
  • PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, REQUEST_ID — Concurrent program context identifying the request that last touched the row.
  • ZD_EDITION_NAME — Editioning column supporting 12.2 online patching and referenced in the unique index.

The unique index CST_ACCOUNTING_LIBRARIES_U1 (ACCOUNTING_LIB_ID, ZD_EDITION_NAME) functions as the documented business-key candidate in the editioned model.

Common Use Cases and Queries

Typical usage centers on resolving which PL/SQL package applies to a given cost method during period close and cost distribution. A representative query joins the library to its cost types:

  • Identify the active library package for a cost method: SELECT cal.ACCOUNTING_LIB_ID, cal.LIB_NAME, cal.LIB_PKG_NAME, clct.COST_TYPE_ID FROM BOM.CST_ACCOUNTING_LIBRARIES cal, BOM.CST_LE_COST_TYPES clct WHERE clct.ACCOUNTING_LIBRARY_ID = cal.ACCOUNTING_LIB_ID;
  • List packages attached to a library: SELECT p.ACCOUNTING_LIB_ID, p.PACKAGE_NAME FROM BOM.CST_ACCT_LIB_PACKAGES p WHERE p.ACCOUNTING_LIB_ID = :lib_id;
  • Audit recent changes using PROGRAM_UPDATE_DATE, REQUEST_ID, and the audit columns for support and reconciliation reporting.

Common scenarios include debugging periodic distribution failures (verifying the correct LIB_PKG_NAME is wired to the cost method), confirming library setup during implementation, and reporting on costing configurations across legal entities.

Related Objects

The following objects depend on or reference CST_ACCOUNTING_LIBRARIES:

  • CST_ACCT_LIB_PACKAGES — Child table joined on ACCOUNTING_LIB_ID; enumerates the packages belonging to each library.
  • CST_LE_COST_TYPES — References the library via ACCOUNTING_LIBRARY_ID, linking cost types to their accounting library.
  • CST_ACCOUNTING_LIBRARIES_PK — The primary key constraint governing ACCOUNTING_LIB_ID.
  • CST_ACCOUNTING_LIBRARIES_U1 — The unique index (ACCOUNTING_LIB_ID, ZD_EDITION_NAME) enforcing uniqueness in the editioned model.
  • Cost Management periodic distribution APIs — Consume LIB_PKG_NAME at runtime to execute GAAP accounting logic.