Search Results ozf_process_setup_all_u1

Overview

OZF_PROCESS_SETUP_ALL is a transactional setup table in the Oracle E-Business Suite Order-to-Cash (OZF) schema, owned by the Trade Management / Price Protection module. It stores the Price Protection Execution process setup details, recording whether individual Price Protection processes are enabled or disabled and whether they run automatically or manually. Each row corresponds to a configuration record scoped to a supplier trade profile and an operating unit, making the table a control point that governs how Price Protection execution behaves at runtime.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, consistent with standard transactional setup data. Under the heuristic Data Vault classification mined from the foreign key structure, the object is treated as standalone, meaning it neither behaves as a canonical hub, link, nor satellite in a pure Data Vault model. In practice, it functions as a reference/setup entity keyed by its own surrogate primary key, referenced by surrounding operational logic rather than acting as a central integration point.

Key Information Stored

The most significant columns capture process configuration and multi-tenant context:

• PROCESS_SETUP_ID — Numeric surrogate primary key that uniquely identifies a process setup record. It is the single column behind the unique index OZF_PROCESS_SETUP_ALL_U1 (type NORMAL, uniqueness UNIQUE, tablespace APPS_TS_TX_IDX), making it the documented business-key candidate.
• SUPP_TRADE_PROFILE_ID — Foreign reference to the supplier trade profile in OZF_SUPP_TRD_PRFLS, binding the process setup to a specific supplier relationship.
• ORG_ID — Operating unit identifier, enforcing multi-org data segregation.
• PROCESS_CODE — VARCHAR2(30) code identifying which Price Protection process the row configures.
• ENABLED_FLAG — VARCHAR2(30) indicating whether the process is enabled or disabled.
• AUTOMATIC_FLAG — Indicates whether the process executes automatically or requires manual invocation.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS, the only documented foreign key relationship.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) columns (ATTRIBUTE1–9 shown at VARCHAR2(150)) allowing customer-defined extensions.
• OBJECT_VERSION_NUMBER — Standard concurrent-update control column.
• WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and CREATED_FROM for audit and concurrent program traceability.

The table contains 34 documented columns in total, the majority being the attribute flexfield and WHO audit columns.

Common Use Cases and Queries

Typical queries retrieve the enabled and automatic settings for a supplier trade profile within a given operating unit, supporting setup verification, troubleshooting, and reporting on Price Protection execution behavior.

• Retrieve active process configuration: SELECT process_code, enabled_flag, automatic_flag FROM ozf.ozf_process_setup_all WHERE supp_trade_profile_id = :p AND org_id = :org AND enabled_flag = 'Y';
• Look up a single record by surrogate key: SELECT * FROM ozf.ozf_process_setup_all WHERE process_setup_id = :id;
• Join to security groups via SECURITY_GROUP_ID to validate access group membership.
• Report on manual-versus-automatic distribution: group by automatic_flag to assess automation coverage across processes.
• Audit changes using LAST_UPDATE_DATE and LAST_UPDATED_BY for change-tracking reports.

Because ORG_ID is present, queries should always filter by operating unit to respect multi-org security.

Related Objects

• OZF.OZF_SUPP_TRD_PRFLS — Supplier trade profile table; OZF_PROCESS_SETUP_ALL.SUPP_TRADE_PROFILE_ID references it, anchoring each setup to a supplier profile.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; the sole documented foreign key target.
• OZF_PROCESS_SETUP_ALL_U1 — The unique index on PROCESS_SETUP_ID enforcing the primary key constraint.
• FND Design Data (OZF.OZF_PROCESS_SETUP_ALL) — The registration entry that governs the object within the Application Object Library.
• OZF Price Protection Execution processes — The concurrent and execution processes whose runtime behavior is controlled by PROCESS_CODE, ENABLED_FLAG, and AUTOMATIC_FLAG settings stored in this table.

Collectively, these relationships confirm the table as a self-contained setup entity, keyed by PROCESS_SETUP_ID and consumed by Price Protection execution logic rather than functioning as a transitive link between core business entities.