Results for “manually_entered_flag”

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

Overview

ZX.ZX_PTNR_NEG_TAX_LINE_GT is a global temporary table (GTT) in the Oracle E-Business Tax (ZX) module of Oracle EBS 12.1.1 and 12.2.2. Its documented purpose is to cache a copy of tax lines prior to user modification, and this copy operation is performed exclusively for upgraded tax partner integration scenarios. The table is classified as VALID and is owned by the ZX schema.

The table supports the negative tax line processing workflow associated with tax partner integrations. Because it is a GTT, rows are scoped to a session or transaction and are not persisted beyond the session lifecycle, making it unsuitable as a permanent audit or history store. The heuristic Data Vault classification mined from the FK structure is standalone, meaning the table does not itself function as a central hub or link; instead it behaves as a staging or satellite-style cache whose content is transient by design. This classification is a modeling suggestion only, reflecting the absence of downstream FK dependencies on this object.

Key Information Stored

The table carries 29 documented columns. The most operationally significant include:

• TAX_LINE_ID — Foreign key to ZX_LINES, the principal tax line identifier; effectively the primary business key for a cached row.
• TRX_LINE_ID — Foreign key to CN_TRX_LINES_ALL, linking the cached tax line to its originating transaction line.
• DOCUMENT_TYPE_ID — Foreign key to HR_DOCUMENT_TYPES, identifying the type of source document.
• APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE — Identify the owning application and the tax event context.
• TRX_ID, TRX_LEVEL_TYPE — Identify the parent transaction and the level at which tax applies (line, header, etc.).
• TAX, TAX_AMOUNT, TAXABLE_AMOUNT, TAX_RATE_PERCENTAGE — Core tax computation values captured before override.
• TAX_CURRENCY_CODE, TAX_CURR_TAX_AMOUNT — Currency context of the tax amount.
• USER_OVERRIDE_FLAG, EBIZ_OVERRIDE_FLAG, MANUALLY_ENTERED_FLAG, CANCEL_FLAG, DELETE_FLAG — Status flags tracking whether and how the user altered the cached line.
• EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON, EXEMPT_RATE_MODIFIER — Exemption details preserved from the pre-modification state.

Surrogate versus business key distinctions are not formally documented in the ETRM metadata; TAX_LINE_ID serves pragmatically as the principal identifier, with TRX_LINE_ID offering a secondary join path. No unique index definitions are published in the metadata excerpt provided.

Common Use Cases and Queries

The table is principally relevant to diagnostic and reconciliation work during tax partner integration upgrades. Typical scenarios include comparing the cached pre-modification tax line against the current ZX_LINES record to determine which fields a user overrode.

SELECT g.TAX_LINE_ID, g.TAX_AMOUNT AS cached_amount, l.TAX_AMOUNT AS current_amount
FROM   ZX.ZX_PTNR_NEG_TAX_LINE_GT g, ZX.ZX_LINES l
WHERE  g.TAX_LINE_ID = l.TAX_LINE_ID
AND    g.USER_OVERRIDE_FLAG = 'Y';

Common queries also join to CN_TRX_LINES_ALL via TRX_LINE_ID to reconstruct transaction-level tax behavior, and filter on CANCEL_FLAG or DELETE_FLAG to isolate abandoned lines. Because the table is a GTT, reporting must occur within the same session that populated it; historical reporting should rely on ZX_LINES or related permanent tables instead.

Related Objects

• ZX.ZX_LINES — Primary relationship; joined on TAX_LINE_ID = ZX_LINES.TAX_LINE_ID.
• CN.CN_TRX_LINES_ALL — Transaction line source; joined on TRX_LINE_ID.
• HR.HR_DOCUMENT_TYPES — Document type reference; joined on DOCUMENT_TYPE_ID.
• ZX.ZX_LINES_DET_FACTORS — Frequently consulted alongside for tax determination detail.
• ZX.ZX_TRX_LINE_APP_REGIMES — Application of tax regimes to transaction lines.
• ZX.ZX_RATES_B / ZX.ZX_RATES_TL — Tax rate definitions underlying computed values.
• ZX.ZX_JURISDICTIONS_B / _TL — Jurisdiction reference for TAX_JURISDICTION and SITUS.
• AR/AP/OM tax partner interfaces — Upstream processes invoking the upgraded partner integration path.