Search Results get_item_no

Overview

GMF_MEMO_INTERFACE is an Oracle EBS Process Manufacturing (OPM/GMF) interface package owned by APPS. Its business purpose is to bridge Oracle Receivables credit memos and debit memos into the OPM financial integration flow, allowing memo transactions that are relevant to Process Manufacturing inventory and item activity to be detected, staged, and passed to downstream processing. The package maintains a staging table, GL_MEMO_STA, that records which customer transaction identifiers (credit memos and debit memos) have already been recognized by the interface and whether they remain eligible for further processing. In EBS 12.1.1 and 12.2.2 this package belongs to the legacy GMF (Process Manufacturing Financials) layer and is classified as OTHER in the ETRM API registry; it is not a public, fully supported open interface, but rather an internal driver invoked by OPM memo-related programs.

Key Procedures and Functions

The documented API surface consists of three procedures: GET_NEXT_TRX_LINE, INSERT_ERROR, and VALIDATE_FLEXFIELDS.

• GET_NEXT_TRX_LINE — The core driver of the interface. It initializes processing state, queries Receivables for qualifying credit memo and debit memo transactions (types CM and DM, with the transaction type attribute10 set to YES and complete_flag equal to Y), stages them into GL_MEMO_STA, and returns the next transaction line to the caller along with its transaction type and an error status. It also records the interface date used to bound the selection of newly created memos.
• INSERT_ERROR — Writes error information arising during memo interface processing so that failures can be diagnosed and reconciled. It supports the package's error-reporting contract used by the calling concurrent program.
• VALIDATE_FLEXFIELDS — Validates the key flexfield combinations associated with the memo or item data before the transaction is accepted for downstream accounting and inventory processing, preventing invalid accounting combinations from propagating.

Two private helper procedures, UPDATE_STATE and the internal initialization logic, maintain the high-water mark in GL_MEMO_STA so that already-processed transactions are not reprocessed on subsequent runs. The package also tracks process_errors and last_trx_id as package-level state.

Tables Accessed

• GL_MEMO_STA — The staging and state table. It stores customer_trx_id, updated_flag, and interface_date, and is both read and written to track processed memos and the last interface date.
• RA_CUSTOMER_TRX_ALL — Source of credit and debit memo transactions, including complete_flag and last_update_date.
• RA_CUST_TRX_TYPES_ALL — Supplies the transaction type (CM/DM) and the attribute10 filter that qualifies memos for OPM processing.
• IC_ITEM_MST and MTL_SYSTEM_ITEMS — Referenced for item validation and mapping between OPM item master data and Oracle inventory items.

Usage Notes

GMF_MEMO_INTERFACE is not referenced by any other documented package, indicating it is invoked directly — typically by a concurrent program or an OPM memo processing routine — rather than through a shared API chain. It is generally called when OPM financial users need to bring Receivables credit and debit memos into the Process Manufacturing accounting stream. Custom code should treat it as an internal package: parameter lists are subject to change between patch levels, and the documented release header (115.10) reflects an older code line that persists in 12.1.1/12.2.2 environments. The term "get_item_no" that led to this object most likely relates to item-number handling during flexfield validation rather than to a public function in this package.