Search Results oracle_err

Overview

FA_XLA_CMP_CREATE_PKG is a private Oracle Assets (FA) package that provides the runtime APIs required to dynamically generate and deploy PL/SQL package specifications and bodies inside the EBS database. It belongs to the subledger accounting (XLA) infrastructure that Oracle Assets uses to build the accounting program logic linking asset transactions to their generated journal entries. The package name encodes this role: FA (Oracle Assets), XLA (Subledger Accounting), and CMP_CREATE (component creation). Because the package writes source text and then compiles it, it is a metadata-driven code generator rather than a transactional business API.

The header records creation on 25-FEB-2006 by BRIDGWAY under version 120.0, positioned in the FA private package namespace (APPS owner, API classification OTHER). As a private package it is not intended for direct customer invocation; it is called by other Oracle Assets components during setup and upgrade activities that construct the generated accounting programs. The package is referenced by one other package, consistent with a narrow internal contract.

Key Procedures and Functions

• CREATESPECPACKAGE — Constructs and issues the DDL that creates the specification portion of a generated package. It assembles the declaration section into valid source lines and pushes them to the database.
• CREATEBODYPACKAGE — Constructs and issues the DDL that creates the body portion of the generated package, emitting the executable definitions corresponding to the specification built by CREATESPECPACKAGE.
• PUSH_DATABASE_OBJECT — Submits the assembled source for creation of the database object, handling the mechanics of getting generated text into the data dictionary as a compiled, valid object.
• EXECUTE_DML — Executes dynamically built DML statements through native dynamic SQL, used to drive the source-generation and deployment steps.

Supporting private constants govern this generation: C_CREATED and C_CREATED_ERROR signal object state, g_Max_line (225) bounds line length, g_chr_quote and g_chr_newline control text formatting (the newline value sourced from FA_CMP_STRING_PKG), and the G_LEVEL_* constants bind the package to FND_LOG diagnostic levels from LEVEL_STATEMENT through LEVEL_UNEXPECTED.

Tables Accessed

All referenced objects resolve through APPS synonyms:

• DBMS_SQL — Provides the dynamic SQL engine used to parse and execute generated DDL and DML.
• USER_SOURCE — Read to inspect existing generated package text and to verify what was written.
• USER_OBJECTS — Queried to confirm object existence and validity after creation.
• USER_ERRORS — Read to retrieve compilation errors when a generated package fails to compile, supporting diagnosis.
• PLITBLM — Internal PL/SQL table used as the in-memory buffer for accumulated source lines before deployment.

Usage Notes

Invocation is indirect and administrative. The package runs during Oracle Assets subledger accounting setup, during patch or upgrade application, and wherever a generated accounting program must be (re)built. Because it compiles stored code at runtime, it requires privileges sufficient to create objects in the APPS schema and should only be exercised through supported Oracle-delivered processes, never by ad hoc customer calls. Failures typically surface as compilation errors in USER_ERRORS or as ORA-06508/ORA-04068 style errors when downstream generated packages are invalid; the FND_LOG constants allow tracing at statement, procedure, event, exception, error, and unexpected levels. In the context of the search term "fa_shared_oracle_err," this object is relevant when Oracle error text from generated or compiled subledger accounting packages must be traced back to the FA code-generation layer.