Search Results ozf_sd_res_header_intf_u1

Overview

The OZF.OZF_SD_RES_HEADER_INTF table is an interface (staging) table within the Oracle E-Business Suite Trade Management (OZF) schema. It holds vendor and distributor response header details received as part of a supplier response document. In the context of Oracle EBS 12.1.1 and 12.2.2, this table sits at the boundary between external supplier integration and the internal OZF supplier/distributor data model. Response documents arriving from vendors — carrying quote acknowledgements, authorization numbers, and organizational contact data — are loaded into this table before validation and transfer into the base transactional tables.

The table is owned by the OZF schema and resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10. Its status is VALID, and the FND Design Data registration is OZF.OZF_SD_RES_HEADER_INTF. The documented physical schema defines 65 columns. According to the heuristic Data Vault classification mined from the foreign key structure, this object is classified as standalone. In Data Vault modeling terms, it behaves closest to a staging or raw interface construct rather than a true hub, link, or satellite; there are no participating child foreign keys, so it should be modeled as a source staging entity feeding downstream hubs and satellites.

Key Information Stored

The table is anchored by its surrogate primary key, RES_HEADER_INTF_ID, which is also enforced as the business-key candidate through the unique index OZF_SD_RES_HEADER_INTF_U1 on the same column. Because the primary key and the unique index cover the same single column, no separate natural business key is documented; the interface row identity is therefore system-assigned.

• GLBDOCFUNCCODE — identifies the function of the response document.
• REQDOCID — the internal document number at the vendor end.
• REQDOCDATETIME / THISDOCGENDTTIME — the date and time the document was generated.
• BLANKET_FLAG — indicates whether the originating request was a blanket request.
• SUPP_QUOTE_NUMBER — the original supplier quote number sent with the request.
• AUTH_NUMBER — the authorization number returned by the vendor.
• REQUEST_NUMBER — the internal request identifier linking the response to its originating request.
• FROMROLE_* columns — the vendor-side party details, including FROMROLE_B_BNAME (vendor name), FROMROLE_CINFO_CTNAME/EMAIL/TEL_NUMBER (vendor contact), FROMROLE_GLBPRTRCCODE (global partner classification), FROMROLE_P_BUSDESC_GLBBUSID and FROMROLE_P_BUSDESC_GLBSUPPCODE (business identifiers and supply chain description), and FROMROLE_P_PLOC_* address fields.
• TOROLE_* columns — the distributor-side (to-role) party details mirroring the same structure.
• PROCESSED_FLAG / ERROR_TXT — processing status and error diagnostics from the concurrent import.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard EBS descriptive flexfield columns.

Common Use Cases and Queries

Typical usage centers on monitoring inbound supplier response loads and diagnosing failures. A common pattern is to find unprocessed or errored rows before rerunning the import concurrent program:

• Pending record check: SELECT RES_HEADER_INTF_ID, REQUEST_NUMBER, SUPP_QUOTE_NUMBER, PROCESSED_FLAG FROM OZF.OZF_SD_RES_HEADER_INTF WHERE PROCESSED_FLAG = 'N';
• Error reporting: SELECT RES_HEADER_INTF_ID, REQDOCID, ERROR_TXT FROM OZF.OZF_SD_RES_HEADER_INTF WHERE PROCESSED_FLAG = 'E' OR ERROR_TXT IS NOT NULL;
• Vendor response reconciliation: joining on REQUEST_NUMBER or SUPP_QUOTE_NUMBER to match responses to the originating request and confirm AUTH_NUMBER capture.
• Supplier contact reporting: aggregating FROMROLE_B_BNAME, FROMROLE_CINFO_EMAIL, and FROMROLE_P_PLOC_CITY for vendor contact directories.

Because the table is an interface, SQL against it is typically read-only for reporting; writes are performed by the OZF supplier response import program that populates the base trading tables.

Related Objects

The documented relationship data classifies this object as standalone with no participating foreign keys. The following objects are significant in the surrounding flow:

• OZF_SD_RES_HEADER_INTF_PK — the primary key constraint on RES_HEADER_INTF_ID.
• OZF_SD_RES_HEADER_INTF_U1 — the unique index on RES_HEADER_INTF_ID in APPS_TS_TX_IDX.
• OZF_SD_REQ_HEADER_INTF — the request-side interface table whose REQUEST_NUMBER is logically matched to responses in this table.
• OZF_SD_LINES_RES_INTF / OZF_SD_RES_LINES_INTF — line-level response interface tables sharing the response header context.
• OZF_SUPPLIER_QUOTES / OZF_QUOTES — base supplier quote tables that eventually receive validated response data.
• FND_FLEX_VALUES — backing store for the ATTRIBUTE_CATEGORY/ATTRIBUTE1–15 flexfield segments.