R12: AP Invoice Validation Request Fails To Validate Invoices With ORA-01403 (Doc ID 1421873.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On 12.1.3 in Production:
When attempting to run Invoice Validation, the following error occurs.

ERROR
-----------------------
"Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTaxORA-01403: no data found
ORA-01403: no data found"
ZX_API_PUB: DUMP_MSG()+
0 Error Message(s) dumped into Zx_Errors_GT.
ZX_API_PUB: DUMP_MSG()-
Handle errors returned by API
Get error message from eTax API
Get error message from stack

Invoice Validation did not process Invoice Number: <Invoice number>
Error: User-Defined Exception
Exception: User-Defined Exception Invoice Validation did not process Invoice Number: <Invoice number>"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Invoice Validation program
2. Getting warning:
"Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTaxORA-01403: no data found
ORA-01403: no data found"
ZX_API_PUB: DUMP_MSG()+
0 Error Message(s) dumped into Zx_Errors_GT.
ZX_API_PUB: DUMP_MSG()-
Handle errors returned by API
Get error message from eTax API
Get error message from stack

Invoice Validation did not process Invoice Number: <invoice number>
Error: User-Defined Exception
Exception: User-Defined Exception Invoice Validation did not process Invoice Number: <Invoice number>"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete Invoice Validation program.

Cause

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