Search Results gmf_memo_interface




Overview
Explore in AI Chat

Overview

GMF_MEMO_INTERFACE is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the API classification OTHER. It falls within the Oracle Process Manufacturing (OPM/ GMF) receivables integration layer, providing the procedural bridge between process manufacturing transaction data and Oracle Receivables memo transactions. Its header, dated to the 11.5.x source line and carried forward into 12.1.1 and 12.2.2, declares the package with AUTHID CURRENT_USER, meaning that runtime privilege resolution follows the invoking user rather than the package owner.

The package addresses the requirement to transform OPM shipping and inventory movements into Receivables memo lines, while validating the descriptive flexfield attributes that carry OPM-specific context on those memo lines. It supplies line-sequencing logic, error capture, and flexfield validation as discrete procedures, allowing calling programs to drive the interface in a controlled, stepwise manner rather than through a single monolithic routine.

Key Procedures and Functions

  • GET_NEXT_TRX_LINE — Retrieves the next receivable transaction line to be processed, returning the transaction identifier and transaction type together with an initialization flag and an error status. It acts as the driver cursor for iterative processing of memo records.
  • INSERT_ERROR — Records an error condition against a specific customer transaction identifier, returning an error status. This procedure supports the package's exception handling model by persisting failure information for later review and reprocessing.
  • VALIDATE_FLEXFIELDS — Validates the descriptive flexfield attribute values associated with a memo transaction line, taking the customer transaction identifier, a set of RCTL attribute values (attributes 1, 5, 7, 8, 9, 10 and 15), and an inventory item identifier. This is the procedure most commonly targeted by users searching for flexfield validation logic in the OPM receivables interface.

Tables Accessed

The package references the following objects through APPS synonyms:

  • RA_CUSTOMER_TRX_ALL and RA_CUST_TRX_TYPES_ALL — the Receivables transaction headers and transaction types that define the memo transactions being created and validated.
  • GL_MEMO_STA — the OPM memo staging table that holds memo records pending transfer into Receivables.
  • MTL_SYSTEM_ITEMS and IC_ITEM_MST — inventory item definition sources used to resolve and validate the inventory item identifier passed into VALIDATE_FLEXFIELDS.

These references confirm the package's role as a staging-to-Receivables converter that depends on both OPM master data and standard Receivables transaction structures.

Usage Notes

GMF_MEMO_INTERFACE is not referenced by any other documented package, which indicates that it is invoked directly rather than through a package-to-package dependency chain. Typical invocation paths include OPM receivables interface concurrent programs, custom wrapper scripts, or form-driven logic that processes staged memo records. Because the package is declared AUTHID CURRENT_USER, callers must ensure that the executing user holds the necessary privileges on the underlying APPS synonyms and base tables.

When adapting or debugging this package, note that the source header reflects a 2002 vintage, so behavior should be verified against the specific 12.1.1 or 12.2.2 patch level in use. The VALIDATE_FLEXFIELDS procedure is the entry point of interest for flexfield-related troubleshooting, and its attribute parameters should be mapped against the OPM descriptive flexfield configuration in the target environment before changes are made.