Search Results gl_id_unearned




Overview
Explore in AI Chat

Overview

AR_TA_TRX_TYP_INT is a single-organization (SINGLE_ORG) view in the Oracle Receivables (AR) module of Oracle E-Business Suite, used to present transaction type definitions that drive tax and accounting derivation during AutoInvoice and tax integration processing. The name follows the convention for the "TA" (Tax/Transactions Accounting) family of objects, and the view exposes a transaction type context including the general ledger account identifier columns — GL_ID_REV, GL_ID_FREIGHT, GL_ID_REC, GL_ID_CLEARING, GL_ID_TAX, GL_ID_UNBILLED, and GL_ID_UNEARNED — that map Receivables transaction types to their corresponding accounting flexfield segments.

The object is documented as a SINGLE_ORG view, meaning it applies the Oracle multi-org security predicate restricted to the current operating unit. In the ETRM 12.2.2 metadata, the view is recorded as Not implemented in this database, indicating that the view definition exists in the data dictionary but is not instantiated in the target environment; its referenced base objects are listed as none documented. The GL_ID_TAX column is the tax account identifier specifically, and it is the object most commonly retrieved when a user searches for "gl_id_tax" in the context of AR transaction type configuration.

Underlying Base Objects

The view text is defined over AR_TA_TRX_TYP_INT_ALL, the multi-organization (_ALL) table that stores transaction type definitions for every operating unit. AR_TA_TRX_TYP_INT applies a WHERE clause using USERENV('CLIENT_INFO') to filter rows to the current organization:

  • ORG_ID is compared to the value derived from SUBSTR(USERENV('CLIENT_INFO'), 1, 10), with NVL/TO_NUMBER handling to accommodate sessions where CLIENT_INFO is not populated.
  • The predicate NVL(ORG_ID, ...) = NVL(..., -99) ensures that rows without an ORG_ID are returned consistently only when the session context matches the -99 sentinel.
  • Because the view is defined only over AR_TA_TRX_TYP_INT_ALL, it inherits all columns of that table, including the GL_ID_* accounting identifiers and the REQUEST_ID concurrency column.

Functionally, AR_TA_TRX_TYP_INT_ALL is the multi-org staging/definition object that parallels AR_CUST_TRX_TYPES_ALL for customer transaction types; the GL_ID_REV, GL_ID_FREIGHT, GL_ID_REC, GL_ID_CLEARING, GL_ID_TAX, GL_ID_UNBILLED, and GL_ID_UNEARNED columns correspond to the autoaccounting accounts assigned per transaction type.

Key Columns

  • CUST_TRX_TYPE_ID — primary identifier of the transaction type row.
  • NAME, DESCRIPTION, TYPE, TRX_CATEGORY, STATUS — descriptive and classification attributes of the transaction type.
  • GL_ID_TAX — the tax accounting flexfield identifier, central to "gl_id_tax" lookups; determines the tax account posted for the transaction type.
  • GL_ID_REV, GL_ID_FREIGHT, GL_ID_REC, GL_ID_CLEARING, GL_ID_UNBILLED, GL_ID_UNEARNED — revenue, freight, receivables, clearing, unbilled, and unearned account identifiers.
  • TAX_CALCULATION_FLAG, ALLOW_FREIGHT_FLAG, POST_TO_GL — behavioral controls for tax calculation, freight, and GL posting.
  • SET_OF_BOOKS_ID, ORG_ID, REQUEST_ID — ledger, operating unit, and concurrent request context.
  • START_DATE, END_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1–15 — effective dating and descriptive flexfield attributes.

Common Use Cases and Queries

Typical uses include verifying the tax account assigned to a transaction type, auditing autoaccounting setup across operating units, and feeding integration extracts that require the GL_ID_* mapping. A representative query is:

SELECT CUST_TRX_TYPE_ID, NAME, GL_ID_TAX, GL_ID_REV, ORG_ID
FROM AR_TA_TRX_TYP_INT
WHERE NAME = :trx_type_name;

Because the view derives its org context from USERENV('CLIENT_INFO'), queries executed outside a properly initialized Receivables session may return no rows or the -99 fallback set. Where the view is not implemented, the equivalent information should be sourced from AR_TA_TRX_TYP_INT_ALL with an explicit ORG_ID predicate. Joining GL_ID_TAX to GL_CODE_COMBINATIONS resolves the account number for reporting and reconciliation.