R12:AP: Payables Open Interface Import Completed with ORA-01858 Error
(Doc ID 3001100.1)
Last updated on MAY 24, 2024
Applies to:
Oracle Payables - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, Invoice Issues
Payables Open Interface Import completed error
ERROR
-----------------------
REP-0613: Value does not match mask 'YYYY/MM/DD HH24:MI:SS'.
ORA-01858: a non-numeric character was found where a numeric was expected
REP-0091: Invalid value for parameter 'P_GL_DATE'.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
An API is being used to call the import program.
When Payables Open interface Import program is run manually with format like 2024/01/08 00:00:, then it works.
When it's run with format 08-JAN-2024, then it doesn't work.
It has been working fine till December -2023.
Start 1-Jan-2024, it doesn't work anymore.
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 |
| Cause |
| Solution |