Oracle Apps connector users provisioning from Identity Manager (IM) to Oracle Apps endpoints may find that the EndDate field does not clear when using Policy Xpress (PX) policies. While editing the account directly via Identity Manager Provisioning Manager (IMPM) works, the PX policy triggers correctly but fails to clear the field.
Reviewing the logs reveals that IMPM sets the value to 0, whereas PX attempts to delete the current value and add a new one, resulting in the following errors:
ERROR eTFNDDirectory::######- CFndTarget::SetColumnValue(): MOD_DELETE: Unhandled sqlType (9)ERROR eTFNDDirectory::######- CFndTarget::SqlUpdateUserAolOnly(): SqlColumnValue() failed with ''Identity Manager
The Oracle Apps endpoint cannot handle a NULL value for the EndDate field. When Policy Xpress attempts to perform a MOD_DELETE to clear the field, it sends a null value which the endpoint rejects.
To reset the EndDate field via Policy Xpress, do not attempt to delete the value. Instead:
EndDate value to 0.Setting the value to 0 allows the connector to successfully clear the date without triggering a NULL value error.