OBIA 126.96.36.199.1 SILOS_SIL_PURCHASECYCLELINESFACT Failed With An “ORA-01843: Not A Valid Month Error”.
Last updated on JULY 18, 2017
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.
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