Results for “ar_cm_net_rev_dist_form”

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

Overview

AR_CM_NET_REV_DIST_FORM is a reporting view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2, and is classified under the Oracle Receivables (AR) product family. Its documented purpose is to "determine the uncredited amount," making it a specialized vehicle for analyzing credit memo and net revenue distribution activity against previously invoiced transaction lines. Status for the object is VALID, confirming it is compiled and available for query in a standard EBS installation.

In practice, the view serves as a summarized aggregation layer over the net distribution detail captured for credit transactions. Rather than exposing raw distribution rows one-to-one, it groups and rolls up amounts by previous transaction line, GL date, previous transaction, and accounting period set, and it derives a net unit price that reflects the credit rules in effect. This makes it suitable for reporting on how much of an original invoice line has been credited, how much remains uncredited, and what effective net unit price results when quantity-based credit rules are applied.

Underlying Base Objects

The view is defined exclusively over one documented base object: AR_CM_NET_DISTS_V, itself a view in the Receivables schema. AR_CM_NET_DISTS_V supplies the net credit distribution facts—including the credit method for rules, GL date, quantity, and distributed amount—that AR_CM_NET_REV_DIST_FORM consumes.

• AR_CM_NET_DISTS_V — the sole referenced base object; the source of credit distribution rows, quantities, credit method indicators, and GL dates.
• Aggregation grain — the outer view groups on PREVIOUS_CUSTOMER_TRX_LINE_ID, TRUNC(GL_DATE), PREVIOUS_CUSTOMER_TRX_ID, and PERIOD_SET_NAME, producing one summarized row per combination.

Because the source is a view rather than a table, downstream performance depends on the underlying distribution and transaction line tables that AR_CM_NET_DISTS_V resolves through. No direct table access is documented for this object.

Key Columns

• PREVIOUS_CUSTOMER_TRX_LINE_ID — the line identifier on the original (credited) transaction; a primary grouping key.
• PREVIOUS_CUSTOMER_TRX_ID — the header identifier of the original transaction; used alongside the line to scope the credit relationship.
• GL_DATE — the truncated general ledger date, used for accounting-period alignment and grouping.
• AMOUNT — the summed distributed amount across the grouped credit rows.
• NET_UNIT_PRICE — a derived value computed as the sum of amounts (excluding UNIT and LIFO credit methods) divided by summed quantities for non-excluded methods, with a divisor fallback of 1 to avoid divide-by-zero.
• PERIOD_SET_NAME — the accounting period set associated with the distributions; included in grouping.

Common Use Cases and Queries

Typical scenarios include reconciling credit memos against original invoice lines, quantifying uncredited balances, and validating effective net unit pricing after quantity-based credit rules. A representative query follows:

• SELECT previous_customer_trx_id, previous_customer_trx_line_id, gl_date, amount, net_unit_price, period_set_name FROM apps.ar_cm_net_rev_dist_form WHERE previous_customer_trx_id = :trx_id ORDER BY gl_date;
• SELECT previous_customer_trx_id, SUM(amount) credited_amount FROM apps.ar_cm_net_rev_dist_form GROUP BY previous_customer_trx_id;

Analysts commonly join the view back to Receivables transaction tables using PREVIOUS_CUSTOMER_TRX_ID and PREVIOUS_CUSTOMER_TRX_LINE_ID to present credited versus original line values, and constrain by GL_DATE or PERIOD_SET_NAME for period-specific reporting.