Overdue Vendor Shipments Report (XML) Completing with Error "java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string (Doc ID 2225285.1)

Last updated on JANUARY 20, 2017

Applies to:

Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Overdue Vendor Shipments Report (XML) completing with the following error in the log file:

ERROR
-----------------------
java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using a Purchasing responsibility
2. Navigate to Reports-> Run-> Single Request-> submit the Overdue Vendor Shipments Report (XML) report
3. It ends in error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms