Search Results ax_ar_ractla_ractlgda_v

Overview

The view AX_AR_RACTLA_RACTLGDA_V belongs to the Global Accounting Engine (AX) product family within Oracle E-Business Suite, specifically supporting Oracle Receivables tax rule creation and the associated accounting derivations. Its documented purpose in the ETRM repository is to support Oracle Receivables rules creation within the AX Global Accounting Engine, which is the subsystem that generates balanced, GAAP-compliant accounting entries for subledger transactions such as AR invoices, credit memos, and their associated tax lines.

The view presents a consolidated projection of customer transaction tax distributions, joining the customer transaction line header information against two aliases of the receivables line GL distribution table. This construct is designed to expose the taxable amount, the tax account combination, and the base accounted amount in a single, reportable row. The absence of the object from the physical database in the documentation metadata ("Not implemented in this database") indicates it is a supplemental or environment-specific view typically deployed alongside the GAX (Global Accounting Engine) schema during AX configuration rather than in a vanilla AR-only installation. For reporting and integration purposes, the view serves as a bridge between the subledger operational tables and the accounting rules engine, and is frequently the object queried when tracing how a tax line's taxable amount and accounted amount were derived during rule execution.

Underlying Base Objects

The view text defines the query exclusively over three base objects, each referenced in the FROM clause as follows:

• RA_CUSTOMER_TRX_LINES_ALL (aliased RACTLA) — the AR customer transaction line table, supplying CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, LINK_TO_CUST_TRX_LINE_ID, and TAXABLE_AMOUNT.
• RA_CUST_TRX_LINE_GL_DIST_ALL (aliased RACTLGDA1) — the primary distribution join, filtered to ACCOUNT_CLASS = 'TAX' and POSTING_CONTROL_ID < 0, supplying the code combination, distribution identifier, GL date, accounted amount, and entered amount for the tax line.
• RA_CUST_TRX_LINE_GL_DIST_ALL (aliased RACTLGDA2) — an outer-joined instance used to resolve the linked ("base") transaction line's accounted amount via the LINK_TO_CUST_TRX_LINE_ID relationship.

The join predicates link the tax distribution to its transaction line by CUSTOMER_TRX_LINE_ID, and the outer join to the second distribution alias by CUSTOMER_TRX_LINE_ID(+) = RACTLA.LINK_TO_CUST_TRX_LINE_ID. The ETRM metadata documents no additional referenced base objects beyond these three, meaning the view is self-contained with respect to the AR schema.

Key Columns

• TAXABLE_AMOUNT — the search term of interest. Sign is inverted (-1 * RACTLA.TAXABLE_AMOUNT), which normalizes the sign convention for credit memos and reversals so that the reported taxable amount aligns with the GAX accounting sign semantics.
• CUSTOMER_TRX_ID / CUSTOMER_TRX_LINE_ID — identifiers of the parent transaction and the specific line.
• LINK_TO_CUST_TRX_LINE_ID — the referenced base line, used to relate a tax line to the line it taxes.
• VAT_TAX_ID — the tax identifier associated with the line, supporting VAT and other tax regime handling.
• CODE_COMBINATION_ID — the account combination to which the tax distribution posts.
• CUST_TRX_LINE_GL_DIST_ID / GL_DATE — the distribution identifier and accounting date.
• ACCTD_AMOUNT / AMOUNT — the accounted and entered amounts for the tax distribution.
• BASE_ACCTD_AMOUNT — the negated accounted amount of the linked base line, providing the comparative base figure for taxable-amount analytics.

Common Use Cases and Queries

The view is typically queried when reconciling tax accounting in AR, analyzing taxable versus accounted amounts, or diagnosing AX rule output. A representative query retrieving taxable amounts for a given transaction is:

• SELECT customer_trx_id, customer_trx_line_id, vat_tax_id, taxable_amount, acctd_amount, base_acctd_amount FROM AX_AR_RACTLA_RACTLGDA_V WHERE customer_trx_id = :p_trx_id;
• Aggregating taxable amounts by tax ID: SELECT vat_tax_id, SUM(taxable_amount) FROM AX_AR_RACTLA_RACTLGDA_V GROUP BY vat_tax_id;
• Reconciling tax distributions to their base lines using ACCTD_AMOUNT versus BASE_ACCTD_AMOUNT.

Because the view is environment-dependent and not universally implemented, availability should be verified before reliance in production reports.