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 JANUARY 09, 2018

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

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
References


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