Search Results origin_extract_table

Overview

AR_ADJ_DIST_UPG_V is an APPS-owned, VALID database view in the Oracle E-Business Suite Receivables (AR) module. It is defined as an "AR XLA Extract" view, meaning its primary purpose is to stage and expose adjustment distribution data for extraction into Oracle Subledger Accounting (XLA) during an upgrade or data migration cycle. The view consolidates accounting distribution lines originating from legacy adjustment sources — identified in the definition by the UPGRADE_METHOD value of R12, 11I, or 11IMFAR — together with multi-fund (MF) adjustment distributions, so that they may be loaded into the new Subledger Accounting engine.

In the context of Oracle EBS 12.1.1 and 12.2.2, this view is encountered during the transition from the older 11i accounting model to the R12 multi-org and subledger accounting model. The presence of the synonym names and the UPGRADE_METHOD filter confirm that the view is a transitional artifact tied to upgrade programs rather than to standard day-to-day reporting.

Underlying Base Objects

According to the documented 12.2.2 view metadata, AR_ADJ_DIST_UPG_V is defined over the following base objects:

• AR_DISTRIBUTIONS_ALL (SYNONYM) — the central accounting distribution table for Receivables, aliased ARD in the view.
• AR_ADJUSTMENTS_ALL (SYNONYM) — adjustment headers, aliased ADJ, joined on ADJ.ADJUSTMENT_ID = ARD.SOURCE_ID.
• AR_NUM_RAN_PKG (PACKAGE) — supplies the NUM_RANDOM generating function used to synthesize surrogate keys in the UNION branch.
• PSA_MF_ADJ_DIST_ALL (SYNONYM) — multi-fund adjustment distributions, aliased PSD.
• RA_CUSTOMER_TRX_ALL (SYNONYM) — transaction headers, aliased TRX, providing currency information.
• RA_CUST_TRX_LINE_GL_DIST_ALL (SYNONYM) — transaction line GL distributions, aliased CTLGD.

Structurally, the view is a UNION of a branch selecting from AR_DISTRIBUTIONS_ALL joined to AR_ADJUSTMENTS_ALL, and a second branch joining PSA_MF_ADJ_DIST_ALL back to the transaction line distribution tables. This UNION architecture explains why the view references six base objects while exposing a single, uniformly shaped rowset to the XLA extract process.

Key Columns

The view projects a broad set of accounting and reference columns. The most significant include:

• LINE_ID, SOURCE_ID, SOURCE_TABLE, SOURCE_TYPE — the identification triplet tying each distribution row back to its originating adjustment.
• CODE_COMBINATION_ID — the accounting flexfield combination for the distribution.
• AMOUNT_DR / AMOUNT_CR and ACCTD_AMOUNT_DR / ACCTD_AMOUNT_CR — entered and accounted debit/credit amounts.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE — currency and conversion attributes for the extract.
• TAXABLE_ENTERED_DR/CR, TAXABLE_ACCOUNTED_DR/CR, TAX_CODE_ID, TAX_GROUP_CODE_ID — tax-related distribution attributes.
• 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 to customer transaction lines and their GL distributions. The column REF_CUST_TRX_LINE_GL_DIST_ID is the field most often searched for, as it is the join key back to RA_CUST_TRX_LINE_GL_DIST_ALL.
• ACTIVITY_BUCKET — a derived classification (for example 'LINE', 'TAX', 'FREIGHT') computed from the account class.
• ORG_ID — the operating unit, critical for multi-org security filtering.

Common Use Cases and Queries

The view is most commonly used to audit or troubleshoot upgrade-time XLA extraction of adjustment distributions. A typical query retrieves adjustment distributions for a given operating unit and links them to the underlying transaction line GL distribution:

• Reconciling accounting entries generated during a 11i-to-R12 upgrade.
• Verifying that REF_CUST_TRX_LINE_GL_DIST_ID values resolve correctly to RA_CUST_TRX_LINE_GL_DIST_ALL records.
• Investigating multi-fund (PSA_MF_ADJ_DIST_ALL) distributions that feed the same extract stream.

A representative query is:

SELECT line_id, source_id, source_table, code_combination_id, amount_dr, amount_cr, ref_cust_trx_line_gl_dist_id FROM apps.ar_adj_dist_upg_v WHERE org_id = :p_org_id AND source_table = 'ADJ';

Because the view is upgrade-specific and populated only for adjustments whose UPGRADE_METHOD is R12, 11I, or 11IMFAR, it should not be treated as a general-purpose reporting source. For ongoing Receivables subledger accounting, the standard XLA and distribution tables should be used instead.