Search Results ar_gta_system_parameters_u1

Overview

The AR.AR_GTA_SYSTEM_PARAMETERS_ALL table is a multi-organization setup table within the Oracle Receivables (AR) schema. It stores the configuration parameters that govern the Golden Tax Adaptor (GTA) module, which supports Chinese Golden Tax (VAT) invoicing requirements. The parameters defined in this table are consumed by several core GTA processes, including the invoice transfer program, the Invoice Workbench form, and the invoice export program. A defining characteristic of this table is its one-row-per-operating-unit design: each ORG_ID is permitted only a single configuration record, ensuring that GTA setup is uniquely scoped to each legal entity or business unit.

From a dimensional modeling perspective, the heuristic Data Vault classification for this object is satellite-leaning. This suggests the table is best modeled as a satellite attached to an operating unit hub, reflecting its role as a collection of descriptive, non-key business attributes (flags, codes, and defaults) that change over time rather than a pure relationship or hub structure. Although the object is documented with a STATUS of VALID and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, the metadata notes that there is no declared primary key on the table; uniqueness is instead enforced through the AR_GTA_SYSTEM_PARAMETERS_U1 unique index.

Key Information Stored

The table contains 22 documented columns. The most operationally significant ones focus on batch numbering, tax configuration, and column-mapping behavior for the export program.

• ORG_ID — Organization identifier. This is the business-key candidate and the sole column of the unique index AR_GTA_SYSTEM_PARAMETERS_U1 (NORMAL, UNIQUE, APPS_TS_TX_IDX tablespace). The metadata also lists it as the documented primary key AR_GTA_SYSTEM_PARAMETERS_PK.
• AUTO_BATCH_NUMBERING_FLAG — Determines whether batch numbers for GTA invoice export are auto-generated ('A') or entered manually ('M').
• NEXT_BATCH_NUMBER — The next batch number to assign when automatic numbering is enabled.
• VAT_TAX_TYPE_CODE — The VAT tax type code, defined via Quick Code in Oracle Receivables.
• TRX_LINE_SPLIT_FLAG — Indicates ('Y'/'N') whether transaction lines below the maximum amount limit are split during the transfer program.
• GT_CURRENCY_CODE — The Golden Tax currency code, matching the GL currency used in the Golden Tax system. This column has a foreign key relationship to FND_CURRENCIES.
• ITEM_NAME_SOURCE_FLAG — Specifies the source of the item name on the GTA invoice: 'R' for Receivable invoice item description or 'C' for Cross Reference.
• CROSS_REFERENCE_TYPE — The cross reference type defined in Oracle Order Management, used when the cross reference source is selected.
• MASTER_ITEM_DEFAULT_FLAG and LATEST_REF_DEFAULT_FLAG — Default indicators controlling master item and latest reference behavior.
• RA_LINE_CONTEXT_CODE, RA_MODEL_ATTRIBUTE_COLUMN, RA_TAX_ATTRIBUTE_COLUMN — Context and attribute mapping columns for Receivables transaction lines during export.
• INV_ITEM_CONTEXT_CODE, INV_MODEL_ATTRIBUTE_COLUMN, INV_TAX_ATTRIBUTE_COLUMN — Equivalent context and attribute mapping columns for inventory item data.
• UNIT_PRICE_SPLIT_FLAG — Controls split behavior for unit price processing.
• Audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN track the record lifecycle.

The surrogate identity is ORG_ID; no separate system-generated surrogate key is documented. The business-key candidate is likewise ORG_ID, enforced by the unique index.

Common Use Cases and Queries

Typical use cases include retrieving and validating GTA setup for a given operating unit prior to running invoice transfer or export processes, and auditing configuration consistency across multiple operating units.

Retrieving setup for a specific operating unit:

SELECT org_id,
       auto_batch_numbering_flag,
       next_batch_number,
       vat_tax_type_code,
       gt_currency_code,
       item_name_source_flag,
       trx_line_split_flag
FROM   ar.ar_gta_system_parameters_all
WHERE  org_id = :p_org_id;

Reporting which organizations use manual batch numbering:

SELECT org_id, next_batch_number
FROM   ar.ar_gta_system_parameters_all
WHERE  auto_batch_numbering_flag = 'M';

Verifying the currency used by the Golden Tax system per organization, joining to the currencies table:

SELECT g.org_id, g.gt_currency_code, c.name
FROM   ar.ar_gta_system_parameters_all g,
       fnd_currencies c
WHERE  g.gt_currency_code = c.currency_code;

Related Objects

• FND_CURRENCIES — Referenced through the foreign key on GT_CURRENCY_CODE; join on AR_GTA_SYSTEM_PARAMETERS_ALL.GT_CURRENCY_CODE = FND_CURRENCIES.CURRENCY_CODE.
• AR_GTA_SYSTEM_PARAMETERS_U1 — The unique index on ORG_ID that enforces one configuration row per operating unit.
• AR_GTA_SYSTEM_PARAMETERS_PK — The documented primary key constraint on ORG_ID.
• Oracle Receivables Quick Codes — Source of the VAT_TAX_TYPE_CODE value.
• Oracle Order Management cross reference types — Source of the CROSS_REFERENCE_TYPE value.

The GTA invoice transfer program, the Invoice Workbench form, and the GTA invoice export program are the primary consumers of these parameters, reading the flags and mapping columns to control invoice generation and export behavior.