Argentine Turnover Tax Data Upload Verification Report Do Not Update Data And Has Performance Issues (Doc ID 1996141.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for the Americas - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Argentina Payables

When attempting to run the Argentine Turnover Tax Data Upload Verification Report,
the following error occurs.

ERROR
-----------------------
Starting PKG JL_AR_APPLICABLE_TAXES.beforeReport
P_REV_TEMP_DATA :Y
P_VALIDATION_DATA :Y
P_FINALIZE_DATA :N
P_START_DATE :
P_END_DATE :
ORG_ID :28111
Starting the FINAL_VALIDATION procedure
2 .RECORD PASSED IN BASIC VALIDATION FOR TAXPAYER: 23165717309
3 B .GOING TO START THE AP VALIDATION FOR TAXPAYER: 23165717309
1-N-1: l_1N1_MODEL=N
12 .NO CORRESPONDING TAXPAYER_ID IN JL_AR_TURN_UPL
 31 . EXIST_CHECK_FLAGY
 31 . WHT_CHECK_UNIQUEN
34 . l_SUPP_AWT_TYPE_ID_TYPES6007andl_VENDOR_ID2404283
35 .Insert in JL_ZZ_AP_SUPP_AWT_TYPES not done - -1 -
ERROR- ORA-00001: unique constraint (JL.JL_ZZ_AP_SUPP_AWT_TYPES_U2) violated
...
39. l_SUPP_AWT_CODE_ID_CD
40 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID6005
40. l_tax_id11437L_EFFECTIVE_START_DATE01-SEP-14
41 . l_tax_id11437l_EFFECTIVE_START_DATE01-SEP-14
41 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD for 1 Records and code id is :6005
42 . l_tax_id11437l_SUPP_AWT_CODE_ID_CD188l_EFFECTIVE_START_DATE-101-SEP-14
42 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR PRIMARY_TAX_FLAG AS N AND EFFECTIVE_START_DATE FOR 1 RECORDS
46 C. UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID
In Insert_Row, value of final_insert_checkY
UPDATED record in JL_AR_TURN_UPL for Payables
47 . Inserted data in JL_AR_TURN_UPL for All Records
2 .RECORD PASSED IN BASIC VALIDATION FOR TAXPAYER: 30517050225
3 B .GOING TO START THE AP VALIDATION FOR TAXPAYER: 30517050225
1-N-1: l_1N1_MODEL=N
4 .MORE THAN ONE WHT_RATE AND WHT_GROUP_NUM FOUND FOR A TAX_PAYER_ID
49 .TAXPAYER ID FAILED IN FINAL VALIDATION, FETCHING NEXT RECORD - -20999 -
ERROR- ORA-20999: AN ERROR WAS ENCOUNTERED IN WHT_GROUP_NUM AND WHT_RATE VALIDATION -1422 -ERROR- ORA-01422: exact fetch returns more than requested number of rows

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Argentine localization
2. Path: Other -> Requests -> Run
3. Run the Argentine Turnover Tax Data Upload Verification Report

A) If the user loads 5 million records from the tax authority and run the validation process
with the following parameters shown below (to validate the data) the process runs for more than 18 hours without finishing.

P_REV_TEMP_DATA :Y
P_VALIDATION_DATA :Y
P_FINALIZE_DATA :N

So this is an issue regarding the performance of the validation process.
It does not seem to be able to process the large amount of data that is received from the tax authorities.

There are more than 5 MILLION records in JL_AR_TURN_UPL_T table.
It has never worked before.
The publish_date in the table is 25th Aug 2014.
Did not truncate (delete) the table before uploading new text file from Gov because it was empty.
The process is being used for the first time.

B) Loadind just 26 records for suppliers the process runs and completes in seconds.
However, the log and output files contain errors that indicate the process was not successful.

The issue has the following business impact:
Due to this issue, customer will not be in compliance with the Argentinean Government Laws



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms