Results for “gmf_rcv_accounting_txns”

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

Overview

GMF_RCV_ACCOUNTING_TXNS is a table in the GMF schema (Process Manufacturing Financials) that stores receiving accounting information for process organizations. It captures the accounting events generated when goods are received in a process manufacturing environment, where receiving accounting differs materially from discrete manufacturing due to process inventory valuation, landed costs, and intercompany transfers. The table is populated by the receiving accounting program and serves as the staging and audit layer between Oracle Purchasing/Receiving transactions and the general ledger.

Because receiving accounting must be reconcilable and re-runnable, each row represents a discrete accounting transaction line tied to a receiving event, a ledger, and an organization. Based on the FK structure mined from the metadata, the ETRM Data Vault classification for this object is standalone. This heuristic suggests modeling GMF_RCV_ACCOUNTING_TXNS as an independent entity rather than as a hub, link, or satellite in a Data Vault build — a sensible suggestion given that the table holds a large volume of transactional detail and references only one parent table (PO_RELEASES_ALL) through a nullable foreign key.

Key Information Stored

The table contains 54 columns. The most operationally significant are:

• ACCOUNTING_TXN_ID — the surrogate primary key, enforced by unique index GMF_RCV_ACCOUNTING_TXNS_U1, and the business-key candidate for the table.
• RCV_TRANSACTION_ID — the link back to the originating receiving transaction.
• EVENT_TYPE, EVENT_SOURCE, EVENT_SOURCE_ID — classify the accounting event and its originating source document.
• LEDGER_ID, ORG_ID, ORGANIZATION_ID — define the accounting ledger and inventory organization context.
• TRANSFER_ORG_ID, TRANSFER_ORGANIZATION_ID, CROSS_OU_FLAG — support intercompany and cross-operating-unit transfer accounting.
• DEBIT_ACCOUNT_ID, CREDIT_ACCOUNT_ID — the GL account combination IDs that drive the journal entry.
• TRANSACTION_QUANTITY, PRIMARY_QUANTITY, SOURCE_DOC_QUANTITY — quantity in transaction, primary, and source document UOMs.
• INVENTORY_ITEM_ID — the item being accounted.
• PO_HEADER_ID, PO_RELEASE_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID — the purchasing document chain; PO_RELEASE_ID is the only documented FK, referencing PO_RELEASES_ALL.
• TRANSACTION_AMOUNT, UNIT_PRICE, PRIOR_UNIT_PRICE, UNIT_LANDED_COST — valuation amounts.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE — currency conversion details.
• ACCOUNTED_FLAG, INVOICED_FLAG, PROCUREMENT_ORG_FLAG — processing status indicators.
• Standard WHO/audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID) are present.

Common Use Cases and Queries

Typical uses include reconciling receiving accruals to the GL, investigating unaccounted receiving transactions, and reporting landed cost absorption. A representative query to find unaccounted transactions is:

• SELECT accounting_txn_id, rcv_transaction_id, event_type, transaction_amount FROM gmf.gmf_rcv_accounting_txns WHERE accounted_flag = 'N';
• Join to GL_JE_LINES or the accounting event tables on DEBIT_ACCOUNT_ID/CREDIT_ACCOUNT_ID to reconcile posted entries.
• Group by ORG_ID and TRANSACTION_DATE for period-end receiving accrual reporting.
• Filter on CROSS_OU_FLAG or TRANSFER_ORG_ID to isolate intercompany receiving activity.

Related Objects

• PO_RELEASES_ALL — the documented FK target via PO_RELEASE_ID.
• PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL — purchasing document chain, joined on PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID.
• RCV_TRANSACTIONS — receiving transactions joined on RCV_TRANSACTION_ID.
• GL_LEDGERS / GL_CODE_COMBINATIONS — joined on LEDGER_ID and DEBIT_ACCOUNT_ID/CREDIT_ACCOUNT_ID.
• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID for item attributes.