Search Results hz_org_profile_val_gt

Overview

HZ_ORG_PROFILE_VAL_GT is an interface (staging) table residing in the AR (Receivables) schema within Oracle E-Business Suite 12.1.1 and 12.2.2. The "_GT" suffix indicates that the object is a global temporary table used to hold transient rows during batch processing. In this context it serves as the inbound staging area for organization profile validation and enrichment data loaded from a third-party business information provider, most commonly Dun & Bradstreet (D&B). Records are staged here before validation logic applies them to the permanent organization profile model in the Trading Community Architecture (TCA), primarily HZ_ORGANIZATION_PROFILES and its child entities. The table is documented with 138 columns and is implemented under the AR product, reflecting the receivables-oriented credit and risk workflow that consumes this data.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as standalone. As a modeling suggestion, this means it functions as a self-contained staging or transient structure rather than participating in a normalized hub, link, or satellite network. The single documented foreign key, TEMP_ID to FV_LOCKBOX_IPA_TEMP, reinforces the batch-load correlation role: each staged profile row is associated with a lockbox/I PA import processing session.

Key Information Stored

The table is dominated by external credit and firmographic attributes. The most significant columns include:

• TEMP_ID — Foreign key to FV_LOCKBOX_IPA_TEMP; correlates the staged record to the parent import batch. This is the primary join control column.
• TEMP_PARTY_ID — Temporary party identifier used to link staged data back to a party record prior to committing to TCA.
• ORGANIZATION_NAME and ORGANIZATION_NAME_PHONETIC — Organization identity and its phonetic match key for fuzzy matching against existing parties.
• DUNS_NUMBER_C and ENQUIRY_DUNS — D&B identifiers that drive external enrichment and de-duplication.
• CREDIT_SCORE, DB_RATING, FAILURE_SCORE, and PAYDEX_SCORE — Core credit risk metrics supplied by the external bureau.
• MAXIMUM_CREDIT_RECOMMENDATION and MAXIMUM_CREDIT_CURRENCY_CODE — Recommended credit exposure and its currency.
• SIC_CODE and LINE_OF_BUSINESS — Industry classification used for risk segmentation.
• DISPLAYED_DUNS_PARTY_ID — Resolved party reference after matching.
• CONTENT_SOURCE_TYPE and CONTENT_SOURCE_NUMBER — Provenance of the supplied profile content.
• ATTRIBUTE_CATEGORY through ATTRIBUTE20 — The standard DFF (descriptive flexfield) block for extensible attributes.
• CREATED_BY_MODULE and APPLICATION_ID — Audit and multi-application context columns.

No unique index or alternate business key is documented beyond the TEMP_ID relationship; the row is identified operationally by the combination of TEMP_ID and TEMP_PARTY_ID during batch processing rather than by a durable surrogate key.

Common Use Cases and Queries

The primary use case is controlled batch loading of external organization profile data into TCA. A typical validation query matches staged DUNS numbers against existing organizations before commit:

• De-duplication: select staged rows where DUNS_NUMBER_C or ORGANIZATION_NAME_PHONETIC collides with an existing HZ_PARTIES record.
• Credit review: extract CREDIT_SCORE, DB_RATING, FAILURE_SCORE, and MAXIMUM_CREDIT_RECOMMENDATION for a given TEMP_ID batch to drive credit limit decisions in Receivables.
• Error reconciliation: compare staged counts against committed counts to detect rejected or unmatched rows.
• Provenance reporting: group by CONTENT_SOURCE_TYPE to justify the origin of each enriched profile attribute.

A representative pattern joins the GT to its parent import session:

• SELECT g.TEMP_PARTY_ID, g.ORGANIZATION_NAME, g.CREDIT_SCORE, g.DB_RATING
• FROM HZ_ORG_PROFILE_VAL_GT g, FV_LOCKBOX_IPA_TEMP t
• WHERE g.TEMP_ID = t.TEMP_ID;

Related Objects

• FV_LOCKBOX_IPA_TEMP — Referenced through HZ_ORG_PROFILE_VAL_GT.TEMP_ID; the parent staging session for the import batch.
• HZ_ORGANIZATION_PROFILES — The permanent destination of validated organization profile attributes in TCA.
• HZ_PARTIES — Holds the party identity resolved through TEMP_PARTY_ID and DISPLAYED_DUNS_PARTY_ID.
• HZ_PARTY_SITES and HZ_LOCATIONS — Address detail associated with the organization profile after commit.
• HZ_CUST_ACCOUNTS — Receivables customer accounts enriched with the credit metrics staged here.
• HZ_ORG_CONTACTS — Contact records for the organization, populated alongside profile validation.

Because the object is a global temporary table, its contents are session- or transaction-scoped, and any integration must extract or process rows within the lifecycle of the loading program before the data is purged.