ORA-20001: Unexpected Error Occurred During Tax Calculation Exception: User-Defined Exception

(Doc ID 1607837.1)

Last updated on DECEMBER 30, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, India AP Localizations 

 When Trying to validate Receipt matched invoices with Import related taxes attached , facing the below error while validation 

ORA-20001: Unexpected error occurred during Tax Calculation Exception: User-Defined Exception

Enter Password:
MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20001
MSG-00103: Error Message : ORA-20001: Unexpected error occurred during Tax Calculation.
Exception: User-Defined Exception
Please correct the problem or contact your System Administrator. (CALLING_SEQUENCE=) (PARAMETERS=Run Option = All, Batch Id = , Begin Date = , End Date = , Vendor Id = XXXXXX, Pay Group = , Invoice Id = XXXXXX, Entered By = , Concurrent Request Id = XXXXXX, Org Id = XXXXXX)
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_APPROVAL_PKG", line 9429
MSG-00000: When Others:User-Defined Exception
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20001
MSG-00103: Error Message : ORA-20001: Unexpected error occurred during Tax Calculation.
Exception: User-Defined Exception
Please correct the problem or contact your System Administrator. (CALLING_SEQUENCE=) (PARAMETERS=Run Option = All, Batch Id = , Begin Date = , End Date = , Vendor Id = XXXXXX, Pay Group = , Invoice Id = XXXXXX, Entered By = , Concurrent Request Id = XXXXXX, Org Id = XXXXXX)

In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN before call JAI_AP_OI_PROCESSING_PKG.PROCESS_INVOICE invoice_id= XXXXXX
In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_pss invoice_id=XXXXXX
In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_lines LINE_NUMBER=XXXXXX
Encountered an error in JAI_AP_OI_PROCESSING_PKG.pre_data_for_ap_line SQLERRM : ORA-20001:
Encountered an error in JAI_AP_OI_PROCESSING_PKG.pre_data_for_ap_line SQLERRM : ORA-20001:

 

ERROR
-----------------------

In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN before call JAI_AP_OI_PROCESSING_PKG.PROCESS_INVOICE invoice_id=10551461
In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_pss invoice_id=10551461
In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_lines LINE_NUMBER=1
Encountered an error in JAI_AP_OI_PROCESSING_PKG.pre_data_for_ap_line SQLERRM : ORA-20001:
Encountered an error in JAI_AP_OI_PROCESSING_PKG.pre_data_for_ap_line SQLERRM : ORA-20001:



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Purchase Order with Adhoc CVD Taxes  
2. Approve the PO
3. Create a Receipt for the PO
4. Apply BOE
5. Navigate to General Ledger and import where source is Purchasing India 
6. Post the journal
7. Create a Receipt matched invoice 
8. Now when trying to validate Invoice , facing error message 
   Error Message : ORA-20001: Unexpected error occurred during Tax
   Calculation.
   Exception: User-Defined Exception
   Please correct the problem or contact your System Administrator

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot validate for invoices related to import taxes .

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