Search Results execute_translation
Overview
GCS_CONS_ENG_UTILITY_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Financial Consolidation Hub (FCH) product family, identified by the GCS prefix, which governs consolidation processing across legal entities, balancing segments, and management reporting hierarchies. The package functions as a supporting utility layer beneath the primary consolidation engine, GCS_CONS_ENGINE_PKG, providing reusable helper routines for balance handling, translation, elimination processing, adjustment validation, journal creation, and workflow notification. Its classification in the ETRM repository is OTHER, indicating it is an internal implementation package rather than a published public API. The package is documented as VALID in the ETRM metadata and exposes fourteen procedures and functions, all designed to be called programmatically rather than through a user-facing interface.
Key Procedures and Functions
The documented procedures and functions are grouped by consolidation activity:
- EXECUTE_MODULE — orchestrates the execution of a specific consolidation module within a run.
- EXECUTE_TRANSLATION — performs currency translation for consolidation entities requiring it.
- CHECK_TRANSLATION_REQUIRED — determines whether translation must be applied for a given entity or run.
- BALANCES_PROCESSOR — processes balance records as part of the consolidation data flow.
- ELIMINATIONS_PROCESSOR — drives the elimination entry generation logic between related entities.
- CHECK_ADJ_REQUIRED and EXTRACT_MANUAL_ADJ — validate the need for adjustments and extract manual adjustment data respectively.
- CATEGORY_EXISTS and CHECK_MAX_CATEGORY — validate category definitions and limits against the consolidation category setup.
- GET_CONS_ENTITY_WF_INFO and GET_OPER_ENTITY_WF_INFO — retrieve workflow information for consolidation and operating entities.
- UPDATE_PROCESS_STATUS — maintains the status of consolidation processing steps.
- CREATE_INITIALIZING_JOURNAL — creates the initializing journal entry for a consolidation run.
- SUBMIT_XML_NTF_PROGRAM — submits the XML notification program for consolidation communications.
Tables Accessed
The package interacts with consolidation configuration, transaction, and run-tracking tables through APPS synonyms. GCS_CONS_ENG_RUNS and GCS_CONS_ENG_RUN_DTLS hold run-level and detail-level execution records. GCS_ENTRY_HEADERS and GCS_ENTRY_HEADERS_S store consolidation journal entries and their statuses. Translation and elimination logic relies on GCS_ELIM_RULES_B, GCS_ELIM_RULE_RELS, GCS_CONS_RELATIONSHIPS, and GCS_ENTITY_CONS_ATTRS. GCS_CATEGORIES_B and GCS_DATASET_CODES support category and dataset validation. GCS_AD_TRANSACTIONS and GCS_CONS_IMPACT_ANALYSES capture adjustment and impact analysis data, while FEM_ENTITIES_ATTR and PLITBLM are referenced for entity attributes and PL/SQL table buffering respectively.
Usage Notes
GCS_CONS_ENG_UTILITY_PKG is invoked indirectly. The ETRM metadata confirms it is referenced by GCS_CONS_ENGINE_PKG and by itself, meaning consolidation engine calls route through these utilities rather than being called by end users. Typical invocation paths include the Financial Consolidation Hub concurrent programs, consolidation workflow activities, and any custom code extending consolidation behavior. Because the package is internal (classification OTHER), Oracle does not guarantee signature stability across patches, so customizations should avoid direct calls and instead extend consolidation through supported setup and extension points.