Results for “r12_nlb”

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

Overview

APPS.AR_APP_DIST_UPG_V is an upgrade-support view in Oracle E-Business Suite Receivables, defined in the APPS schema. Its purpose is to present a unified, upgrade-oriented projection of receivable accounting distributions assembled from multiple distribution sources, so that the Receivables upgrade and migration programs can read pre-upgrade and post-upgrade distribution data through a single interface. The view is not intended for day-to-day transactional reporting; rather, it supports the data conversion logic that moves legacy distribution rows into the Release 12 subledger accounting model.

The view is structured as a UNION of two query branches. The first branch selects distribution rows from AR_DISTRIBUTIONS_ALL, restricted to receivable applications whose UPGRADE_METHOD is one of 'R12_NLB', 'R12', 'R12_11IMFAR', or 'R12_11ICASH'. This is the branch relevant to the search term r12_11imfar: the literal 'R12_11IMFAR' identifies applications converted through the 11i Multi-Fund Accounts Receivable upgrade path, and the view exposes those distributions for downstream processing. The second branch draws from AR_CASH_BASIS_DISTS_ALL, translating cash-basis activity buckets into standardized source types such as EDISC, UNEDISC, UNEDISC variants, and REC.

The view includes AR_NUM_RAN_PKG among its referenced objects, indicating that packaged PL/SQL functions (for example, sequence or numbering routines) participate in the view definition or its dependent logic. Because it is an upgrade view, its population and behavior are tied to the Receivables upgrade driver rather than to normal user activity.

Underlying Base Objects

The documented base objects underlying AR_APP_DIST_UPG_V are:

• AR_DISTRIBUTIONS_ALL (SYNONYM) — the primary source of accounting distribution lines, including code combination, entered and accounted debit/credit amounts, source identifiers, and tax attributes.
• AR_RECEIVABLE_APPLICATIONS_ALL (SYNONYM) — joined to AR_DISTRIBUTIONS_ALL to filter distributions by UPGRADE_METHOD and to match RECEIVABLE_APPLICATION_ID to SOURCE_ID where SOURCE_TABLE is 'RA'.
• AR_CASH_BASIS_DISTS_ALL (SYNONYM) — the source for the second UNION branch, supplying cash-basis distributions keyed by CASH_BASIS_DISTRIBUTION_ID and RECEIVABLE_APPLICATION_ID.
• RA_CUSTOMER_TRX_ALL (SYNONYM) — supports header/transaction context used during upgrade validation and accounting.
• RA_CUST_TRX_LINE_GL_DIST_ALL (SYNONYM) — referenced through line-level distribution identifiers such as REF_CUST_TRX_LINE_GL_DIST_ID.
• PSA_MF_RCT_DIST_ALL (SYNONYM) — a multi-fund receipts distribution table, present to support multi-fund and 11i MFAR-related conversion paths.
• AR_NUM_RAN_PKG (PACKAGE) — packaged logic referenced in the view dependency chain.

The two branches are reconciled by padding columns with NULLs so that both return the same column list: the AR_DISTRIBUTIONS_ALL branch supplies sign-split debit/credit amounts directly, while the cash-basis branch derives debit and credit values from the sign of AMOUNT and ACCTD_AMOUNT using DECODE(SIGN(...)).

Key Columns

• LINE_ID — identifier of the originating distribution line.
• SOURCE_ID, SOURCE_TABLE, SOURCE_TYPE — the distribution's source reference; source type values include EDISC, UNEDISC and REC, derived from ACTIVITY_BUCKET.
• CODE_COMBINATION_ID — the accounting flexfield combination charged by the distribution.
• AMOUNT_DR / AMOUNT_CR and ACCTD_AMOUNT_DR / ACCTD_AMOUNT_CR — entered and accounted debit and credit amounts, sign-split.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE — currency and conversion attributes.
• TAXABLE_ENTERED_DR/CR, TAXABLE_ACCOUNTED_DR/CR, TAX_CODE_ID, TAX_GROUP_CODE_ID — tax-related distribution details.
• ORG_ID — operating unit identifier.
• REF_CUSTOMER_TRX_LINE_ID, REF_CUST_TRX_LINE_GL_DIST_ID, REF_DIST_CCID — references back to transaction lines and original distribution code combinations.
• FROM_AMOUNT_DR / FROM_AMOUNT_CR and FROM_ACCTD amounts — the pre-conversion amounts retained for upgrade reconciliation.
• The constant literal 'AR_DISTRIBUTIONS' and NVL(ard.ref_mf_dist_flag,'N') — a source-table tag and multi-fund distribution indicator.

Common Use Cases and Queries

Typical use is diagnostic: confirming which distributions the upgrade will process for a given upgrade method, including the R12_11IMFAR path.

SELECT line_id, source_id, source_type, code_combination_id,
       amount_dr, amount_cr, org_id, currency_code
FROM   apps.ar_app_dist_upg_v
WHERE  org_id = :p_org_id
AND    source_type IN ('REC','EDISC','UNEDISC');

Reconciliation queries compare upgraded and pre-upgrade amounts:

SELECT ref_cust_trx_line_gl_dist_id,
       SUM(from_amount_dr - amount_dr) dr_delta,
       SUM(from_amount_cr - amount_cr) cr_delta
FROM   apps.ar_app_dist_upg_v
GROUP  BY ref_cust_trx_line_gl_dist_id
HAVING SUM(from_amount_dr - amount_dr) <> 0
    OR SUM(from_amount_cr - amount_cr) <> 0;

Other scenarios include verifying multi-fund distributions via the ref_mf_dist_flag column and auditing tax distributions by tax_code_id. Because the view is upgrade-specific and references upgrade-only columns, it should not be used for ongoing subledger reporting once conversion is complete.