Search Results run_consolidation_mapping

Overview

APPS.AR_GTA_CONC_PROG is a PL/SQL package in the Oracle E-Business Suite Receivables (AR) module that supports Global Tax and Accounting (GTA) processing for cross-border transactions. In EBS releases 12.1.1 and 12.2.2, this package serves as the programmatic engine behind the concurrent programs that move invoice, customer, and transaction data between Oracle Receivables and the GTA staging infrastructure. It is registered in the APPS schema with a status of VALID, carries an API classification of OTHER in the ETRM documentation, and is not referenced by any other package, indicating that it functions as a top-level driver invoked directly by concurrent program definitions rather than as a shared utility library.

The package coordinates the transfer, import, consolidation, and purge activities required for the Global Transaction Accounting and reporting flow, including the movement of transactions out of the Receivables workbench and into GTA tracking tables.

Key Procedures and Functions

The ETRM metadata documents 13 procedures and functions within this package. Their documented purposes are as follows:

• TRANSFER_AR_TRANSACTIONS — Transfers Receivables transactions into the GTA staging tables.
• PURGE_INVOICE — Removes previously processed invoice data from the GTA tables.
• RUN_AR_GT_MAPPING — Executes the mapping logic that aligns Receivables data with Global Tax reporting structures.
• IMPORT_GT_INVOICES — Imports Global Tax invoices into the appropriate staging or reporting tables.
• TRANSFER_INVOICES_TO_GT — Moves invoice records from Receivables into the Global Tax tables.
• TRANSFER_TRXS_FROM_WORKBENCH — Extracts transactions from the Receivables workbench for GTA processing.
• DISCREPANCY_REPORT — Produces a report identifying mismatches or exceptions between source and GTA data.
• ITEM_EXPORT — Exports item-level data required for GTA reporting.
• TRANSFER_CUSTOMERS_TO_GT — Transfers customer records into the Global Tax infrastructure.
• CONSOLIDATE_INVOICES — Combines invoice data according to consolidation rules.
• RUN_CONSOLIDATION_MAPPING — Executes the mapping used during the consolidation process.
• POPULATE_INVOICE_TYPE — Populates invoice type classification values.
• POPULATE_INVOICE_TYPE_HEADER — Populates invoice type information at the header level.

No parameter lists are documented in the ETRM metadata; the procedures are therefore described by purpose only.

Tables Accessed

The package references the following tables through APPS synonyms:

• AR_GTA_TRX_HEADERS_ALL and AR_GTA_TRX_LINES_ALL — the GTA transaction header and line tables that receive transferred and imported invoice data.
• RA_CUSTOMER_TRX_ALL — the Receivables transaction source from which invoices are extracted.
• HR_ALL_ORGANIZATION_UNITS — provides organizational context, likely for operating unit or legal entity determination.
• FND_PROFILE_OPTION_VALUES — supplies profile option settings used to control processing behavior.
• DUAL and XMLTYPE — support SQL expression evaluation and XML-based data handling.

Usage Notes

AR_GTA_CONC_PROG is normally invoked indirectly through concurrent program definitions rather than called from Oracle Forms or custom code. Administrators submit the associated GTA concurrent programs from the Receivables responsibility, and the request runs under the APPS schema. Because the package is not referenced by any other package, direct API calls from custom extensions are uncommon; the supported integration point is the concurrent program. When troubleshooting GTA transfers, the ETRM dependency listing confirms the package depends only on SYS.STANDARD, so functional failures are more likely to originate in data conditions or profile option settings than in package-level dependencies.