Search Results fem_setup_pkg




Overview
Explore in AI Chat

Overview

APPS.FEM_SETUP_PKG is a setup and administration package belonging to the Enterprise Tax, Regulatory, and Reporting Management (ETRM) product family in Oracle EBS 12.1.1 and 12.2.2. Its documentation classifies the API as "OTHER," indicating it is not a public, externally supported interface but an internal utility package used to configure and maintain the infrastructure on which ETRM's key flexfield-driven dimensions depend. The package centers on flexfield registration, compilation, validation, and deletion, providing the programmatic plumbing that allows ETRM to define and manage the descriptive and cost key flexfield structures used for reporting, profitability, and cost allocation. The header revision (120.2, dated 2006) shows the package has been stable since the earlier Application Object Library code line and remains available under the APPS schema in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface exposes six procedures and functions:

  • REGISTER_ACTIVITY_FF — Registers the activity key flexfield with ETRM metadata, establishing the relationship between the flexfield and ETRM's setup tables.
  • REGISTER_COST_FF — Registers the cost key flexfield, enabling ETRM cost dimension structures to be recognized by the application.
  • COMPILE_FF — Compiles a registered flexfield structure. It accepts a flexfield name plus flexfield and structure record types (fnd_flex_key_api.flexfield_type and structure_type) and returns a standard API status, message count, and message data.
  • VALIDATE_PROC_KEY — Validates the processing key associated with flexfield setup, guarding against invalid or stale key values before processing proceeds.
  • DELETE_FLEXFIELD — Removes a flexfield definition and its associated ETRM setup metadata. This is the procedure most relevant to the user's search term, as it is the documented mechanism for cleaning up flexfield configurations.

All procedures follow the FND_API convention, accepting an API version, init message list, commit, and encoded flag, and returning x_return_status, x_msg_count, and x_msg_data. Package constants map to fnd_api.g_false, g_true, and the success/error/unexpected return statuses, and logging constants map to the FND_LOG levels for statement, procedure, event, exception, error, and unexpected events.

Tables Accessed

The package reads and writes four documented tables through APPS synonyms:

  • FEM_COLUMN_REQUIREMNT_B — stores column requirement definitions tied to ETRM flexfield structures.
  • FEM_TAB_COLUMN_PROP — holds table and column properties used when registering or compiling flexfield structures.
  • FEM_XDIM_DIMENSIONS — maintains the extended dimension definitions mapped to registered flexfields.
  • FND_ID_FLEX_STRUCTURES — the Oracle Application Object Library structure repository that records the flexfield structure being registered, compiled, validated, or deleted.

Usage Notes

Because this is an internal "OTHER" API, it is typically invoked during ETRM setup and patching rather than from end-user forms. It is referenced by three other packages, indicating it acts as a shared setup utility called by higher-level ETRM configuration routines. Custom code and migration scripts may call these procedures directly for flexfield administration, but they should be treated as unsupported and exercised with p_init_msg_list and p_commit set to fnd_api.g_true so that errors are surfaced and changes are committed. The DELETE_FLEXFIELD procedure should be used with caution, as it removes flexfield metadata that other ETRM setup records depend on.