Oracle Apps Endpoint EndDate Reset Failure Using Policy Xpress (PX)
search cancel

Oracle Apps Endpoint EndDate Reset Failure Using Policy Xpress (PX)

book

Article ID: 185180

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Portal CA Identity Suite

Issue/Introduction

 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 ''

Environment

Identity Manager

Cause

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.

Resolution

To reset the EndDate field via Policy Xpress, do not attempt to delete the value. Instead:

  1. Configure the PX policy Action Rule.
  2. Set the EndDate value to 0.

Setting the value to 0 allows the connector to successfully clear the date without triggering a NULL value error.