ORA-01830: date format picture ends before converting entire input string
(Doc ID 2650699.1)
Last updated on SEPTEMBER 01, 2024
Applies to:
Oracle E-Business Suite Integrated SOA Gateway - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.5 version, Installation Issues
ACTUAL BEHAVIOR
---------------
Getting an "ISG_SERVICE_EXECUTION_ERROR" while testing a REST Service
After implementing REST services by following the note # 1311068.1] (Section 2: Configuring Oracle E-Business Suite Integrated SOA Gateway for REST Services).
Able to "deploy" , "undeploy" successfully.
But running into issues while accessing it through the REST client (postman or chrome extension).
Error message in the log file:
========================================
Tue Mar 10 10:38:04 EDT 2020 : [ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)' : oracle.apps.fnd.isg.app.ebs.rt.common.ErrorContext.makeRestException : ErrorContext -> ErrorCode = ISG_SERVICE_EXECUTION_ERROR, ErrorMessage = Service execution error - Stored procedure invocation error.
Error while trying to prepare and execute the APPS.FND_USER_PKG.LOAD_ROW API.
An error occurred while preparing and executing the APPS.FND_USER_PKG.LOAD_ROW API. Cause: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string
ORA-06512: at "APPS.FND_USER_PKG", line 1206
ORA-06512: at line 1
Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-1830" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.
Tue Mar 10 10:38:04 EDT 2020 : [ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)' : oracle.apps.fnd.isg.app.ebs.rt.common.ErrorContext.makeRestException : ISGException -> ErrorCode = ISG_SERVICE_EXECUTION_ERROR, ErrorMessage = Service execution error - Stored procedure invocation error.
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 |