Search Results get_consolidation_trx

Overview

AR_GTA_REPORTS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that generates the reports and diagnostic outputs associated with the Golden Tax Adaptor (GTA). The Golden Tax Adaptor is the component of Oracle Receivables that interfaces EBS transactional data with Chinese Golden Tax ( VAT invoice) compliance processing, exporting invoice and tax registration information in the formats required by the tax authority and reconciling that exported data against the AR subledger. This package encapsulates the reporting, comparison, and discrepancy-analysis logic used to validate the Golden Tax interface before and after data is pushed to the external Golden Tax system.

The package header was created in May 2005 and has been extended across multiple releases. The most relevant enhancement for the 12.1.1 / 12.2.2 timeframe is recorded in the header history for 25-Jul-2009, which added Get_Consolidation_Trx, Get_Consolidated_Trxs, and Generate_Consol_Mapping_Rep under bug 8605196, described as an enhancement for Golden Tax Adaptor R12.1.2. The package is declared AUTHID CURRENT_USER and defines a global module prefix, G_MODULE_PREFIX, set to 'ar.plsql.AR_GTA_REPORTS_PKG' to conform to FND logging standards.

Key Procedures and Functions

The documented callable units (13 total) fall into three functional groups.

• Extraction and counting: GET_GT_COUNT returns the count of Golden Tax transactions associated with a given AR transaction. GET_AR_TRX retrieves AR transaction data for reporting. GET_GT_TRXS retrieves Golden Tax transaction records. GET_CONSOLIDATION_TRX and GET_CONSOLIDATED_TRXS return consolidation transaction data introduced by the R12.1.2 enhancement.
• Report generation: GENERATE_MAPPING_REP produces the mapping report that relates AR transactions to their Golden Tax counterparts. GENERATE_CONSOL_MAPPING_REP produces the equivalent mapping report for consolidated transactions — the object referenced by the search term "generate_consol_mapping_rep". GENERATE_DISCREPANCY_REP and GENERATE_DISCREPANCY_XML produce discrepancy reporting in report and XML forms respectively.
• Comparison and reconciliation: COMPARE_HEADER and COMPARE_LINES compare header-level and line-level data between the AR and Golden Tax sources. COMPARE_CONSOLIDATED_INV performs the equivalent comparison for consolidated invoices. GET_UNMATCHED_LINES returns lines that failed to match during comparison, feeding the discrepancy outputs.

Parameter details are not reproduced here; the documented signatures should be confirmed directly against the package specification before invocation.

Tables Accessed

The package reads and writes a set of Golden Tax staging and parameter tables, together with standard EBS reference tables. The GTA transaction tables AR_GTA_TRX_HEADERS, AR_GTA_TRX_HEADERS_ALL, AR_GTA_TRX_LINES, and AR_GTA_TRX_LINES_ALL hold the Golden Tax header and line records that the extraction and mapping routines report on. AR_GTA_SYSTEM_PARAMETERS_ALL supplies configuration values controlling Golden Tax processing. The temporary result tables AR_GTA_AR_DIFFERENCE_TEMP, AR_GTA_DIFFERENCE_TEMP, AR_GTA_MISSING_ARTRX_TEMP, and AR_GTA_UNMATCHED_TEMP store the output of the comparison routines, including mismatched lines and AR transactions missing from the Golden Tax extract.

Standard reference data is drawn from CE_BANK_ACCOUNTS (bank account details printed on invoices), FND_CURRENCIES (currency codes and descriptions), FND_LOOKUP_VALUES (flexible lookup translations), GL_PERIODS (accounting period definitions), and HR_ALL_ORGANIZATION_UNITS (organization and legal entity information). The XMLTYPE datatype reference indicates that GENERATE_DISCREPANCY_XML constructs an XML document directly in the database.

Usage Notes

AR_GTA_REPORTS_PKG is not part of the public Receivables API surface; it is an internal reporting utility and is referenced by one other package in the ETRM inventory. In practice it is invoked from the Golden Tax Adaptor concurrent programs and from the GTA-related forms, which administer the mapping and discrepancy reports during the monthly Golden Tax run. Custom code that needs to reproduce the consolidated mapping output should call GENERATE_CONSOL_MAPPING_REP after the consolidation extraction routines (GET_CONSOLIDATION_TRX / GET_CONSOLIDATED_TRXS) have populated the working data, and should expect results to be staged in the AR_GTA_*_TEMP tables rather than returned by value. Because the package runs AUTHID CURRENT_USER, execution is subject to the privileges of the calling schema, and in 12.2.2 online patching further restricts when the package can be safely recompiled or invoked during an active patching cycle.