Search Results gl_tax_options_u1

Overview

GL.GL_TAX_OPTIONS is a General Ledger configuration table that stores the tax option information defined through the Tax Options form in Oracle E-Business Suite. It serves as the central control record governing how tax is calculated, rounded, and defaulted for a given operating context. In a multi-org environment, the table contains one record for each organization for which tax has been set up; in a non-multi-org environment, it contains one record for each ledger for which tax has been set up.

From a Data Vault modeling perspective, the mined heuristic classification for this object is a link, reflecting its role as an associative structure connecting ledger and organization context to a body of tax attributes. The FND Design Data reference is SQLGL.GL_TAX_OPTIONS, and the object resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. The table is registered as VALID in the ETRM 12.2.2 physical schema and carries 34 documented columns.

Key Information Stored

The primary key of GL_TAX_OPTIONS is the composite GL_TAX_OPTIONS_PK, defined on (LEDGER_ID, ORG_ID). Both columns are mandatory NUMBER(15) columns; LEDGER_ID is the ledger defining column and ORG_ID is the organization defining column. The unique index GL_TAX_OPTIONS_U1 mirrors the primary key on (LEDGER_ID, ORG_ID) and resides in the APPS_TS_TX_IDX tablespace; it is the business-key candidate that guarantees one tax option record per ledger and organization.

The most significant non-key columns include:

• TAX_CURRENCY_CODE — the currency used for tax calculations, validated against FND_CURRENCIES.
• TAX_PRECISION — precision applied when generating tax amounts.
• TAX_MAU — the minimum accountable unit for tax calculations.
• CALCULATION_LEVEL_CODE — the level at which the tax amount is rounded, Line or Journal.
• ALLOW_ROUNDING_OVERRIDE_FLAG — determines whether the rounding rule may be changed in the Manual Journal Entry form.
• INPUT_ROUNDING_RULE_CODE and OUTPUT_ROUNDING_RULE_CODE — default rounding rules for input and output tax respectively.
• INPUT_TAX_CODE and OUTPUT_TAX_CODE — the default input and output tax codes.
• INPUT_AMT_INCL_TAX_FLAG and OUTPUT_AMT_INCL_TAX_FLAG — default flags indicating whether amounts include tax.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard descriptive flexfield and DFF attribute columns.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Who columns.

Common Use Cases and Queries

Typical usage centers on retrieving the tax setup for a specific ledger and organization before tax lines are generated, and on auditing rounding or default code configuration. A representative query joins the table to the ledger and organization context:

SELECT t.ledger_id, t.org_id, t.tax_currency_code,
       t.calculation_level_code, t.input_tax_code, t.output_tax_code
FROM   gl_tax_options t
WHERE  t.ledger_id = :p_ledger_id
AND    t.org_id = :p_org_id;

Because GL_TAX_OPTIONS_U1 is unique on (LEDGER_ID, ORG_ID), lookups by those two columns are index-driven and return at most one row. Reporting use cases include listing all organizations where tax has been configured, verifying that input and output tax codes are populated consistently across ledgers, and reconciling rounding rule assignments. The TAX_CURRENCY_CODE and CALCULATION_LEVEL_CODE columns are frequently filtered in multi-org reporting to compare tax treatment across organizations.

Related Objects

Documented foreign keys establish the following relationships:

• GL.GL_SETS_OF_BOOKS_11I — referenced via GL_TAX_OPTIONS.LEDGER_ID, providing ledger definition context.
• FND_CURRENCIES — referenced via GL_TAX_OPTIONS.TAX_CURRENCY_CODE, supplying currency validation.
• GL_TAX_OPTION_ACCOUNTS — the child table in a one-to-many relationship with GL_TAX_OPTIONS; each tax option row maps to multiple tax account assignments.

These dependencies make GL_TAX_OPTIONS a foundational record for General Ledger tax processing, joined to ledger definitions, currency definitions, and downstream tax account assignments.