Search Results post_data_slice

Overview

FEM_MULTI_PROC_PKG is a core infrastructure package in the Oracle EBS Financial Services Enterprise Performance Foundation (FEM) and Profitability Manager (PFT) modules. Its primary business function is to provide a generic, multi-object parallel processing framework used by loaders, migration utilities, and post-processing engines across the FEM and PFT schemas. The package orchestrates the distribution of large data volumes into manageable "data slices" that can be processed concurrently, manages sub-request submission to the concurrent manager, tracks processing status, and logs messages per sub-request. By abstracting these mechanics, FEM_MULTI_PROC_PKG enables dependent loader and profitability packages to scale efficiently against high-volume enterprise data sets without reimplementing concurrency logic.

Key Procedures and Functions

The documented package exposes six procedures. Their design follows a master/worker pattern:

• MASTER — The entry point that coordinates the overall multi-process run. It initializes the processing context and dispatches work across sub-requests.
• SUB_REQUEST — Executes the work assigned to an individual parallel sub-request, acting as the worker invoked by each concurrent child request.
• GET_DATA_SLICE — Retrieves the next slice of data to be processed, supporting the partitioning of large data sets into discrete units.
• POST_DATA_SLICE — Persists processing results or status for a completed data slice back to the database.
• POST_SUBREQ_MESSAGES — Records informational or error messages associated with a sub-request for review and diagnostics.
• DELETE_DATA_SLICES — Cleans up data slice records after processing completes, maintaining the integrity and performance of the underlying control tables.

Tables Accessed

The package reads and writes several control and metadata tables accessed through APPS synonyms:

• FEM_MP_DATA_SLICES and FEM_MP_DATA_SLICE_COLS — store the slice definitions and the column mappings that define each unit of parallel work.
• FEM_MP_OBJ_STEP_METHODS — maps object processing steps to the PL/SQL methods invoked during a run.
• FEM_MP_PROCESS_ARGS_T, FEM_MP_PROCESS_CTL_T, and FEM_MP_PROCESS_OPTIONS — hold runtime arguments, control state, and configuration options for each process execution.
• FEM_OBJECT_CATALOG_B — provides metadata about the objects being processed.
• FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS — used to submit and monitor the concurrent child requests that perform the parallel work.
• ALL_TAB_COLUMNS, DBMS_DESCRIBE, DBMS_SESSION, DBMS_UTILITY, PLITBLM, and USER_SYNONYMS — provide dynamic SQL support, session control, and runtime introspection.

Usage Notes

FEM_MULTI_PROC_PKG is not typically invoked directly by end users. It is a shared service consumed by eleven dependent packages, including FEM_COMP_DIM_MEMBER_LOADER_PKG, FEM_DATAX_LOADER_PKG, FEM_DIMENSION_MIGRATION_PKG, FEM_DIM_MEMBER_LOADER_PKG, FEM_SOURCE_DATA_LOADER_PKG, FEM_UD_PKG, FEM_XGL_POST_ENGINE_PKG, PFT_ACCTRELCONS_PUB, PFT_AR_ENGINE_PVT, PFT_PROFCAL_PROSP_IDENT_PUB, and PFT_PROFCAL_VALIDX_PUB, as well as recursive use by itself. In practice, it is invoked when these loaders and profitability engines launch concurrent processing from forms, concurrent programs, or custom code. Because it drives concurrent manager submissions, proper setup of FND_CONCURRENT_PROGRAMS and request tracking is essential. Administrators reviewing long-running FEM or PFT loads, diagnosing sub-request errors, or tuning parallelism should examine the slice and sub-request message tables populated by this package. It is valid and present in both EBS 12.1.1 and 12.2.2.