Search Results dimension_varchar_label




Overview
Explore in AI Chat

Overview

The APPS.FEM_REFRESH_UTIL_PKG package body is a utility component within the Oracle Enterprise Business Suite (EBS) Enterprise Performance Foundation (now Enterprise Resource Planning Integrator / ETRM) schema. Its documented purpose is to support the Refresh engine when it returns the FEM (Financial Enterprise Management) database to its install state. Specifically, the package contains procedures that delete obsolete seeded data which would otherwise be reintroduced by the refresh process through the Layer Distribution Tool (LDT) files.

The package is classified as an OTHER API type in the ETRM 12.1.1 metadata, indicating it is not a public application programming interface intended for customer consumption. It is an internal maintenance utility owned by APPS. The header comment notes that the LDT files for backports are targeted — the main LDT file retains obsolete rows — making a dedicated deletion utility necessary to prevent stale seed data from being re-populated during refresh operations.

Key Procedures and Functions

Only one procedure is documented in the ETRM metadata for this package body:

No public functions are documented. The procedure is the sole entry point exposed by this package body.

Tables Accessed

The ETRM metadata lists fifteen tables referenced via APPS synonyms. These fall into several functional groups:

The tables are accessed primarily for delete operations, with the cursor performing a read against FEM_DIM_ATTRIBUTES_B to drive the attribute deletions.

Usage Notes

This package is invoked by the Refresh engine rather than directly by end users or standard concurrent programs. Its procedures are called when the refresh process returns the FEM database to its install state, ensuring that obsolete seeded rows do not persist after refresh. Because the main LDT files for backports still contain obsolete rows, the deletion logic in DEL_OBSOLETE_SEED_DATA is required to clean them out after LDT repopulation.

The metadata reports that the package is referenced by zero other packages, confirming it is a terminal utility called only from the refresh framework. It is not exposed through Oracle Forms or standard concurrent program interfaces. The x_status OUT parameter suggests the caller inspects the result to determine success or failure of the deletion sequence. Custom code should not invoke this package directly, as its behavior is tied to specific patch and backport levels and may change across EBS releases. The presence of FEM_DIM_ATTRIBUTES_B in the cursor reflects the package's role in managing optional versus required dimension attribute states across upgrades.