CSW 9.1 J_Stage_PS_ITEM_LINE_SF_CS9_EPM91 DRS_TGT_PS_ITEM_SF_INSERT.IDENT1: ORA-01843: not a valid month
(Doc ID 1586857.1)
Last updated on MARCH 09, 2020
Applies to:PeopleSoft Enterprise EPM Campus Solutions Warehouse - Version 9.1 and later
Information in this document applies to any platform.
The Root Cause was identified as bad Campus Solutions Source Data being loaded into Target PeopleSoft Enterprise EPM Campus Solutions Warehouse.
By using a 'where clause' to filter out the bad data a SQL statement can then generated to extract this bad data for clean up.
LastModifiedDateTime = 1753-01-01 00:00:00
Message: J_Stage_PS_ITEM_LINE_SF_CS9_EPM91..DRS_TGT_PS_ITEM_SF_INSERT.IDENT1: ORA-01843: not a valid month
POSTED_DATE = 2001-06-27 00:00:00
ITEM_EFFECTIVE_DT = 2001-05-17 00:00:00
GL_POSTING_DTTM = 2001-08-31 00:00:00
BILLING_DT = 1753-01-01 00:00:00
DUE_DT = 1753-01-01 00:00:00 <
DISPUTE_DT = 1753-01-01 00:00:00
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