Results for “fv_rec_cr”

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

Overview

APPS.AR_XLA_CTLGD_LINES_V is a reporting and integration view in Oracle E-Business Suite Receivables that joins Receivables distribution data to Subledger Accounting (XLA) accounted amounts. Its name reflects its purpose: AR (Receivables), XLA (Subledger Accounting), "CTLGD" (customer transaction line GL distribution). The view consolidates the classic RA_CUST_TRX_LINE_GL_DIST_ALL columns — account class, percent, GL dates, posting metadata, salesrep, and descriptive attributes — with the accounting class code and the entered and accounted debit/credit balances derived from XLA accounting lines.

The view plays a central role in functions that require a single row per distribution line carrying both the operational distribution detail and its corresponding accounted amount. It is consumed by Receivables accounting and posting logic, by revenue recognition and adjustment programs, and by downstream custom reports and reconciliations. Because it exposes the concatenated accounting flexfield segments plus the derived distribute/accounted amounts, it is frequently used for journal-line reporting, tax and revenue adjustment analysis, and drill-down from distributions to their XLA accounting entries.

Underlying Base Objects

The documented base objects supporting this view are:

• RA_CUST_TRX_LINE_GL_DIST_ALL (synonym) — the primary source. Provides distribution identifiers, customer transaction line references, set of books, percent, GL date and posted date, salesrep, posting control, account class, and the ATTRIBUTE1–15 columns.
• XLA_AE_HEADERS (synonym) — the accounting event header, supplying the GL_SL_LINK_ID and GL_SL_LINK_TABLE used to trace the link back to the source distribution.
• XLA_AE_LINES (synonym) — the accounting lines providing accounting_class_code and the code_combination_id, together with the unrounded entered and accounted debit/credit values from the link table used in the DECODE expressions.
• XLA_DISTRIBUTION_LINKS (synonym) — aliased as lk in the view text, supplying unrounded_entered_dr/cr and unrounded_accounted_dr/cr, the amounts combined with the accounting class to produce the final debit/credit figures.

The view therefore sits at the intersection of the Receivables distribution model (RA_CUST_TRX_LINE_GL_DIST_ALL) and the Subledger Accounting model (XLA_AE_HEADERS, XLA_AE_LINES, XLA_DISTRIBUTION_LINKS), joined via the GL_SL_LINK_ID / GL_SL_LINK_TABLE linkage.

Key Columns

• CUST_TRX_LINE_GL_DIST_ID — primary identifier of the Receivables distribution line.
• CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID — references to the transaction line and transaction header.
• GL_SL_LINK_ID, GL_SL_LINK_TABLE — the XLA link keys that connect the distribution to its accounting entries.
• CODE_COMBINATION_ID, CONCATENATED_SEGMENTS — the accounting flexfield and its concatenated display form.
• Entered / Accounted amount columns — two DECODE expressions return the signed amount. For accounting_class_code values of RECEIVABLE, FV_REC_DR, and FV_REC_CR, the amount is entered_dr minus entered_cr (and accounted_dr minus accounted_cr); the default branch returns entered_cr minus entered_dr (and accounted_cr minus accounted_dr), i.e., the sign is inverted for credit-side classes.
• ACCOUNT_CLASS — decoded so that accounting_class_code RECEIVABLE, FV_REC_DR, and FV_REC_CR all map to 'REC'; otherwise the stored ctlgd.ACCOUNT_CLASS is returned.
• SET_OF_BOOKS_ID, GL_DATE, GL_POSTED_DATE, ORIGINAL_GL_DATE — ledger and accounting date context.
• PERCENT, SALESREP, COMMENTS, ATTRIBUTE_CATEGORY, ATTRIBUTE1–15 — descriptive and reconciliation attributes carried from the distribution line.
• POST_REQUEST_ID, POSTING_CONTROL_ID, RA_POST_LOOP_NUMBER, ACCOUNT_SET_FLAG, LATEST_REC_FLAG — posting and processing control columns.
• MRC_* columns — multiple reporting currency equivalents (MRC_ACCOUNT_CLASS, MRC_CUSTOMER_TRX_ID, MRC_AMOUNT, MRC_ACCTD_AMOUNT, MRC_GL_POSTED_DATE, MRC_POSTING_CONTROL_ID).
• USSGL_TRANSACTION_CODE / CONTEXT, COLLECTED_TAX_CCID, COLLECTED_TAX_CONCAT_SEG, REVENUE_ADJUSTMENT_ID, REV_ADJ_CLASS_TEMP — federal/USSGL and tax/revenue adjustment attributes.

Common Use Cases and Queries

The view supports distribution-level reporting where both the Receivables distribution and its Subledger Accounting amounts are required. Typical scenarios include reconciling distributions to accounting entries, reporting entered and accounted amounts by account class, analyzing revenue adjustments and collected tax, and producing multiple-reporting-currency extracts.

Query by transaction line and account class:

SELECT CUST_TRX_LINE_GL_DIST_ID,
       CUSTOMER_TRX_LINE_ID,
       ACCOUNT_CLASS,
       CONCATENATED_SEGMENTS,
       entered amount column,
       accounted amount column,
       GL_DATE,
       GL_POSTED_DATE
FROM   APPS.AR_XLA_CTLGD_LINES_V
WHERE  CUSTOMER_TRX_ID = :p_customer_trx_id
AND    ACCOUNT_CLASS  = 'REC';

Query by GL date range for reconciliation to the general ledger:

SELECT SET_OF_BOOKS_ID,
       GL_DATE,
       CODE_COMBINATION_ID,
       ACCOUNT_CLASS,
       accounted amount column
FROM   APPS.AR_XLA_CTLGD_LINES_V
WHERE  GL_DATE BETWEEN :p_from_date AND :p_to_date
ORDER  BY SET_OF_BOOKS_ID, GL_DATE;

Because the view returns one row per distribution line with the derived signed amount already resolved against the accounting class, it is well suited to journal-style extracts and to any process that must distinguish receivable-side entries from their reversing FV_REC_DR / FV_REC_CR counterparts.