Search Results fnd_oam_dscfg_api_pkg




Overview
Explore in AI Chat

Overview

FND_OAM_DSCFG_API_PKG (Data Scramble Configuration API Package) is a server-side PL/SQL package that belongs to the Oracle Applications Manager (OAM) data scrambling framework within Oracle E-Business Suite. Its business function is to manage the configuration metadata that governs how production data is masked, scrambled, or cloned during controlled operations. Data scrambling is used when EBS administrators need to create a non-production copy of an instance while protecting sensitive information such as personal identifiers, financial data, or credentials.

The package is the programmatic backbone that defines configuration instances, records which database objects participate in a scramble run, stores properties associated with those objects, and assembles the SQL and PL/SQL statements that will ultimately be executed. Because it is an API package, it is deliberately designed to be largely stateless, as noted in the body comments. All meaningful state is persisted in the underlying configuration tables rather than held in package variables, allowing the OAM configuration UI and concurrent programs to call the package from any session.

Key Procedures and Functions

The package exposes approximately thirty documented procedures and functions. Their names map directly onto the configuration lifecycle:

Tables Accessed

The package reads and writes configuration through the APPS synonyms FND_OAM_DSCFG_OBJECTS, which stores the objects registered for scrambling along with their type and processing properties, and FND_OAM_DSCFG_PROPERTIES, which stores the property name/value pairs attached to configurations and objects. Dynamic SQL used to build and execute segment text is handled through the DBMS_SQL package rather than through a repository table.

Usage Notes

FND_OAM_DSCFG_API_PKG is invoked by the OAM Data Scrambling configuration screens and by the concurrent programs that build and execute scramble definitions. It is referenced by six other packages, indicating it is a foundational layer rather than an end-user entry point. Customizations that extend scrambling behavior—particularly those calling ADD_PLSQL_TEXT to inject masking logic—should invoke the package only after confirming that ARE_CONFIG_CHANGES_ALLOWED returns true, so that profile-based enablement and production safeguards are respected.