OBIA 11.1.1.8.1 SILOS_SIL_PURCHASECYCLELINESFACT Failed With An “ORA-01843: Not A Valid Month Error”. (Doc ID 1970536.1)

Last updated on JULY 18, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

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:
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.

OBIA:
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.


Cause

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