R12 E-Business Suite XML Gateway Request Purge Obsolete ECX Data (FNDECXPR) Fails With Error "FDPSTP failed due to ORA-01861: literal does not match format string ORA-06512: at line 1 "
(Doc ID 2358584.1)
Last updated on FEBRUARY 26, 2022
Applies to:
Oracle XML Gateway - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
E-Business Suite R12 XML Gateway, Install, Design, Transport, and Setup related issues
When Trying to run the Purge ECX data per <Note 2198322.1>: How To Run Purge Obsolete ECX Data (FNDECXPR) (Doc ID 2198322.1) the following error is received:
FNDECXPR: Purge Obsolete ECX Data ORA-01861: literal does not match format string
The request log shows the following details:
FNDECXPR: Purge Obsolete ECX Data
+---------------------------------------------------------------------------+
Current system time is xxxxx
+---------------------------------------------------------------------------+
**Starts** date/time
**SQL error and free**date/time
ORACLE error 1861 in FDPSTP
Cause: FDPSTP failed due to ORA-01861: literal does not match format string
ORA-06512: at line 1
==================================================================
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 |
References |