Results for “approved_discount_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OZF_SD_RES_PROD_INTF is a Trade Management (OZF) interface table in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to hold the product line detail for a request. In practice this is a staging and reconciliation table within the Trade Management product authorization and resolution workflow, capturing one row per product requested on a trade request line, together with requested and authorized quantities, rejection reasons, and approved discount information. Rows are populated by concurrent programs or external feeds, validated, and then consumed by downstream logic that approves or rejects products against a promotion or deal.

Based on the foreign key structure mined from the data dictionary, the object is classified heuristically as a standalone entity. No dependent foreign keys were identified, so a Data Vault model would most naturally treat it as an independent satellite-like staging structure rather than a hub or link with declared parent relationships. This classification should be treated as a modeling suggestion rather than a physical constraint. The table is owned by the OZF schema and is marked VALID in the EBS data dictionary.

Key Information Stored

The table contains 31 documented columns. The surrogate primary key is RES_PROD_INTF_ID, enforced by the constraint OZF_SD_RES_PROD_INTF_PK, and it is also the single column of the unique index OZF_SD_RES_PROD_INTF_U1, making it both the physical key and the only documented business-key candidate. The identifier columns and the most significant attribute columns are:

• RES_PROD_INTF_ID — surrogate primary key for the product interface row.
• REQUEST_LINE_ID — links the product detail to the parent trade request line; the principal join back to the resolution request structure.
• REQUEST_NUMBER — human-readable request identifier used for reporting and reconciliation.
• PROD_REQUESTED_QUANTITY — quantity of the product originally requested.
• PROD_AUTHORIZED_QUANTITY — quantity actually authorized after evaluation; compared against the requested quantity to derive authorization variance.
• PROD_UOM — unit of measure applicable to the requested and authorized quantities.
• PROD_TYPE — classification of the product line, used to drive processing rules.
• SUPP_PROD_CODE — supplier or supplemental product code identifying the item.
• DESIGN_WIN_NUMBER — design win reference associated with the product line, a key attribute in the Trade Management resolution process.
• APPROVED_DISCOUNT_VALUE, APPROVED_DISCOUNT_TYPE, and APPROVED_DISCOUNT_CURR — the approved discount amount, its type, and its currency respectively.
• PROD_REJECTION_CODE — reason code explaining why a product line was not authorized.
• PROCESSED_FLAG and ERROR_TXT — concurrency status and error messaging for the interface load, indicating whether the row was consumed successfully.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield columns, available for customer-specific extension.

Common Use Cases and Queries

The primary use case is reconciling requested versus authorized product quantities for a trade request, and reporting on rejection reasons and approved discounts. A typical audit query compares the requested and authorized quantities and filters on unprocessed rows:

• SELECT REQUEST_NUMBER, REQUEST_LINE_ID, SUPP_PROD_CODE, PROD_REQUESTED_QUANTITY, PROD_AUTHORIZED_QUANTITY, PROD_REJECTION_CODE FROM OZF.OZF_SD_RES_PROD_INTF WHERE PROCESSED_FLAG = 'N';
• SELECT REQUEST_LINE_ID, SUM(PROD_AUTHORIZED_QUANTITY * APPROVED_DISCOUNT_VALUE) FROM OZF.OZF_SD_RES_PROD_INTF GROUP BY REQUEST_LINE_ID;
• A variance query joining REQUEST_LINE_ID against the parent request tables to expose authorization shortfalls.

Because the interface table carries ERROR_TXT and PROCESSED_FLAG, support and integration teams also query it to diagnose failed loads, and reporting extracts frequently aggregate approved discount values by PROD_TYPE or DESIGN_WIN_NUMBER.

Related Objects

Since the mined relationship data classifies this table as standalone, no FK-verified parents are documented. The following are the most significant related objects based on the column semantics:

• OZF_SD_RES_INTF (request header interface) — joined via REQUEST_NUMBER or the request-level identifier.
• OZF_SD_RES_INTF_LINES (request line interface) — joined via REQUEST_LINE_ID, the direct parent of the product detail.
• OZF_RESOLUTION_SD and related resolution/resolution-line base tables — the destination objects populated after interface validation.
• OZF_PRODUCT_AUTHORIZATION tables — hold the finalized authorized product and quantity records.
• Standard EBS concurrent programs and APIs (for example, the Trade Management resolution import programs) that read and write this interface table.
• MTL_SYSTEM_ITEMS_B — joined via SUPP_PROD_CODE where the supplier code maps to an inventory item.

Joins should always be validated against the specific 12.1.1 or 12.2.2 instance, because the documented dictionary shows no enforced foreign keys on this standalone interface object.