Technology Stack - EBS (MOSC)

MOSC Banner

Getting ORA-01847 while loading null value to a date field in sql loader program

edited Aug 20, 2021 11:36AM in Technology Stack - EBS (MOSC) 7 commentsAnswered ✓

Hi,

Ebs Ver: 12.2.4

DB Ver: 11.2.0.3.0

I am trying to load a data file into a table using sql loader program. The table has a date field inactive_date and this can have a valid date or can be null.

Attached is the control file and data file I am using to load the data. I am able to load the data successfully when there is a value exist in the data file for the inactive_date field but it is not loading the data when the field is blank in the data file. I am getting below error message in the error log.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center