Search Results fa_xla_cmp_ccid_pkg




Overview
Explore in AI Chat

Overview

FA_XLA_CMP_CCID_PKG is a private Oracle Assets (FA) PL/SQL package owned by the APPS schema. Its stated purpose, per the package header comments, is to contain all the APIs required to create a CCID (Code Combination Identifier) extract for each extract type. The package forms part of the integration layer between Oracle Assets and the Subledger Accounting (XLA) architecture introduced in Oracle E-Business Suite R12. In that architecture, subledger transactions must be mapped to accounting flexfield combinations before they can be transferred to the General Ledger. FA_XLA_CMP_CCID_PKG is the private component responsible for assembling that mapping data in the form of a packaged extract that downstream XLA programs can consume.

The package is declared with AUTHID CURRENT_USER and is classified in the ETRM repository as API classification OTHER, indicating it is not a public, supported extension point but an internal implementation package. The header history records its creation on 25-FEB-2006 by BRIDGWAY, with the current source revision stamped 2009/07/19. The package has remained structurally minimal: it exposes a single documented function.

Key Procedures and Functions

  • GENERATECCIDEXTRACT — The sole documented program unit in the package and the only public entry point. Its role is to produce the CCID extract for a given extract type and return the assembled extract content back to the caller as a collection of VARCHAR2 strings, using the DBMS_SQL.VARCHAR2S associative array type for output. It returns a BOOLEAN indicating success or failure. Because the extract type is supplied as an input, the function is generic across the different extract categories required by the XLA integration, rather than being specialized per category.

No other procedures or functions are documented for this package. The ETRM metadata for 12.2.2 records exactly one documented program unit, matching the package specification shown, which contains no additional declarations beyond GENERATECCIDEXTRACT.

Tables Accessed

The only referenced object recorded in the metadata is DBMS_SQL, the Oracle-supplied PL/SQL package. This reference is structural rather than data-bearing: DBMS_SQL.VARCHAR2S is the datatype used for the output parameter of GENERATECCIDEXTRACT, so the dependency reflects the use of that collection type, not a query against a DBMS_SQL table. No application tables are documented as directly referenced by this package's specification.

In practice, a CCID extract for Oracle Assets must draw on asset accounting line data and the accounting flexfield combination definitions that back it, so the package body would be expected to read FA subledger accounting tables and related code combination sources. However, because the ETRM record for this object does not enumerate those underlying tables, they cannot be asserted as documented dependencies and should be verified against the installed package body before relying on them.

Usage Notes

FA_XLA_CMP_CCID_PKG is a private package and is not intended for direct invocation from forms or from customer extension code. It is invoked from within the Oracle Assets subledger accounting flow as part of the processing that prepares accounting data for transfer to General Ledger. The ETRM metadata records that the package is referenced by one other package, which is consistent with its role as an internal service consumed by a higher-level XLA extraction or accounting program rather than being called by an end-user-facing concurrent program directly.

Because the function returns its result as a PL/SQL collection and a BOOLEAN status, it cannot be called directly from SQL and must be invoked from PL/SQL. Any diagnosis of CCID extract failures should therefore trace the calling XLA program rather than this package alone. As with all APPS-owned private packages, modifications are not supported, and the source revision header should be checked when comparing behavior between 12.1.1 and 12.2.2 environments.