Results for “credit_rating_id”

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

Overview

HZ_IMP_CREDITRTNGS_SG is a TCA (Trading Community Architecture) internal staging table owned by the AR (Receivables) schema in Oracle E-Business Suite. It functions as a processing intermediate that holds records loaded into HZ_IMP_CREDITRTNGS_INT, the corresponding TCA interface table for credit rating imports. In the standard TCA bulk import flow, external data is first populated into the _INT interface table and then moved into the _SG staging table where the import program derives or validates party identification before writing to the base HZ_CREDIT_RATINGS entity table. The object is classified as VALID in the ETRM 12.2.2 repository, with the physical schema documented under the AR owner.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is standalone. This is a modeling suggestion rather than an enforced designation; the table lacks a proper hub or link topology because its business keys are the composite party/credit-rating references rather than a single identity. Analysts building a Data Vault representation should treat it as a staging satellite attached to a party hub, rather than a durable enterprise entity.

Key Information Stored

The documented physical schema exposes nine columns. The following are the most operationally significant:

• BATCH_ID — groups rows belonging to a single import run, enabling batch-level reconciliation and retry.
• BATCH_MODE_FLAG — indicates the processing mode (typically insert versus update) applied to the batch.
• ACTION_FLAG — per-row action code controlling whether the record is inserted, updated, or ignored during validation.
• ERROR_FLAG — flags rows that failed validation and require correction before promotion to base tables.
• INT_ROW_ID — ties the staging row back to the originating HZ_IMP_CREDITRTNGS_INT record.
• PARTY_ORIG_SYSTEM — the source system that originated the party record.
• PARTY_ORIG_SYSTEM_REFERENCE — the originating system's native identifier for the party; a key business-key candidate used to resolve the party.
• PARTY_ID — the resolved TCA party identifier linking the rating to a specific party.
• CREDIT_RATING_ID — the foreign key into HZ_CREDIT_RATINGS, carrying the rating value being staged.

The surrogate primary key is not separately enumerated in the documented metadata; the effective logical key is the combination of party resolution attributes (PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE) with the credit rating reference. The single documented foreign key — CREDIT_RATING_ID referencing HZ_CREDIT_RATINGS — anchors the row to the base credit rating definition.

Common Use Cases and Queries

The principal use case is monitoring and troubleshooting TCA credit rating imports. A typical reconciliation query counts staged rows by batch and error state:

• SELECT BATCH_ID, ERROR_FLAG, COUNT(*) FROM HZ_IMP_CREDITRTNGS_SG GROUP BY BATCH_ID, ERROR_FLAG;
• Identifying unresolved parties: SELECT * FROM HZ_IMP_CREDITRTNGS_SG WHERE PARTY_ID IS NULL;
• Joining staged rows to the target rating definition: SELECT s.*, r.* FROM HZ_IMP_CREDITRTNGS_SG s JOIN HZ_CREDIT_RATINGS r ON s.CREDIT_RATING_ID = r.CREDIT_RATING_ID;

Because _SG tables are transient by design — rows are purged once the import completes — reporting should be performed during or immediately after batch runs, and not used as a system of record.

Related Objects

• HZ_CREDIT_RATINGS — the base entity table; joined via CREDIT_RATING_ID.
• HZ_IMP_CREDITRTNGS_INT — the interface table whose records feed this staging table via INT_ROW_ID.
• HZ_PARTIES — the party entity resolved through PARTY_ID.
• HZ_ORIG_SYSTEMS — validates the PARTY_ORIG_SYSTEM code.
• HZ_PARTY_SITES and related TCA party tables — downstream dependents of resolved party identity.
• HZ_IMP_* family of TCA import interface and staging tables — the broader import framework this object participates in.