Not able to clear Enddate from Oracle Apps endpoint using PX
Article ID: 185180
CA Identity ManagerCA Identity PortalCA Identity Suite
We are using the Oracle Apps connector to provision the users from IM to Oracle Apps endpoint. We are facing an issue where Enddate in Oracle Apss endpoint is not getting cleared by PX policies.
We have created a PX policy and in the Action rule we are removing the Enddate directly in Oracle Endpoint. Policy is triggered correctly but the Enddate is not cleared. We are able to clear this field when editing the account directly using IMPM (Provisioning Manager).
Reviewing the logs we can see that, when utilizing IMPM, the value is being set to 0 WARNING eTFNDDirectory::ORACLEAPPS1- CFndTarget::SetColumnValue(): Unicenter date set to 0. Skipping....
While utilizing PX, it is trying to delete the current value, then add a new one ERROR eTFNDDirectory::ORACLEAPPS1- CFndTarget::SetColumnValue(): MOD_DELETE: Unhandled sqlType (9) ERROR eTFNDDirectory::ORACLEAPPS1- CFndTarget::SqlUpdateUserAolOnly(): SqlColumnValue() failed with ''
The endpoint cannot handle the NULL value therefore operation is failing.
Release : 14.x
Component : IdentityMinder(Identity Manager)
Via PX, use and set the value "0" to reset end date