My Oracle Support Banner

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.

Purpose

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.

 J_Stage_PS_ITEM_LINE_SF.txt

LastModifiedDateTime = 1753-01-01 00:00:00
CS_FROM_DATE=1753-01-01 00:00:00
CS_TRANZ_DT=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

Troubleshooting Steps

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
Purpose
Troubleshooting Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.