Search Results transfer_data_to_interface
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:
- SUBMIT_DATASUB — Entry point that submits a data submission job for processing.
- INIT_DATASUB_PROCESS — Initializes the data submission process, establishing the working context for the run.
- CHECK_IDT_REQUIRED — Determines whether an Impact Data/Transfer (IDT) step is required for the submission.
- CHECK_VALIDATION_REQUIRED — Determines whether validation must be executed for the submission.
- UPDATE_AMOUNTS — Updates amount values in the staging/interface structures.
- UPDATE_STATUS — Maintains the processing status of the submission.
- TRANSFER_DATA_TO_INTERFACE — Moves source data into the interface tables for downstream consumption.
- RAISE_IMPACT_ANALYSIS_EVENT — Raises an Oracle Workflow event when impact analysis is needed.
- EXECUTE_VALIDATION — Runs the validation logic against submitted data.
- EXECUTE_IDT — Executes the Impact Data/Transfer step.
- SUBMIT_OGL_DATASUB — Submits a data submission specifically for the Oracle General Ledger (OGL) flow.
- VALIDATE_MEMBER_VALUES — Validates member (dimension) values against defined hierarchies and attributes.
- POPULATE_OGL_DATASUB_DTLS — Populates the OGL data submission detail records.
- HANDLE_UNDO_EVENT — Handles the workflow undo event, reversing or rolling back a submission action.
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.