Not able to clear Enddate from Oracle Apps endpoint using PX

book

Article ID: 185180

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Portal CA Identity Suite

Issue/Introduction

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).

Cause

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.

Environment

Release : 14.x

Component : IdentityMinder(Identity Manager)

Resolution

Via PX, use and set the value "0" to reset end date