Search Results jl_zz_receiv_interface




Overview
Explore in AI Chat

Overview

JL_ZZ_RECEIV_INTERFACE is a customer-specific (suffix "ZZ") PL/SQL package owned by the APPS schema that supports Oracle E-Business Suite's localization and statutory reporting requirements, most notably for Latin American (JL) country installations such as Argentina, Brazil, and Mexico. The package is part of the JL (Latin America) application family and is designed to bridge Oracle Order Management and Receivables or receiving-related interfaces by populating and copying Global Descriptive Flexfield (GDFF) and Global Data Element (GDF) values associated with order and transaction lines. In the 12.1.1 and 12.2.2 releases, the package is declared with AUTHID CURRENT_USER, meaning it executes under the privileges of the calling user, which is significant for multi-org security and localization compliance. The procedures in this package default, copy, and validate descriptive flexfield attributes as records flow from the order entry model (oe_order_pub.line_rec_type) to invoice and receiving interface structures. The "$Header" comment referencing jlzzoris.pls indicates the package is tied to Oracle Receiving (ORIS) logic, while the internal use of OE_Invoice_PUB.OE_GDF_Rec_Type shows it manipulates the generic GDF record type used during order-to-invoice data transfer.

Key Procedures and Functions

  • copy_gdff — Reads the incoming interface line record (OE_Invoice_PUB.OE_GDF_Rec_Type) and writes the resulting Global Descriptive Flexfield values into the output interface line record, returning a status code and error buffer. It is the core routine that transfers GDFF attribute values between interface stages.
  • copy_gdf — Performs the equivalent copy operation for Global Data Element (GDF) values, using the same in-out GDF record type and returning status and error information.
  • default_gdff — Derives and applies default Global Descriptive Flexfield values onto an Order Management line record (oe_order_pub.line_rec_type), taking the source line record as input and returning the populated output line record plus return code and error buffer. The procedure accepts an organization identifier (p_org_id) that defaults to MO_GLOBAL.GET_CURRENT_ORG_ID, reflecting a bug fix (2367111) that enforces multi-org context.
  • default_gdf — Provides the parallel defaulting logic for Global Data Elements, updating the incoming line record in place and returning status and error details, also defaulting p_org_id to the current organization ID.

Tables Accessed

The ETRM metadata lists the following objects referenced through APPS synonyms:

Usage Notes

JL_ZZ_RECEIV_INTERFACE is a custom integration package rather than a seeded Oracle public API. It is typically invoked by customer-specific concurrent programs, forms personalizations, or Workflow business events during order entry and receiving, and is referenced by at least one other package in the environment. Because it uses OE_Invoice_PUB and oe_order_pub record types, callers must supply fully populated Order Management line records and manage return codes and error buffers. The package should be called within a properly initialized multi-org context (MO_GLOBAL), and any changes to GDFF/GDF defaulting logic should be regression-tested against the affected countries' fiscal reporting outputs.