Search Results create_and_submit_prview_list

Overview

APPS.FEM_UD_PKG is a PL/SQL package in the Oracle E-Business Suite Applications schema that supports the Undo and Preview framework of Oracle Enterprise Performance Foundation / Enterprise Resource Management (ETRM), the data management and mapping engine underlying applications such as Oracle Financial Consolidation Hub and Oracle Profitability Manager. The package is classified as an OTHER API rather than a public interface, meaning it is invoked primarily by other ETRM components rather than by external integrations. Its central responsibility is the management of an "undo list" — a persistent record of the balance and object executions that a processing list, preview run, or mapping operation has performed — so that those actions can subsequently be validated, reversed, or repaired. In this sense FEM_UD_PKG provides the transactional safety net that allows administrators to roll back a partially completed processing request without corrupting the underlying FEM_BALANCES data.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions, organised around a small number of functional clusters:

• Candidate management — ADD_CANDIDATE, REMOVE_CANDIDATE, GENERATE_CAND_DEPENDENTS and REPORT_CAND_DEPENDENTS build and interrogate the set of candidate objects eligible for undo, including their dependent objects.
• Undo list lifecycle — CREATE_UNDO_LIST, DELETE_UNDO_LIST, EXECUTE_UNDO_LIST, SUBMIT_UNDO_LISTS and VALIDATE_CANDIDATES create, validate, and execute the undo list itself.
• Undo execution at object and request level — PERFORM_UNDO_ACTIONS, UNDO_OBJECT_EXECUTION and UNDO_ALL_OBJ_EXECS_IN_REQUEST reverse the effects of individual object executions or of every execution associated with a processing request.
• Preview processing — CREATE_AND_SUBMIT_PRVIEW_LIST and INSERT_PREVIEW_CANDIDATES generate a preview list and populate its candidates before submission.
• Housekeeping and repair — DELETE_BALANCES, REMOVE_PROCESS_LOCKS, REPAIR_PL_REQUEST, SET_PROCESS_STATUS and GET_PUT_MESSAGES handle balance removal, stale lock cleanup, request repair, status updates, and message retrieval.

Tables Accessed

The package reads and writes a broad set of ETRM configuration and transactional tables through APPS synonyms. FEM_PL_REQUESTS and FEM_PL_CHAINS hold the processing request and processing chain definitions against which undo and repair operations are scoped. FEM_PL_OBJECT_DEFS, FEM_OBJECT_CATALOG_B, FEM_OBJECT_CATALOG_TL, FEM_OBJECT_DEFINITION_B, FEM_OBJECT_DEFINITION_TL and FEM_OBJECT_TYPES_B supply the object metadata used to resolve candidates and their dependents, while FEM_OBJDEF_HELPER_RULES provides rule-based helper logic. FEM_DIM_ATTRIBUTES_B, FEM_DIM_ATTR_VERSIONS_B, FEM_XDIM_DIMENSIONS_VL and FEM_DS_INPUT_OUTPUT_DEFS describe dimension attributes and data-source inputs and outputs. FEM_BALANCES is the principal transactional target, modified or deleted during undo and balance-deletion routines. FEM_MP_PROCESS_CTL_T provides process control and locking, FEM_NUMBER_TABLE is an internal numeric collection, and FND_USER is referenced to attribute requests and audit actions to a user.

Usage Notes

FEM_UD_PKG is not intended for direct invocation by end users or custom applications. It is called by ETRM's own processing-list engine, by FEM_MAPPING_PREVIEW_UTIL_PKG for mapping preview operations, and by FTP_TP_PKG. In practice the package is triggered when an administrator submits a processing request through the ETRM processing-list interface and subsequently elects to undo, preview, or repair that request; SUBMIT_UNDO_LISTS and CREATE_AND_SUBMIT_PRVIEW_LIST submit the resulting work as concurrent requests. The package also references itself recursively, reflecting its layered internal helpers. Because it manipulates FEM_BALANCES directly, any custom use should be treated as unsupported and preceded by a full backup of the affected balances and processing requests.