Argentine Turnover Tax Data Upload Verification Report Doesn’t Recognize The Tax Payer ID Number Even if the Number is in the Customer Form (Doc ID 1284794.1)

Last updated on JULY 11, 2018

Applies to:

Symptoms

Argentine Turnover Tax Data Upload Verification Report JLARPATB

The program doesn’t recognize the tax payer id number even if the number is in the customer form.

In the loaded file, we have a taxpayer number on 11 characters.
In  jlarpatb.pls package, in the “AP tax payer id available check”, there is a command to retrieve the last character.

In the “AR tax payer id available check”,  there is no command to retrieve the last character. It seems that this is the problem.
For example, my tax payer id number is ‘33695098419’ in the file.
The check in the “AR tax payer id available check” is on the JGZZ_FISCAL_CODE which is 3369509841 so only the 10 first characters.  (HZP.JGZZ_FISCAL_CODE = TO_CHAR(l_TAXPAYER_ID))
Thus, the program can’t match the JGZZ_FISCAL_CODE with the tax payer id in the file.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.