Search Results fnd_oam_dscfg_objects

Overview

FND_OAM_DSCFG_OBJECTS is a configuration repository owned by the APPLSYS schema within the FND — Application Object Library product. It stores Data Scrambling Intermediate Configuration Object definitions used by the Oracle E-Business Suite Data Scrambling engine. Each row represents a discrete operation that the scrambling engine must perform, together with one or more properties that specify the operation type and its parameters. Because the table captures the intermediate representation of a scrambling configuration before execution, it functions as the working blueprint that drives packet generation, masking, and data transformation activities across a cloned or non-production environment.

The object is classified as VALID in the reference environment and is documented with sixteen columns in the 12.2.2 physical schema. From a heuristic Data Vault modeling perspective, FND_OAM_DSCFG_OBJECTS is best treated as a standalone structure — a self-contained table rather than a classic hub, link, or satellite. It does, however, carry a foreign key to AMS_DM_TARGETS_B, which introduces a dependent relationship worth noting when mapping to a raw vault model.

Key Information Stored

• OBJECT_ID — Surrogate primary key that uniquely identifies each configuration object row. A unique index, FND_OAM_DSCFG_OBJECTS_U1, enforces this as the documented business-key candidate.
• CONFIG_INSTANCE_ID — Identifies the configuration instance to which the object belongs, allowing multiple scrambling configurations to coexist.
• OBJECT_TYPE — Defines the category of the operation the engine will execute.
• PARENT_OBJECT_ID — Self-referencing column that establishes hierarchical grouping of objects under a parent operation.
• SOURCE_PROC_ID and SOURCE_TYPE — Identify the source processing context and the type of source object.
• SOURCE_ID — References the specific source entity from which data is drawn.
• TARGET_TYPE and TARGET_ID — Specify the destination object type and identifier. TARGET_ID carries a foreign key to AMS_DM_TARGETS_B.
• ERRORS_FOUND_FLAG and MESSAGE — Record validation outcome and diagnostic text generated during processing.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and last modified each row and when.

Common Use Cases and Queries

Administrators and technical consultants query this table to audit the composition of a scrambling configuration before executing a data masking run. A typical inspection lists all objects tied to a configuration instance:

• SELECT object_id, object_type, source_type, target_type, errors_found_flag FROM fnd_oam_dscfg_objects WHERE config_instance_id = :instance_id;
• Joining to AMS_DM_TARGETS_B on TARGET_ID resolves the physical target definition for each operation.
• Filtering on ERRORS_FOUND_FLAG = 'Y' surfaces objects that failed validation, with MESSAGE providing the reason.
• Hierarchy reporting uses a self-join on PARENT_OBJECT_ID = OBJECT_ID to reconstruct nested operation groups.

Reporting use cases include configuration completeness checks, post-run error reconciliation, and documentation of masking scope for compliance audits.

Related Objects

• AMS_DM_TARGETS_B — Referenced by FND_OAM_DSCFG_OBJECTS.TARGET_ID; supplies target definitions for scrambling operations.
• FND_OAM_DSCFG_OBJECTS (self-reference) — PARENT_OBJECT_ID links child operations to parent objects.
• FND_OAM_DSCFG_PROPERTIES — Companion table holding the property/parameter details for each configuration object.
• FND_OAM_DSCFG_INSTANCES — Parent configuration instance referenced through CONFIG_INSTANCE_ID.
• FND_OAM_DS_* family — Additional Data Scrambling tables that share the APPLSYS schema and support execution and logging.