My Oracle Support Banner

Shipping Operations Page (HTML) Error in Deliveries, Trips and Stops Tabs After Changing Date Format (Doc ID 2610057.1)

Last updated on NOVEMBER 18, 2019

Applies to:

Oracle Shipping Execution - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Shipping Transactions form

After date format is changed the Shipping Operations page (Shipping Execution Simplified UI) displays error in Deliveries, Trips and Stops tab

ERROR
The page shows this message:

You have encountered an unexpected error. Please contact your System Administrator for assistance

Click on "Exception Details" and there is a very long list. This is a partial snippet:
 
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT WshNewDeliveryEO.ACCEPTANCE_FLAG, WshNewDeliveryEO.ACCEPTED_BY, WshNewDeliveryEO.ACCEPTED_DATE ....


Other Details
-----------------------
==> Issue occured after changing the default date format: dd-MMM-yyyy to format to yyyy.MM.dd using Responsibility: Preferences SSWA > General
==> There is no error when the default date format is used: dd-MMM-yyyy
==> Other date formats experiencing the same error: yyyy-MM-dd, yyyy-MMM-dd

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Preferences SSWA > General
2. Change the default date format: dd-MMM-yyyy to format to yyyy.MM.dd
3. Responsibility: Shipping Operations > Deliveries
4. Form shows mentioend error

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


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