My Oracle Support Banner

"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 JULY 03, 2023

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


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



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

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