Database Applications Table (DBAT) 12.2.1.3 Connector - Date Field Is Updating As "01-JAN-70" Instead Of Null In Target Database
(Doc ID 2938595.1)
Last updated on APRIL 05, 2023
Applies to:
Identity Manager - Version 12.2.1.3.0 and laterIdentity Manager Connector - Version 12.2.1.3.0 and later
Information in this document applies to any platform.
Symptoms
In an OIG 12.2.1.3 environment using the Database Applications Table DBAT 12.2.1.3 connector for user provisioning against an Oracle Database target, the schema contains one mapping for Date field which is causing the following issue:
When updating empty value for the date field, it is getting updated as null in OIG process form (UD table) [working as expected].
However, in the target database, the value for this particular date field is updating as 01-JAN-70 instead of null.
However, in the target database, the value for this particular date field is updating as 01-JAN-70 instead of null.
The expectation is to be updated as null in the target database as well.
Cause
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
Symptoms |
Cause |
Solution |
References |