Results for “adjustment_id”

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

Overview

ARBV_ADJ_DISTS_ALT_CRNCY is a read-only Oracle EBS view owned by the APPS schema and validated in the Receivables (AR) product. In ETRM documentation it carries the description "Retrofitted," indicating it belongs to the compatibility layer that preserves Oracle Forms-based application behavior within the Release 12 architecture. The view presents adjustment distribution information from the Multi-Currency Adjustments entity, exposing signed debit and credit amounts together with a posting status indicator and the primary keys that identify an adjustment and its set of books.

The "_ALT_CRNCY" suffix denotes that this view participates in the alternate currency reporting model. Rather than presenting a single entered or accounted amount column, it splits the accounted balance into functional debit and functional credit columns derived from a single stored amount. This shape matches the requirements of Oracle Reports and other reporting tools that expect separate debit and credit values for posting and reconciliation. The view is therefore a presentation-layer construct intended for Receivables reporting and integration, not a base transaction table.

Underlying Base Objects

The view is defined over a single documented base object, AR_MC_ADJUSTMENTS, referenced through a synonym. The query applies an inline decode against the ACCTD_AMOUNT column to produce the debit and credit outputs:

• DECODE(SIGN(ACCTD_AMOUNT), -1, ABS(ACCTD_AMOUNT), NULL) — the functional debit amount, populated only when the accounted amount is negative.
• DECODE(SIGN(ACCTD_AMOUNT), 1, ACCTD_AMOUNT, NULL) — the functional credit amount, populated only when the accounted amount is positive.

Because the source is the Multi-Currency Adjustments table, rows correspond to adjustments recorded at the distribution or multi-currency level, and the view is filtered implicitly to adjustments rather than invoices, receipts, or other AR transaction types. The view is declared WITH READ ONLY in its view text, so DML against it is not permitted.

Key Columns

• FUNCTIONAL_DEBIT_AMOUNT — the absolute value of the accounted adjustment amount when that amount is negative; otherwise NULL. Serves as the debit-side figure for functional (set-of-books) currency reporting.
• FUNCTIONAL_CREDIT_AMOUNT — the accounted adjustment amount when it is positive; otherwise NULL. Serves as the credit-side figure.
• "_LA:POSTED_FLAG" — a derived posting indicator. It decodes POSTING_CONTROL_ID, mapping the value -3 to 'N' and all other values to 'Y', and is annotated against AR_LOOKUPS with the YES/NO meaning set. This exposes whether the adjustment is considered posted.
• ADJUSTMENT_ID — the identifier of the adjustment record, used to join back to AR_MC_ADJUSTMENTS and related Receivables entities.
• SET_OF_BOOKS_ID — the ledger identifier associated with the distribution, enabling multi-organization and multi-ledger filtering.

The view text is wrapped in UNIQUE ATTRIBUTES and REGULAR ATTRIBUTES comment markers, which reflect the Oracle Forms block and item metadata used by the original EBS forms. The columns therefore map directly onto form block items rather than being an arbitrary projection.

Common Use Cases and Queries

Typical use is reporting on adjustment distributions in functional currency, with debit and credit presented separately and posting status available for reconciliation against subledger accounting entries. A representative query joining descriptive Receivables lookups is:

• SELECT adjustment_id, set_of_books_id, functional_debit_amount, functional_credit_amount, "_LA:POSTED_FLAG" FROM apps.arbv_adj_dists_alt_crncy WHERE set_of_books_id = :ledger_id;

Because the column name contains a colon and is quoted, it must be referenced in double quotes exactly as defined. When integrating with other AR objects, join ADJUSTMENT_ID to AR_MC_ADJUSTMENTS and, where ledger context is required, to the appropriate ledger table using SET_OF_BOOKS_ID. Note that the view returns no DML-capable rows and should be treated strictly as a reporting and reconciliation source.