Search Results discrepancy_report




Overview
Explore in AI Chat

Overview

The APPS.JMF_GTA_CONC_PROG package body is a procedural container in Oracle E-Business Suite that consolidates the PL/SQL logic executed by Oracle Global Trade Management (GTA) concurrent programs. The header comment states plainly that the package is "a collection of procedures which [are] called by concurrent programs," identifying it as the back-end implementation layer rather than a self-contained business API. Its responsibilities span the movement of Accounts Receivable transactions and invoices into and out of GTA, the mapping and importation of global trade invoice data, customer and item master export, and periodic purge and discrepancy reporting activity. The package carries a substantial change history concentrated in 2005, with entries by Jim Zheng, Qiang Li, Jogen Hu, and Donghai Wang, and its final revision in the repository header is dated 2008/11/17. It is relevant to both EBS 12.1.1 and 12.2.2, where it remains an APPLICATION-owned component in the APPS schema.

Key Procedures and Functions

The package header block enumerates the documented procedure list. Each is invoked as the executable of a corresponding GTA concurrent program:

  • Transfer_AR_Transactions — moves Accounts Receivable transactions between the EBS source and the GTA repository.
  • Purge_Invoice — the procedure returned by a search for "purge_invoice"; it removes invoice data, and per the 16-Nov-2005 history entry by Qiang Li its completion status was changed to issue a warning rather than a normal success message.
  • Run_AR_GT_Mapping — executes the mapping logic that aligns AR data with global trade structures; its status was likewise adjusted to warning in the same revision.
  • Import_GT_Invoices — added 20-May-2005 by Jogen Hu to bring global trade invoices into the application.
  • Transfer_Invoices_to_GT — exports invoices toward the global trade system; revised on 28-Sep-2005 and again on 18-Oct-2005 to reorder its parameters.
  • Export_Invoices_from_Workbench — extracts invoice records held in the workbench for external processing.
  • Discrepancy_Report — added 13-Jun-2005 by Donghai Wang; reports mismatches between expected and actual trade data and sets status to 'Warning' when discrepancies exist.
  • Item_Export — exports item master data for use by global trade processing.
  • Transfer_Customers_To_GT — transfers customer records into the global trade system.

The history also records a related routine, Transfer_Trxs_from_workbench, and notes that clearing of a temporary table was relocated from JMF_GTA_TXT_OPERATOR_PROC into this package for the invoice import path.

Tables Accessed

The supplied ETRM metadata lists no tables referenced through APPS synonyms and no dependent packages, so table-level lineage is not documented for this object. Functionally, the procedures operate across AR transaction and invoice tables, GTA workbench and staging structures, and the temporary tables associated with invoice import. The relocation of temporary table clearing into this package indicates that it writes to and trims scratch tables during import processing.

Usage Notes

This package is not intended for direct invocation from forms or custom code. Each procedure serves as the program unit behind a registered GTA concurrent program and is submitted from the Global Trade Management responsibility or scheduled as a periodic job. Customers implementing invoice purging typically schedule Purge_Invoice on a recurring cycle to manage data volume. Because all procedures reside in the APPS schema and the package is documented as OTHER classification with no exposing API, customizations should call the concurrent program rather than the procedure directly, relying on the standard submission and log framework.