Search Results fem_ds_input_output_defs




Overview
Explore in AI Chat

Overview

FEM_BR_DATASET_GROUP_PVT is a private PL/SQL package body within the Oracle Enterprise Tax, Regulatory, and Treasury Management (ETRM) / Enterprise Performance Foundation application in Oracle E-Business Suite. Its principal business function is to manage the lifecycle of Dataset Group Rule definitions used in the Profitability Manager and related analytical engines. A Dataset Group represents a logical grouping of input datasets that feed downstream rule processing, allocations, and modeling computations. This package provides the internal implementation logic that supports the deletion and duplication of these dataset group definitions and their associated input dataset mappings.

The package is classified as a Private (PVT) API, meaning that it is not intended to be called directly by external consumers. Instead, it is invoked by the public wrapper packages that expose the validated, user-facing CRUD operations for Dataset Group objects. The naming convention (FEM_BR_ prefix, _PVT suffix) confirms its role as a business rule internal package within the FEM schema family.

Key Procedures and Functions

The documentation identifies two public procedures, supported by four private procedures defined in the package specification section.

  • DeleteObjectDefinition — Removes all detail records associated with a Dataset Group Rule Definition identified by the object definition ID. Internally it delegates to the private procedures DeleteDatasetGroup and DeleteInputDatasets, ensuring both the group header and its associated input dataset mappings are purged consistently. The procedure wraps its logic in an exception handler that logs errors via FND_MSG_PUB.Add_Exc_Msg using the package name and API name for diagnostics.
  • CopyObjectDefinition — Duplicates an existing Dataset Group Rule Definition into a new object definition, preserving the source structure. It relies on the private procedures CopyDatasetGroup and CopyInputDatasets to replicate both the group metadata and the input dataset associations, including the created_by and creation_date audit attributes passed through to the target definition.

The four private procedures — DeleteDatasetGroup, DeleteInputDatasets, CopyDatasetGroup, and CopyInputDatasets — carry out the granular work of maintaining the header and detail records respectively. DeleteDatasetGroup and CopyDatasetGroup operate on the FEM_DS_INPUT_LISTS grouping records, while DeleteInputDatasets and CopyInputDatasets manage the FEM_DS_INPUT_OUTPUT_DEFS detail mappings.

Tables Accessed

  • FEM_DS_INPUT_LISTS — Stores the header records for input dataset list groupings associated with a Dataset Group Rule definition. This table is the primary target of the group-level delete and copy operations.
  • FEM_DS_INPUT_OUTPUT_DEFS — Holds the detailed input/output definition mappings that link each input dataset to its corresponding output or target within the dataset group. This table is the target of the detail-level delete and copy operations and is the object most directly associated with the user's search term "fem_ds_input_output_defs".
  • FEM_INPUT_LIST_ITEM_NUM_SEQ — An Oracle sequence used to generate unique item numbers for input list items during the copy or insert processing, ensuring that newly created or duplicated detail rows receive valid, non-colliding sequence identifiers.

Usage Notes

As a private package, FEM_BR_DATASET_GROUP_PVT is not invoked directly by end users or by concurrent programs. It is called by the corresponding public package (typically FEM_BR_DATASET_GROUP_PUB) which is in turn invoked from the ETRM Profitability Manager administrative forms when an administrator creates, copies, or deletes a Dataset Group Rule definition. The copy capability is commonly used to clone existing rule configurations as templates for new analytical models, while the delete capability supports clean-up of obsolete or test dataset group definitions.

Customizations that require programmatic manipulation of Dataset Group definitions should call the public wrapper APIs rather than this private package, to ensure that validation, security, and message handling are properly applied. The package references only APPS synonyms and follows standard EBS exception logging conventions through FND_MSG_PUB, making it consistent with other FEM business rule packages in the 12.1.1 and 12.2.2 releases.