Search Results gl_id_tax

Overview

FII_AR_ARTT_TYPE_LCV is a collection view within the Oracle E-Business Suite Financial Intelligence (FII) product family. It is documented in ETRM as the collection view for the AR Transaction Type level of the AR Transaction Type dimension. In other words, it exposes the master list of Receivables transaction types — the classification records that drive invoice, credit memo, debit memo, chargeback, and deposit behavior — in a flattened, reporting-friendly shape suitable for extraction, staging, and dimensional loading.

The view belongs to the FII module, which is flagged as obsolete in the ETRM documentation, and the implementation metadata states it is "Not implemented in this database." This indicates that FII_AR_ARTT_TYPE_LCV is a legacy collection view retained for historical reference and does not exist as a deployed object in current 12.1.1 or 12.2.2 environments. Any use of the object should therefore be treated as documentation-driven only, and functional equivalents in the AR schema (such as RA_CUST_TRX_TYPES_ALL) should be substituted for production work.

The trailing instances of the search term gl_id_tax reflect the accounting flexfield columns carried by the underlying AR transaction type records, which map each transaction type to its default general ledger accounts.

Underlying Base Objects

The ETRM metadata documents no referenced base objects for this view, and the view text shows it is defined over a single source object: FIIBV_AR_ARTT_TYPE_LCV. The "BV" infix in the source name follows the standard FII collection-view naming convention, where a base collection view (the record set) is wrapped by a level-specific view that projects the columns required by the AR Transaction Type dimension.

Because FIIBV_AR_ARTT_TYPE_LCV is not further resolved in the documentation, the view's ultimate dependency is the AR transaction type repository. In released EBS releases this repository is RA_CUST_TRX_TYPES_ALL, joined to related setup tables for accounting rules, terms, and GL account assignments. The listed columns — including GL_ID_CLEARING, GL_ID_FREIGHT, GL_ID_REC, GL_ID_REV, GL_ID_TAX, GL_ID_UNBILLED, and GL_ID_UNEARNED — are consistent with the account-default columns that RA transaction types carry, confirming the lineage.

Key Columns

• TRX_TYPE_PK — The primary key surrogate for the transaction type record, used as the dimension member identifier.
• TRX_CODE_FK / TRX_TYPE_DP / NAME / TRANSACTION_TYPE — The business key, descriptive name, and the AR transaction class (for example, Invoice, Credit Memo, Debit Memo, Chargeback).
• CREATION_SIGN — Determines whether transactions of this type create positive or negative receivables activity.
• TAX_CALC_FLAG — Indicates whether tax is calculated for the transaction type.
• ALLOW_FRT_FLAG / ALLOW_OVAPP_FLAG — Control flags for freight lines and over-application.
• GL_ID_TAX — The default tax account flexfield assignment carried by the transaction type; part of the accounting default set.
• SET_OF_BOOKS_ID / ORG_ID — Conform the record to a specific ledger and operating unit, enabling multi-org and multi-ledger reporting.
• START_DATE / END_DATE / STATUS — Effective-dating and active/inactive controls for the transaction type.
• USER_ATTRIBUTE1–5 and INSTANCE — Descriptive flexfield and source-instance context for incremental collection.
• LAST_UPDATE_DATE — The high-water mark used for incremental extraction.

Common Use Cases and Queries

Where the object exists (typically FII data warehouse or reporting schemas), it is queried to populate the AR Transaction Type dimension and to build extracts that classify receivable activity. A representative query follows.

SELECT TRX_TYPE_PK, NAME, TRANSACTION_TYPE, CREATION_SIGN,
       GL_ID_TAX, GL_ID_REC, GL_ID_REV, STATUS, SET_OF_BOOKS_ID
FROM   FII_AR_ARTT_TYPE_LCV
WHERE  STATUS = 'A'
AND    SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE + 1);

Because the view is not implemented in 12.1.1 or 12.2.2, the practical pattern is to reproduce the result set directly from the AR schema:

SELECT CUST_TRX_TYPE_ID, NAME, TYPE, CREATION_SIGN,
       TAX_CALC_FLAG, GL_ID_TAX, GL_ID_REC, GL_ID_REV,
       ORG_ID, START_DATE, END_DATE
FROM   RA_CUST_TRX_TYPES_ALL
WHERE  ORG_ID = :p_org_id;

This substitution preserves the dimension semantics — including the GL account defaults referenced by gl_id_tax — while relying on supported application tables.