"SQL Error = ORA-01830: Date Format Picture Ends Before Converting Entire Input String" when Running the 'Inventory Value History' Report (CMS2010) with the 'Last Price Used' Cost Comparison Criteria (Doc ID 1129664.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Manufacturing - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Cost Management - Version 8.4 SP2 and later
PeopleSoft Enterprise SCM Inventory - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
This Document applies to Cost Management releases 9.0 and 9.1 only

Symptoms

The 'Inventory Value History' report (CMS2010) (navigation: Cost Accounting, Inventory and Mfg Accounting, Reports, Inventory Value History) fails with the below error when run with the 'Last Price Used' Cost Comparison criteria.

SQL Error = ORA-01830: date format picture ends before converting entire input string

 

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