Search Results amt_g




Overview
Explore in AI Chat

Overview

FII_AR_TRX_DIST_MGR1_F is a database view belonging to the FII (Financial Intelligence) product family within Oracle E-Business Suite. FII was Oracle's earlier financial data warehousing and analytics offering, and in both release 12.1.1 and 12.2.2 it carries an "Obsolete" product designation. The view is not part of the operational receivables or general ledger schema; rather, it is an internal extract structure used to feed the Enterprise Data Warehouse (EDW). Its purpose is to expose Accounts Receivable transaction distribution data enriched with the manager associated with the owning organization, so that analytic and reporting layers can attribute receivable balances and accounting distributions to a managerial hierarchy.

The object is documented as "Not implemented in this database" in the source metadata. This is a significant caveat: the view is defined in the documentation and view-text repository for reference purposes, but it is not guaranteed to exist in every environment, and where it does exist it is typically present only in warehouse or staging schemas rather than in the core ERP schema. Its role is therefore one of reporting and integration rather than transactional processing.

Underlying Base Objects

The view is defined over two objects, joined on the organization key:

  • FII_AR_TRX_DIST_F — the primary distribution fact object (aliased F), holding AR transaction accounting distribution amounts and their associated dimensions.
  • EDW_ORGANIZATION_M — an EDW organization dimension table (aliased O), supplying the managerial attribute for the organization.

The join condition is F.ORGANIZATION_FK_KEY = O.ORGA_ORGANIZATION_PK_KEY. This is a standard star-schema style relationship: a fact object keyed by foreign keys to a set of conformed dimension objects. The view text is a straightforward projection of selected fact columns plus a single managerial foreign key (O.ORGA_PERSON_MANAGER_FK_KEY), which is surfaced in the output as MANAGER_ID. Although the ETRM metadata does not enumerate referenced base objects as physical tables, the naming conventions and the join make the underlying fact and dimension structures explicit.

Key Columns

  • ACCOUNT_TYPE / ACCOUNT_CLASS — classification of the accounting distribution, distinguishing the nature and category of the receivable entry.
  • AMT_B / AMT_G / AMT_T — the receivables amount measures (entered, accounted, and converted/functional). The user's search term "amt_t" corresponds to the AMT_T column, the transaction or converted amount measure.
  • TRANSACTION_CLASS — the class of AR transaction (for example, invoice, credit memo, or adjustment).
  • FUNCTIONAL_CURRENCY_FK_KEY, TRANSACTION_CURRENCY_FK_KEY — foreign keys to the functional and transaction currency dimensions.
  • COMPANY_CC_ORG_FK_KEY — organization/company cost center dimension key.
  • GL_DATE_FK_KEY, SET_OF_BOOKS_FK_KEY — accounting date and ledger dimension keys.
  • INVOICE_PK_KEY — key of the originating AR invoice transaction.
  • MANAGER_ID — the manager foreign key resolved from the organization dimension, adding the reporting hierarchy attribute.

Common Use Cases and Queries

The view supports warehouse extraction and analytic reporting, particularly analysis of receivable distributions by manager. A representative query retrieving the converted amount measure would be:

  • SELECT manager_id, account_class, transaction_class, SUM(amt_t) FROM fii_ar_trx_dist_mgr1_f GROUP BY manager_id, account_class, transaction_class;
  • SELECT invoice_pk_key, amt_b, amt_g, amt_t FROM fii_ar_trx_dist_mgr1_f WHERE gl_date_fk_key = :date_key;

Because the object is obsolete and may not be implemented in a given database, any query should first confirm the view's existence in the relevant schema. Where present, it is best treated as a read-only interface to EDW staging data rather than a supported application object.