Search Results gcs_datasub_wf_pkg




Overview
Explore in AI Chat

Overview

GCS_DATASUB_WF_PKG is an Oracle EBS Applications (APPS) schema PL/SQL package that supports the Data Submission workflow within the Enterprise Performance Foundation / Enterprise Resource Planning data integration framework, commonly delivered as part of the ETRM (Enterprise Tax and Reporting Management) or related financial consolidation and enterprise data management family of products. Its principal business function is to orchestrate the submission of financial data — most notably balances and budget information held in the FEM (Financial Enterprise Management) tables — into interface staging areas where it can be validated, transformed, and transferred to downstream targets. The package integrates tightly with Oracle Workflow: it declares a dependency on WF_EVENT_T and raises workflow events such as an impact analysis event, allowing the data submission process to be managed as a controlled, event-driven business flow rather than a simple batch job. The "_WF_" infix in its name signals this Workflow coupling. In status VALID on both 12.1.1 and 12.2.2, it may be called directly or from a wrapper that triggers the workflow process.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. Their documented purposes are:

Tables Accessed

The package reads and writes a set of FEM-prefixed application tables accessed through APPS synonyms. Balance and budget data are handled via FEM_BAL_INTERFACE_T and FEM_BUDGETS_B. Calendar and period context come from FEM_CAL_PERIODS_ATTR and FEM_CAL_PERIODS_B. Organizational structures are drawn from FEM_CCTR_ORGS_ATTR, FEM_CCTR_ORGS_HIER, FEM_COMPANIES_B, and FEM_ENTITIES_B. Dimension and account metadata are supplied by FEM_DIMENSION_GRPS_B, FEM_DATASETS_ATTR, FEM_EXT_ACCT_TYPES_ATTR, and FEM_GLOBAL_VS_COMBO_DEFS. Currency conversion and encumbrance references use FEM_DL_TRANS_CURR and FEM_ENCUMBRANCE_TYPES_B, while FEM_INTG_BAL_RULES supplies the integration balance rules that govern how amounts flow into the interface.

Usage Notes

GCS_DATASUB_WF_PKG is typically invoked indirectly through the Data Submission concurrent program or workflow process rather than by end users. Forms that trigger a submission call SUBMIT_DATASUB or SUBMIT_OGL_DATASUB, launching a Workflow process that in turn calls initialization, validation, IDT, transfer, and status-update routines. The event-raising routines (RAISE_IMPACT_ANALYSIS_EVENT, HANDLE_UNDO_EVENT) are called from the Workflow engine. The package is referenced by itself (recursive internal calls) and by no other documented packages, so changes should be made cautiously. Because all dependencies resolve through APPS synonyms to FEM and standard objects, the package remains portable across 12.1.1 and 12.2.2.