Results for “ar_app_dist_upg_v”

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

Overview

AR_APP_DIST_UPG_V is a Receivables accounting extraction view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to serve as the AR XLA (Subledger Accounting) extract for upgraded Receivables transactions. The view consolidates accounting distribution rows associated with receivable applications that were converted from pre-R12 (11i) accounting models, filtering specifically on applications flagged with upgrade-related methods such as R12_NLB, R12, R12_11IMFAR, and R12_11ICASH. In this role, it acts as a bridge between the legacy AR distribution model and the R12 Subledger Accounting engine, presenting distributions in a column layout aligned with XLA's expected accounting attributes.

The view is significant to the upgrade path from 11i to R12 accounting. During upgrade, distributions posted under the older model must be re-expressed in XLA terminology so that Create Accounting can process them correctly. AR_APP_DIST_UPG_V supplies that re-expressed data set, combining rows from standard AR distribution tables and cash-basis distribution tables using a UNION, and augmenting rows from the multi-fund receipt distribution table (PSA_MF_RCT_DIST_ALL) where those records exist.

Underlying Base Objects

The ETRM metadata documents the following referenced objects: AR_CASH_BASIS_DISTS_ALL, AR_DISTRIBUTIONS_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, PSA_MF_RCT_DIST_ALL, RA_CUSTOMER_TRX_ALL, and RA_CUST_TRX_LINE_GL_DIST_ALL, all consumed as synonyms, together with the AR_NUM_RAN_PKG package.

The primary driver in the view text is AR_DISTRIBUTIONS_ALL (aliased ARD), joined to AR_RECEIVABLE_APPLICATIONS_ALL (aliased APP) on APP.RECEIVABLE_APPLICATION_ID = ARD.SOURCE_ID, restricted to ARD.SOURCE_TABLE = 'RA' and to applications whose UPGRADE_METHOD falls within the listed R12 upgrade values. A UNION branch draws cash-basis distributions from AR_CASH_BASIS_DISTS_ALL, keyed by CASH_BASIS_DISTRIBUTION_ID and RECEIVABLE_APPLICATION_ID. The multi-fund receipt distribution table PSA_MF_RCT_DIST_ALL is referenced in the documented base-object list and supports the REF_MF_DIST_FLAG semantics that the view carries forward. RA_CUSTOMER_TRX_ALL, RA_CUST_TRX_LINE_GL_DIST_ALL, and AR_NUM_RAN_PKG supply the contextual joins and numbering logic used by the surrounding extract process.

Key Columns

• LINE_ID / SOURCE_ID / SOURCE_TABLE — Identify the accounting line and its owning entity; SOURCE_TABLE is hardcoded to 'AR_DISTRIBUTIONS' or 'RA' depending on the UNION branch.
• CODE_COMBINATION_ID — The accounting flexfield combination for the distribution.
• AMOUNT_DR / AMOUNT_CR / ACCTD_AMOUNT_DR / ACCTD_AMOUNT_CR — Entered and accounted debit/credit amounts, presented as positive values through DECODE(SIGN(...)) logic.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE — Currency and conversion attributes for the distribution.
• TAXABLE_ENTERED_DR/CR, TAXABLE_ACCOUNTED_DR/CR, TAX_LINK_ID, TAX_CODE_ID, TAX_GROUP_CODE_ID — Tax-related distribution attributes carried for XLA processing.
• THIRD_PARTY_ID / THIRD_PARTY_SUB_ID — Customer identification for the distribution.
• REF_CUSTOMER_TRX_LINE_ID, REF_CUST_TRX_LINE_GL_DIST_ID, REF_LINE_ID, REF_ACCOUNT_CLASS, REF_DIST_CCID — Reference keys linking the row back to its transaction line and original distribution.
• ACTIVITY_BUCKET — The earning/discount/tax activity classification; cash-basis rows are decoded into EDISC, UNEDISC, and REC values.
• REF_MF_DIST_FLAG — Multi-fund distribution indicator, returned via NVL(REF_MF_DIST_FLAG,'N') and tied to PSA_MF_RCT_DIST_ALL.
• ORG_ID — Operating unit identifier, supporting multi-org secured reporting.

Common Use Cases and Queries

This view is typically consumed during R12 upgrade validation and XLA accounting extraction rather than by end-user reporting. A common query validates upgraded distribution volumes by operating unit and source table:

• SELECT ORG_ID, SOURCE_TABLE, COUNT(*) FROM AR_APP_DIST_UPG_V GROUP BY ORG_ID, SOURCE_TABLE; — balances the two UNION branches.
• SELECT SOURCE_ID, SUM(AMOUNT_DR - AMOUNT_CR) FROM AR_APP_DIST_UPG_V WHERE SOURCE_TABLE='AR_DISTRIBUTIONS' GROUP BY SOURCE_ID; — reconciles net entered amounts against AR_DISTRIBUTIONS_ALL.
• SELECT * FROM AR_APP_DIST_UPG_V WHERE REF_MF_DIST_FLAG = 'Y'; — isolates multi-fund receipts sourced through PSA_MF_RCT_DIST_ALL.
• SELECT ACTIVITY_BUCKET, SUM(ACCTD_AMOUNT_DR), SUM(ACCTD_AMOUNT_CR) FROM AR_APP_DIST_UPG_V GROUP BY ACTIVITY_BUCKET; — analyses accounted activity buckets, including cash-basis EDISC/UNEDISC/REC classifications.

Because the view restricts output to specific UPGRADE_METHOD values, results represent only the population requiring XLA conversion handling, which is precisely the subset relevant to post-upgrade accounting verification.