Search Results create_package

Overview

The APPS.GCS_BUILD_FEM_POSTING_PKG package is a metadata-generation utility within the Oracle E-Business Suite financial consolidation and Enterprise Performance Foundation (FEM) architecture. Its documented purpose is narrow and infrastructural: it builds the database object GCS_DYN_FEM_POSTING_PKG, a dynamically generated PL/SQL package used by the consolidation engine to post balances and transactional data into the FEM repository. In the context of EBS 12.1.1 and 12.2.2, the package therefore functions not as a business API that end users invoke directly, but as a DDL generator that produces the runtime posting package based on the configuration of the consolidation environment.

The header comment identifies the creation date as 12-OCT-2003 and the source revision as a shared (noship) development version, confirming the object's lineage as part of the original GCS (Global Consolidation System) to FEM integration layer.

Key Procedures and Functions

ETRM documentation for this package lists exactly one documented procedure:

• CREATE_PACKAGE — The sole entry point of the package. Its documented purpose is to create the GCS_DYN_FEM_POSTING_PKG object. It accomplishes this by assembling DDL statements and executing them, generating the dynamic posting package that the consolidation engine subsequently calls at runtime. No parameter list is published in the metadata; callers should treat it as a generator routine whose behavior derives from the current consolidation configuration rather than from explicit arguments.

The package also declares a single public constant, g_line_size, initialized to 250. This constant governs the line width used when the generated package source is written, ensuring that emitted DDL or PL/SQL text conforms to the generator's formatting assumptions.

Tables Accessed

The documented table reference is AD_DDL, accessed through an APPS synonym. AD_DDL is the Oracle Applications DDL execution facility, a standard utility in the AD (Applications DBA) schema used to run data definition statements that cannot be issued through ordinary DML. In this package, AD_DDL is the mechanism by which the generated CREATE PACKAGE statements for GCS_DYN_FEM_POSTING_PKG are actually applied to the database. The generator composes the source text, then routes the resulting DDL through AD_DDL for execution, which keeps the operation consistent with Oracle's supported DDL-handling conventions in EBS.

Usage Notes

Because it manipulates DDL, GCS_BUILD_FEM_POSTING_PKG is not designed for high-frequency or concurrent invocation. Typical usage patterns include:

• Consolidation setup changes — When the configuration of a consolidation or FEM posting environment is modified, the dynamic posting package must be regenerated, and this package is the documented mechanism for doing so.
• Post-patch or post-upgrade maintenance — After applying patches or upgrades that affect the FEM posting structures, the dynamic package may require rebuilding; the generator is invoked as part of that maintenance sequence.
• Indirect invocation — ETRM records that the package is referenced by one other package, indicating it is normally called programmatically rather than from a form or concurrent program directly. Administrators should prefer invoking the calling routine or the documented setup flow rather than calling CREATE_PACKAGE in isolation.

Practitioners should note that successful execution requires appropriate privileges on AD_DDL and that the generated package's validity depends on the completeness of the underlying consolidation metadata at generation time.