Results for “migrated_hdr”

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

Overview

JAI_CMN_STFORM_HDRS_ALL is a table owned by the JA schema and validated within the Asia/Pacific Localizations product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the header information for sales tax discount forms covering both vendors and customers. These forms support localization requirements for countries in the Asia/Pacific region where tax authorities require documented evidence of sales tax discounts on transactions.

Based on the documented foreign key structure, this object exhibits a hub-leaning profile in a Data Vault modeling sense. Its role as a central anchor—referenced by multiple detail and transaction tables while pointing to parties, party sites, and organizations—positions it as a natural hub candidate in a dimensional or Data Vault design.

Key Information Stored

• ST_HDR_ID — The surrogate primary key (JAI_CMN_STFORM_HDRS_ALL_PK) uniquely identifying each form header record.
• PARTY_ID — References HZ_PARTIES; identifies the vendor or customer associated with the form.
• PARTY_SITE_ID — References HZ_PARTY_SITES; identifies the specific party site.
• FORM_TYPE — Classifies the type of sales tax discount form. This column participates in the unique key (JAI_CMN_STFORM_HDRS_ALL_UK) alongside PARTY_ID, PARTY_SITE_ID, ORG_ID, and PARTY_TYPE_FLAG.
• ORG_ID — References HR_ALL_ORGANIZATION_UNITS; the operating unit context for the record.
• PARTY_TYPE_FLAG — Distinguishes vendor versus customer, supporting the dual-purpose nature of the form.
• MIGRATED_HDR — Flags records migrated from legacy or prior systems.
• OBJECT_VERSION_NUMBER — Enables optimistic locking for concurrent update control.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record creation and modification.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all tax discount forms for a given party, verifying the existence of a form before processing a transaction, and reconciling form headers with their detail lines. Because this table sits at the head of a header-detail hierarchy, joins to JAI_CMN_ST_FORM_DTLS are routine.

A representative query retrieving headers for a specific party and operating unit:

• SELECT h.ST_HDR_ID, h.PARTY_ID, h.FORM_TYPE, h.PARTY_TYPE_FLAG FROM JA.JAI_CMN_STFORM_HDRS_ALL h WHERE h.PARTY_ID = :party_id AND h.ORG_ID = :org_id;

Detail aggregation for a header:

• SELECT d.* FROM JA.JAI_CMN_ST_FORM_DTLS d WHERE d.ST_HDR_ID = :st_hdr_id;

Locating migrated records for data validation:

• SELECT ST_HDR_ID, PARTY_ID FROM JA.JAI_CMN_STFORM_HDRS_ALL WHERE MIGRATED_HDR = 'Y';

Because the table is partitioned by ORG_ID contextually and carries standard audit columns, Multi-Org access and audit trail reporting are common requirements.

Related Objects

• JAI_CMN_ST_FORMS — References this table via ST_HDR_ID; holds the parent form definition linkage.
• JAI_CMN_ST_FORM_DTLS — Detail lines referencing this table via ST_HDR_ID.
• JAI_CMN_ST_MATCH_DTLS — Matching details referencing this table via ST_HDR_ID.
• JAI_AR_TRX_CM_T — Transaction comment table referencing this header through OE_ST_ID.
• HZ_PARTIES — Source of PARTY_ID party information.
• HZ_PARTY_SITES — Source of PARTY_SITE_ID site information.
• HR_ALL_ORGANIZATION_UNITS — Source of ORG_ID operating unit information.