My Oracle Support Banner

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 later
Information 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


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