Search Results trx_type_dp




Overview
Explore in AI Chat

Overview

The view APPS.FII_AR_ARTT_TYPE_LCV is an Oracle E-Business Suite 12.1.1 / 12.2.2 subscriber-facing view belonging to the FII (Financial Intelligence Interface / ETRM) product family. It exposes Accounts Receivable transaction type information derived from the underlying business view FIIBV_AR_ARTT_TYPE_LCV, which serves as the AR transactional data source within the Oracle Financials "Transactional Business Intelligence" (TBI/ETRM) integration layer. The view is consumed by ETL processes that load the AR transaction type dimension into the ETRM/BI reporting repository.

Its principal role is to present a denormalized, integration-ready set of Accounts Receivable transaction type attributes — codes, descriptions, GL account assignments, sign conventions, and effective-dating columns — that describe how Receivables transactions behave for accounting and reporting purposes. Because the primary key here is TRX_TYPE_PK, the view is the canonical dimension extract for the AR transaction type entity.

Underlying Base Objects

The documented metadata records no referenced base objects for this view; the ETRM definition exposes only the SELECT over FIIBV_AR_ARTT_TYPE_LCV. In practice, the BI view layer traces back to the AR transaction type tables RA_CUST_TRX_TYPES_ALL and its associated GL distribution/rule table (RA_RULES / RA_CUST_TRX_TYPE_GL) within the Receivables module. The FIIBV_ prefix indicates a Business View managed by the ETRM/BI Foundation layer, and the LCV suffix is the "Load Column View" convention used by ETRM loaders that flatten source attributes into a load-ready column set. The trailing literal NULL columns (five, ending before LAST_UPDATE_DATE) are positional placeholders reserved for the loader schema.

Key Columns

Common Use Cases and Queries

Typical consumption is by ETRM extract programs that join AR transactions to their type definition via TRX_TYPE_PK. A simple dimension pull is:

SELECT TRX_TYPE_PK, TRX_CODE_FK, NAME, TRANSACTION_TYPE, GL_ID_REC, GL_ID_REV
FROM   APPS.FII_AR_ARTT_TYPE_LCV
WHERE  ORG_ID = :org_id
AND    TRUNC(SYSDATE) BETWEEN START_DATE AND NVL(END_DATE, SYSDATE+1);

For an incremental load driven by LAST_UPDATE_DATE:

SELECT TRX_TYPE_PK, TRX_CODE_FK, NAME, LAST_UPDATE_DATE
FROM   APPS.FII_AR_ARTT_TYPE_LCV
WHERE  LAST_UPDATE_DATE >= :last_run_date;

The view is also used to map transaction types to accounting rules (RULE_SET_ID) and to resolve the GL clearing, receivables, revenue, tax, unearned, and unbilled accounts required for reconciliation and subledger reporting. Because no base objects are documented in ETRM, join keys such as TRX_CODE_FK, ORG_ID, and SET_OF_BOOKS_ID should be used to relate this dimension to AR transaction fact sources.