Search Results lc_adjustments

Overview

APPS.GMF_XLA_LC_ADJS_V is a reporting and integration view in Oracle E-Business Suite that exposes Landed Cost adjustment transactions alongside their associated Subledger Accounting (XLA) event context. It is a foundational object for users and processes that must reconcile physical receiving activity with the financial valuation adjustments generated by Oracle's Landed Cost Management (LCM) module. In release 12.1.1 and 12.2.2, the view sits at the intersection of the Process Manufacturing (OPM / GMF) transactional schema and the XLA extract layer, deliberately denormalizing the fields required for landed cost reporting into a single queryable structure.

The view is populated from adjustment records that have already been extracted into the XLA event model with the event class code LC_ADJUSTMENTS. Its WHERE clause restricts output to four event types: LC_ADJUST_RECEIVE, LC_ADJUST_DELIVER, LC_ADJUST_EXP_DELIVER, and LC_ADJUST_VALUATION. This makes it the primary reference for the specific lc_adjust_receive search term, which corresponds to the receive-side landed cost adjustment event type.

Underlying Base Objects

The view is defined over five documented base objects. The driving table is GMF_LC_ADJ_TRANSACTIONS (as a synonym), which holds the adjustment transaction identifiers, the related receiving transaction identifiers, the component type and component name, the charge line type code, the adjustment number, and the landed cost shipment and shipment line numbers. GMF_XLA_EXTRACT_HEADERS supplies the XLA event context — legal entity, ledger, transaction identifier, valuation cost type, event class code, transaction date, transaction quantity, organization, inventory item, and event/source keys. The join is anchored on eh.source_document_id = glat.adj_transaction_id and eh.source_line_id = glat.rcv_transaction_id.

Organization context is resolved through MTL_PARAMETERS via organization_id, while MTL_SYSTEM_ITEMS_B_KFV (the concatenated-segment key flexfield view) provides the item concatenated segments, item description, and the primary and secondary unit of measure codes. XLE_ENTITY_PROFILES supplies the legal entity name, completing the descriptive attributes required for reporting. The view therefore performs a five-way join across transactional, subledger, inventory master, and legal entity data.

Key Columns

The identifying columns are ADJ_TRANSACTION_ID and RCV_TRANSACTION_ID, which pair the landed cost adjustment with its originating receiving transaction. The XLA correlation columns LEGAL_ENTITY_ID, LEDGER_ID, TRANSACTION_ID, VALUATION_COST_TYPE_ID, VALUATION_COST_TYPE, EVENT_CLASS_CODE, and ORGANIZATION_CODE frame the accounting and organizational context.

Descriptive columns include LEGAL_ENTITY_NAME, ITEM_NAME (concatenated segments), ITEM_DESCRIPTION, PRIMARY_QUANTITY (transaction quantity concatenated with the primary UOM), PRIMARY_UOM_CODE, and SECONDARY_UOM_CODE. Adjustment-specific columns include COMPONENT_TYPE, COMPONENT_NAME, CHARGE_LINE_TYPE_CODE, ADJUSTMENT_NUM, LC_SHIP_NUM, and LC_SHIP_LINE_NUM. TRANSACTION_DATE provides the temporal dimension.

Common Use Cases and Queries

Typical uses include auditing receive-side landed cost adjustments, reconciling landed cost charges to receiving transactions, and feeding downstream reporting for cost variance analysis. A representative query for the lc_adjust_receive scenario is:

• SELECT ADJ_TRANSACTION_ID, RCV_TRANSACTION_ID, ORGANIZATION_CODE, ITEM_NAME, COMPONENT_NAME, CHARGE_LINE_TYPE_CODE, ADJUSTMENT_NUM, TRANSACTION_DATE FROM APPS.GMF_XLA_LC_ADJS_V WHERE EVENT_CLASS_CODE = 'LC_ADJUSTMENTS' AND COMPONENT_NAME IS NOT NULL ORDER BY TRANSACTION_DATE DESC;
• Filter by LC_SHIP_NUM and LC_SHIP_LINE_NUM to trace adjustments to a specific landed cost shipment.
• Join LEGAL_ENTITY_ID and LEDGER_ID to XLA accounting entries for subledger reconciliation.

Because the view is read-only and joins multiple high-volume tables, queries should be constrained by organization, legal entity, or date range to maintain acceptable performance.