"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
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 |