Results for “period_set”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FII_AR_OLTP_INV_V is an internal Oracle E-Business Suite view owned by the APPS schema and delivered as part of the Financial Intelligence (FII) product. Its documented purpose is to support the Operations Indicators Portlet, a dashboard component that surfaces receivables operational metrics to business users. In Oracle EBS 12.1.1 and 12.2.2 the view is registered as VALID in the ETRM data dictionary and is not intended for direct customer modification or as a public integration interface. It functions as a pre-joined, pre-aggregated data source that translates the normalized Receivables transaction model into a flat projection suitable for summarization by the portlet layer.

Underlying Base Objects

The view is defined over several Receivables and General Ledger tables, combined through a UNION ALL of two branches. The first branch reads invoice distribution lines from RA_CUST_TRX_LINE_GL_DIST_ALL joined to RA_CUSTOMER_TRX_ALL, GL_SETS_OF_BOOKS, and RA_CUST_TRX_TYPES_ALL. It restricts to rows where ACCOUNT_CLASS is 'REC' and ACCOUNT_SET_FLAG is 'N', filtering out non-revenue distribution accounts. The second branch reads AR_ADJUSTMENTS_ALL joined to AR_DISTRIBUTIONS_ALL, RA_CUSTOMER_TRX_ALL, and GL_SETS_OF_BOOKS, restricted to adjust­ments with STATUS 'A', POSTABLE 'Y', and distributions where SOURCE_TABLE is 'ADJ' and SOURCE_TYPE is 'REC'. Both branches join EDW_LOCAL_INSTANCE for the INSTANCE_CODE and call EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT to express amounts in the ledger currency. The join to RA_CUST_TRX_TYPES_ALL is outer, and the NVL conditions on POST_TO_GL and ACCOUNTING_AFFECT_FLAG default to 'Y'. ETRM documents no referenced base objects explicitly, so the view text above is the authoritative source for lineage.

Key Columns

• CUSTOMER_TRX_ID — Identifier of the receivables transaction, common to both UNION branches.
• INSTANCE_CODE — Local instance code from EDW_LOCAL_INSTANCE, used for multi-instance consolidation.
• ORG_ID — Operating unit for the transaction or adjustment.
• SOB_ID / SET_OF_BOOKS_ID — Ledger identifier used to derive period and currency information.
• PERIOD_SET / PERIOD_TYPE — Accounting calendar name and period type from GL_SETS_OF_BOOKS.
• CALENDAR_DAY — GL_DATE, the accounting date of the distribution or adjustment.
• CURRENCY_CODE — Ledger currency code.
• ACCTD_AMOUNT — Accounted (ledger currency) amount. In the adjustment branch this is the net of ACCTD_AMOUNT_DR minus ACCTD_AMOUNT_CR, which is why a search for "acctd_amount_cr" surfaces this view: the credit column ACCTD_AMOUNT_CR from AR_DISTRIBUTIONS_ALL is consumed inside the view but is not projected outward.

Common Use Cases and Queries

The view is typically queried by the Operations Indicators Portlet rather than by end users. A representative query is:

SELECT sob_id, calendar_day, SUM(acctd_amount) FROM apps.fii_ar_oltp_inv_v WHERE org_id = :p_org_id AND calendar_day BETWEEN :p_start AND :p_end GROUP BY sob_id, calendar_day;

• Reporting accounted receivables balances by ledger and accounting period.
• Feeding operational indicators such as invoiced and adjusted amounts per operating unit.
• Consolidating ledger-currency amounts across instances via INSTANCE_CODE.
• Analysis of the ACCTD_AMOUNT_CR source column must be performed against AR_DISTRIBUTIONS_ALL directly, since the view nets debit and credit components.