Search Results validate_gdff

Overview

JE_ZZ_INVOICE_CREATE is a customization package body owned by APPS and classified under the ETRM repository as an "OTHER" API object. Its source header identifies it as jezzricb.pls (revision 120.1, dated 2004/12/22), indicating that it was originally delivered as a localized extension rather than as part of the base Oracle Receivables product. The package exists to support country-specific validation of invoice transactions before they are handed to the JG (localization) processing layer. The documented source comments make the intent explicit: while the package was "really meant for validation," it can be "bent" to insert the HU (Hungary) data required by the downstream JG package and then report that validation has succeeded.

The package therefore sits between the standard Receivables invoice-creation flow and the localization logic, providing a controlled hook through which region-specific general ledger descriptive flexfield (context and attribute) values can be supplied and validated for a given concurrent request.

Key Procedures and Functions

The ETRM metadata documents a single program unit in this package body:

• VALIDATE_GDFF — The function that validates the general ledger descriptive flexfield (GDFF) data associated with a concurrent request. The source excerpt shows it accepts a concurrent request identifier (p_request_id) and returns a numeric status code, where 1 indicates that validation succeeded and 0 indicates that validation failed or an exception was handled through the WHEN OTHERS handler. The function reads the JGZZ_COUNTRY_CODE profile option and, when the country code corresponds to Hungary, enters the flexfield context and attribute1 values. Diagnostic output is written through ARP_STANDARD.DEBUG when the MSC_ATP_DEBUG profile option is set to 'Y' or 'C'. As noted in the source comments, the function can also be used to insert the HU data expected by the JG package and return a success indicator, effectively bypassing a failure result for that path.

Tables Accessed

According to the ETRM metadata, the package references one table through an APPS synonym:

• AR_TRX_HEADER_GT — A global temporary table used within the Receivables transaction header processing flow. The package reads from and/or writes to this structure to obtain or supply the transaction header context needed for GDFF validation and for the insertion of HU-specific flexfield values that are subsequently consumed by the JG localization package.

No other tables are documented for this object. The package relies on profile option lookups (via FND_PROFILE) rather than direct table access for its country-code and debug decisions.

Usage Notes

JE_ZZ_INVOICE_CREATE is a localization hook, and the ETRM metadata records that it is referenced by one other package. It is not exposed as a standalone concurrent program or form; instead it is invoked programmatically from the Receivables/JG invoice-creation path, typically when a concurrent request is processing invoices that require country-specific GDFF handling. The p_request_id parameter ties validation to the specific concurrent request being executed, allowing the function to inspect the request context and, where required, populate the HU flexfield values before returning a success code.

Because the package is a custom (ZZ-named) object rather than a standard Oracle API, release-specific behavior between 12.1.1 and 12.2.2 should be confirmed against the actual deployed source. Debug output is controlled by the MSC_ATP_DEBUG profile option, and the JGZZ_COUNTRY_CODE profile option must be correctly set for the validation branch to execute. The metadata excerpt provided is limited, and no additional parameters beyond p_request_id are documented, so integrators should inspect the deployed package specification before relying on any other interface.