Search Results ar_gta_conc_prog

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.

PACKAGE: APPS.AR_GTA_CONC_PROG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_GTA_CONC_PROG, status:VALID,
PACKAGE BODY: APPS.AR_GTA_CONC_PROG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_GTA_CONC_PROG, status:VALID,
SYNONYM: APPS.AR_GTA_TRX_HEADERS_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_GTA_TRX_HEADERS_ALL, status:VALID,
PACKAGE: APPS.AR_GTA_ARTRX_PROC 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_GTA_ARTRX_PROC, status:VALID,
PACKAGE: APPS.AR_GTA_REPORTS_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_GTA_REPORTS_PKG, status:VALID,
PACKAGE: APPS.AR_GTA_CONSOLIDATE_PROC 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_GTA_CONSOLIDATE_PROC, status:VALID,
SYNONYM: APPS.AR_GTA_TRX_LINES_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_GTA_TRX_LINES_ALL, status:VALID,
PACKAGE: APPS.AR_GTA_TXT_OPERATOR_PROC 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_GTA_TXT_OPERATOR_PROC, status:VALID,
PACKAGE: APPS.AR_GTA_TRX_UTIL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_GTA_TRX_UTIL, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
SYNONYM: PUBLIC.XMLTYPE 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:XMLTYPE, status:VALID,
SYNONYM: APPS.FND_PROFILE_OPTION_VALUES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_PROFILE_OPTION_VALUES, status:VALID,
SYNONYM: APPS.RA_CUSTOMER_TRX_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:RA_CUSTOMER_TRX_ALL, status:VALID,
PACKAGE: APPS.AR_GTA_CONC_PROG 12.2.2
APPS.AR_GTA_CONC_PROG dependencies on AR_GTA_CONC_PROG 12.2.2
TYPE: SYS.XMLTYPE 12.2.2
owner:SYS, object_type:TYPE, object_name:XMLTYPE, status:VALID,
PACKAGE: APPS.FND_CONCURRENT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_CONCURRENT, status:VALID,
PACKAGE BODY: APPS.AR_GTA_CONC_PROG 12.2.2
PACKAGE: APPS.MO_GLOBAL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:MO_GLOBAL, status:VALID,
SYNONYM: APPS.HR_ALL_ORGANIZATION_UNITS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID,
PACKAGE: APPS.FND_DATE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_DATE, status:VALID,
PACKAGE: APPS.FND_FILE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_FILE, status:VALID,
PACKAGE: APPS.FND_LOG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_LOG, status:VALID,
PACKAGE: APPS.FND_PROFILE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE, status:VALID,
SYNONYM: PUBLIC.DUAL 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.FND_MESSAGE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_MESSAGE, status:VALID,