Search Results ar_gta_trx_lines

Overview

The APPS.AR_GTA_REPORTS_PKG package body supports the Global Tax Awareness (GTA) reconciliation and reporting functionality within Oracle Receivables in Oracle E-Business Suite 12.1.1 and 12.2.2. Its central purpose is to compare transaction data captured in Receivables against corresponding tax and financial records held in the GTA transaction tables, and to produce discrepancy, mapping, and consolidation reports that allow tax and financial users to identify, investigate, and resolve differences. The package reconciles entries held in AR_GTA_TRX_HEADERS and AR_GTA_TRX_LINES (and their _ALL counterparts) against core Receivables transaction tables such as RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL. Although the user search term ar_gta_trx_lines points directly to a table, the ETRM metadata confirms that the relevant object is this package body, which depends on and manipulates that table. The package is a reporting and diagnostic utility rather than a transaction-processing API, and it is classified as OTHER in the API taxonomy.

Key Procedures and Functions

The metadata documents thirteen procedures and functions, which fall into three functional groups.

• Data retrieval routines: GET_GT_COUNT, GET_AR_TRX, GET_GT_TRXS, GET_UNMATCHED_LINES, GET_CONSOLIDATION_TRX, and GET_CONSOLIDATED_TRXS gather transaction counts, Receivables transactions, GTA transactions, unmatched lines, and consolidated transaction sets from the underlying tables.
• Comparison routines: COMPARE_HEADER, COMPARE_LINES, and COMPARE_CONSOLIDATED_INV evaluate header-level and line-level data to detect mismatches between GTA records and Receivables records, including consolidated invoice comparisons.
• Report generation routines: GENERATE_MAPPING_REP, GENERATE_DISCREPANCY_REP, GENERATE_DISCREPANCY_XML, and GENERATE_CONSOL_MAPPING_REP produce the output artifacts—mapping reports, discrepancy reports, consolidated mapping reports, and an XML representation of discrepancies.

Parameter lists are not documented and are therefore not reproduced here.

Tables Accessed

The package reads and writes the GTA staging and result tables, including AR_GTA_TRX_HEADERS, AR_GTA_TRX_HEADERS_ALL, AR_GTA_TRX_LINES, AR_GTA_TRX_LINES_ALL, and configuration in AR_GTA_SYSTEM_PARAMETERS_ALL. It populates or consumes temporary result tables such as AR_GTA_DIFFERENCE_TEMP, AR_GTA_AR_DIFFERENCE_TEMP, AR_GTA_MISSING_ARTRX_TEMP, and AR_GTA_UNMATCHED_TEMP. On the Receivables side it references RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL, RA_CUST_TRX_LINE_GL_DIST_ALL, RA_BATCHES_ALL, RA_CUST_TRX_TYPES_ALL, and RA_SALESREPS_ALL. Supporting lookups and reference data include FND_CURRENCIES, FND_LOOKUP_VALUES, GL_PERIODS, HR_OPERATING_UNITS, CE_BANK_ACCOUNTS, and various HZ_ customer and party tables. XML output relies on XMLTYPE, XMLAGG, and SYS_IXMLAGG. Utility dependencies include AR_GTA_TRX_UTIL, ARH_ADDR_PKG, FND_FILE, FND_LOG, and FND_MESSAGE.

Usage Notes

AR_GTA_REPORTS_PKG is not referenced by any other database object, indicating it is invoked directly by concurrent programs, forms, or custom code rather than serving as a shared library. The use of FND_FILE and FND_LOG strongly suggests these routines are called from concurrent program executables that write report output and log messages. Typical invocation occurs when a tax or financial analyst runs GTA reconciliation or discrepancy reports to compare recorded GTA tax lines with the corresponding Receivables transactions, review consolidated invoice mappings, or extract discrepancies as XML for downstream processing. All references are resolved through APPS synonyms, so the package must be compiled and executed in the APPS schema context.