Search Results process_data_slice

Overview

FEM_XGL_POST_ENGINE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the Enterprise Tax, Risk and Treasury Management (ETRM) product family — specifically the Financial Enterprise Management (FEM) module, historically associated with Enterprise Performance Foundation (EPF) and Financial Consolidation Hub (FCH) processing. The package implements the posting engine that transfers summarized balance data from the FEM balance interface into the general ledger posting structures. In EBS 12.1.1 and 12.2.2, the package is classified as an OTHER API, meaning it is an internal engine rather than a formally published public interface, and its status is VALID in a standard installation.

The engine reads staged balances from the interface and interim global temporary structures, resolves dimension member and hierarchy definitions, and applies the mapping rules that determine how FEM balances are translated to GL postings. It is a supporting component used during balance upload, transfer, and posting cycles for financial consolidation and performance management flows.

Key Procedures and Functions

ETRM documents two callable units in this package:

• MAIN — The primary entry point for the posting engine. It orchestrates the overall posting run, driving the processing sequence for the balance data being transferred and coordinating the other internal steps required to complete a posting cycle.
• PROCESS_DATA_SLICE — Processes a defined slice of data within the run. This unit handles the chunked or partitioned portion of the workload, applying the dimension and column mappings to the staged records for that slice.

Parameter lists are not documented in the ETRM metadata, so the exact signatures are not reproduced here.

Tables Accessed

The package references the following tables through APPS synonyms:

• FEM_BAL_INTERFACE_T — The balance interface table holding staged balance records awaiting posting.
• FEM_BAL_POST_INTERIM_GT — A global temporary table holding interim posting results during processing.
• FEM_DIMENSIONS_TL and FEM_DIM_ATTRIBUTES_TL — Dimension and dimension attribute translations used to resolve member labels.
• FEM_GLOBAL_VS_COMBO_DEFS — Global value set and combination definitions controlling valid dimension combinations.
• FEM_INT_COLUMN_MAP — Column mapping metadata that describes how interface columns map to target structures.
• FEM_MP_PROCESS_CTL_T — Process control table used to track posting run status.
• FEM_OBJECT_TYPES_TL, FEM_TAB_COLUMNS_B, FEM_XDIM_DIMENSIONS — Metadata describing object types, table columns, and extended dimensions.
• PLITBLM — A standard Oracle PL/SQL table (index-by table) utility used internally.

Usage Notes

This package is invoked indirectly by FEM balance posting and transfer processes, or by the workflow package GCS_DATASUB_WF_PKG, which is documented as referencing it. It is not intended for direct customer invocation; because it is an internal engine, Oracle does not guarantee interface stability across patch levels. The documented dependency set consists only of SYS.STANDARD at the schema level, confirming it is self-contained within PL/SQL. Customizations should avoid calling MAIN or PROCESS_DATA_SLICE directly and should instead use supported FEM concurrent programs or public APIs that drive the posting engine.