Results for “allow_offset_tax_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
ZX_PARTY_TAX_PROFILE_INT is the interface (staging) table used by Oracle E-Business Tax (product code ZX) in Oracle EBS 12.1.1 and 12.2.2 to hold party tax profile records prior to validation and import into the base tax repository. It acts as the inbound landing zone for data loaded from external systems, legacy conversions, or bulk maintenance processes, and is consumed by the E-Business Tax party tax profile import programs. Records are keyed by a batch identifier and request identifier so that multiple concurrent or historical load runs can coexist, and each row carries both a DML_TYPE (to indicate insert, update, or delete intent) and a RECORD_STATUS to track the processing outcome of that row.
Under a heuristic Data Vault classification, this object is best modeled as a link, because its primary documentary foreign key (PARTY_TAX_PROFILE_ID) points to the base table ZX_PARTY_TAX_PROFILE and the interface itself carries an INTF_PTP_REFERENCE correlation key rather than a natural business key of its own. It should be regarded as a transient staging link rather than a durable hub or satellite, since rows are purged or archived once import completes.
Key Information Stored
The table contains 28 documented columns. The most significant are grouped as follows:
- Batch and processing control: BATCH_ID, REQUEST_ID, DML_TYPE, RECORD_STATUS, ERROR_NUMBER — used to group a load run, tie it to a concurrent request, and record per-row outcome.
- Interface correlation keys: INTF_PTP_REFERENCE, INTF_PARTY_REFERENCE, INTF_PARTY_SITE_REFERENCE — the external-system identifiers used to reconcile staged rows back to the source extract.
- Party identification: PARTY_TYPE_CODE, PARTY_ID, PARTY_NAME.
- Registration attributes: REGISTRATION_NUMBER, COUNTRY_CODE, COUNTRY_NAME, REGISTRATION_TYPE_CODE, REGISTRATION_TYPE_NAME.
- Tax configuration attributes: PROCESS_FOR_APPLICABILITY_FLAG, ROUNDING_LEVEL_CODE/NAME, ROUNDING_RULE_CODE/NAME, INCLUSIVE_TAX_FLAG, TAX_CLASSIFICATION_CODE/NAME, ALLOW_OFFSET_TAX_FLAG.
- Extension slots: PROG_INT_CHAR1 and PROG_INT_NUM1 for caller-specific values.
- Target surrogate reference: PARTY_TAX_PROFILE_ID, the FK to ZX_PARTY_TAX_PROFILE.
The documented foreign key is ZX_PARTY_TAX_PROFILE_INT.PARTY_TAX_PROFILE_ID → ZX_PARTY_TAX_PROFILE. The metadata does not document a distinct surrogate primary key or unique business index; BATCH_ID plus INTF_PTP_REFERENCE is the practical composite business key candidate for de-duplicating staged rows.
Common Use Cases and Queries
Typical uses are pre-import validation, error triage on failed loads, and reporting on registration and rounding defaults pending import. A representative query lists unprocessed rows for a batch:
SELECT batch_id, intf_ptp_reference, party_name, record_status, error_number FROM zx.zx_party_tax_profile_int WHERE batch_id = :p_batch AND record_status = 'ERROR';SELECT dml_type, COUNT(*) FROM zx.zx_party_tax_profile_int WHERE request_id = :p_req GROUP BY dml_type;SELECT i.party_name, i.registration_number, p.party_tax_profile_id FROM zx.zx_party_tax_profile_int i JOIN zx.zx_party_tax_profile p ON i.party_tax_profile_id = p.party_tax_profile_id;
Such queries support reconciliation of source extracts against imported party tax profiles and identification of rows rejected for missing or invalid registration data.
Related Objects
- ZX_PARTY_TAX_PROFILE — base party tax profile table; joined on PARTY_TAX_PROFILE_ID.
- ZX_PARTY_TAX_PROFILE_INT loaders — the concurrent import program that reads this interface and writes the base table.
- ZX_REGISTRATIONS — destination for registration number and type attributes carried on the interface.
- ZX_PARTY_TAX_PROFILE_INT error reporting views used by E-Business Tax concurrent program output.
- HZ_PARTIES / HZ_PARTY_SITES — source of PARTY_ID, PARTY_NAME, and site references validated at import.
- FND_CONCURRENT_REQUESTS — links REQUEST_ID to the originating import run.
-
Interface Table to store the Party Tax Profile Records
-
This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities.
-
This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities.