OBIA 126.96.36.199.1 SILOS_SIL_PURCHASECYCLELINESFACT Failed With An “ORA-01843: Not A Valid Month Error”.
(Doc ID 1970536.1)
Last updated on JANUARY 19, 2021
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52.1 and later
Information in this document applies to any platform.
SILOS_SIL_PURCHASECYCLELINESFACT failed with an “ORA-01843: not a valid month error”. It was attempting to convert a WID to a date.
There are two root causes. One in EBS and one in OBIA.
EBS has rows with a date of August 1, 201, and December 1, 201 or formatted another way 02010801 and 02011201 using the YYYYMMDD format mask.
This is not a typo. The date is 1,800 years in the past due to a data entry error.
The date from EBS above is loaded to the OBIA the W_RQSTN_LINE_COST_FS, and the W_RQSTN_LINE_COST_F tables successfully because the date is loaded directly to a DATE column in the W_RQSTN_LINE_COST_FS table, and the converted via a TO_NUMBER function for the WID in the W_RQSTN_LINE_COST_F table.
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