R12 : Card And Cash Invoice Stuck On Interface with error : APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small occurred in AP_ETAX_SERVICES_PKG.Populate_Lines_Import_GT<-AP_ETAX_SERVICES_PKG.Validate_Default_Impo
(Doc ID 2941244.1)
Last updated on DECEMBER 15, 2023
Applies to:
Oracle Payables - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
R12 12.2.9 version, Some of invoices for Concur New Zealand market are not getting interfaced into payables.
Run the payables invoice import program for more details about error.
Invoices are stuck with generic error message "VALIDATE DEFAULT IMPORT FAIL" in open interface.
ERROR
-----------------------
These invoices are stuck with generic error message "VALIDATE DEFAULT IMPORT FAIL" in open interface due to below error :
"APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small "
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Payables -> View -> Submit New Request -> Payables Invoice Import Program.
2. Check for the Log of the program.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |