My Oracle Support Banner

R12:AP: Payables Open Interface Import Completed with ORA-01858 Error (Doc ID 3001100.1)

Last updated on JANUARY 30, 2024

Applies to:

Oracle Payables - Version 12.2.10 and later
Information 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


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