Search Results cst_accounting_libraries_u1

Overview

BOM.CST_ACCOUNTING_LIBRARIES is a seed-data configuration table in the Oracle E-Business Suite Cost Management module. It stores information about the accounting libraries that the application invokes during the periodic distribution process for GAAP accounting. Each row describes an available accounting library, the cost method for which that library is valid, and the PL/SQL package that implements the library logic. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the APPS_TS_SEED tablespace with PCT Free of 10, reflecting its role as reference data installed and maintained by the application rather than transactional data created by end users.

The table is owned by the BOM schema and is registered as FND Design Data BOM.CST_ACCOUNTING_LIBRARIES. From a dimensional modeling perspective, the mined relationship data classifies this object as hub-leaning. That classification should be treated as a modeling suggestion: the table behaves as a hub of stable, uniquely identified accounting library definitions, referenced by foreign keys from dependent detail tables. The unique index CST_ACCOUNTING_LIBRARIES_U1, defined on ACCOUNTING_LIB_ID and ZD_EDITION_NAME, is the strongest documented business-key candidate and also supports the primary key access path CST_ACCOUNTING_LIBRARIES_PK on ACCOUNTING_LIB_ID.

Key Information Stored

The table contains fifteen documented columns. The most important are:

• ACCOUNTING_LIB_ID (NUMBER) — the unique identifier and primary key for each accounting library row.
• LIB_NAME (VARCHAR2(15)) — the short name of the accounting library.
• DESCRIPTION (VARCHAR2(240)) — the descriptive text explaining the purpose of the library.
• COST_METHOD_ID (NUMBER(15)) — the cost method identifier for which the library can be used; this governs which library applies to a given costing configuration.
• LIB_PKG_NAME (VARCHAR2(100)) — the name of the PL/SQL package that executes the library during periodic distribution.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Who columns recording audit information.
• PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, REQUEST_ID — extended Who columns capturing the concurrent program context that last modified the row.
• ZD_EDITION_NAME (VARCHAR2(30)) — the edition name supporting the online patching (editioning) architecture introduced in EBS 12.2. This column is part of the unique index CST_ACCOUNTING_LIBRARIES_U1 and is a key discriminator in 12.2.2, where multiple editions of the same seed row may coexist.

Common Use Cases and Queries

Typical use cases include reporting the set of accounting libraries available for each cost method, verifying that the correct PL/SQL package is configured for GAAP distribution, and validating the mapping between cost methods and libraries before running periodic costing processes. A common query pattern joins the table to itself or filters by cost method:

• SELECT LIB_NAME, DESCRIPTION, LIB_PKG_NAME FROM BOM.CST_ACCOUNTING_LIBRARIES WHERE COST_METHOD_ID = :cost_method_id;
• Selecting rows for a specific library by primary key: WHERE ACCOUNTING_LIB_ID = :lib_id;
• In 12.2.2, filtering by ZD_EDITION_NAME to isolate the active edition or compare editions across a patch cycle.
• Reporting the audit trail via CREATION_DATE, LAST_UPDATE_DATE and the extended Who columns to identify when a library definition was last changed and by which concurrent request.

Because this is seed data, direct DML is not recommended; support and configuration changes are normally delivered through patching or Oracle-provided scripts.

Related Objects

The following objects reference or depend on CST_ACCOUNTING_LIBRARIES:

• BOM.CST_ACCT_LIB_PACKAGES — references ACCOUNTING_LIB_ID within CST_ACCOUNTING_LIBRARIES; stores package-level details associated with each accounting library.
• BOM.CST_LE_COST_TYPES — references ACCOUNTING_LIBRARY_ID within CST_ACCOUNTING_LIBRARIES; associates legal entity cost types with accounting libraries.
• BOM.CST_ACCOUNTING_LIBRARIES# — the editioning view or backing object used in the 12.2 architecture, referenced by the base table definition.

Queries that need library names alongside cost type assignments should join CST_ACCOUNTING_LIBRARIES to CST_LE_COST_TYPES on ACCOUNTING_LIB_ID = ACCOUNTING_LIBRARY_ID, and to CST_ACCT_LIB_PACKAGES on ACCOUNTING_LIB_ID. These join paths follow the documented foreign-key relationships and are the most reliable way to traverse the object graph around this hub table.