# ISC is unable to make an attribute as Null from an existing value for Active Directory Application and JDBC Oracle DB **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** workflows, rules, attributes, provisioning, sailpoint-identity-security, connectors\ **Created:** [November 27, 2025, 2:01pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392 "2025-11-27T14:01:24Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![vsekar7](https://avatars.discourse-cdn.com/v4/letter/v/aeb1de/32.png) [@vsekar7](https://developer.sailpoint.com/discuss/u/vsekar7)\ **Post date:** [November 27, 2025, 2:01pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/1 "2025-11-27T14:01:24Z")
#### We are using the transform “Kenvue Update ccStopDate” in the AD application’s Create/Update account provisioning policy mapped to AD attribute “stopdate” (This issue is in Prod/Test tenants) and the the Identity attribute oedstopdate is mapped to jdbc OED DB attribute “stopdate” (This issue is in test tenant). We have issue with our tenants where ISC is unable to remove already existing value and update as Null ---
**Author:** ![vsekar7](https://avatars.discourse-cdn.com/v4/letter/v/aeb1de/32.png) [@vsekar7](https://developer.sailpoint.com/discuss/u/vsekar7)\ **Post date:** [November 27, 2025, 2:58pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/2 "2025-11-27T14:58:26Z")
The issue is ISC unable to make any attribute as Null from the previously available values in the Active Directory Connector and JDBC connector across our tenants. ---
**Author:** ![pkMishra](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/pkmishra/32/30342_2.png) [@pkMishra](https://developer.sailpoint.com/discuss/u/pkMishra)\ **Post date:** [November 27, 2025, 3:03pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/3 "2025-11-27T15:03:49Z")
Hi @vsekar7 , As far as I understood, you’re facing an issue with identity attribute value which is being set based on JDBC application attribute “stopdate”. But when you say ISC unable to remove existing value and update it as null. Are you looking to set identity attribute value as null? Could you provide me more context and applied mapping with and without transform. ---
**Author:** ![vsekar7](https://avatars.discourse-cdn.com/v4/letter/v/aeb1de/32.png) [@vsekar7](https://developer.sailpoint.com/discuss/u/vsekar7)\ **Post date:** [November 27, 2025, 3:05pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/4 "2025-11-27T15:05:34Z")
Hi @pkMishra , Yes, I have an example of an Rehire Employee case. The Employee has stopdate as past date in Oracle DB. During the rehire process, ISC has to remove that date and make it as Null in Oracle Database whereas it is unable to make this change in JDBC connector. ---
**Author:** ![aghzere](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/aghzere/32/37690_2.png) [@aghzere](https://developer.sailpoint.com/discuss/u/aghzere)\ **Post date:** [November 27, 2025, 3:16pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/5 "2025-11-27T15:16:46Z")
Hi @vsekar7 , If the value is an empty string, ISC will not consider Null as different value, thus no update will be done. But as I understand, the value in the target source (JDBC) isn’t empty nor null, although, ISC doesn’t update the attribute in the source to null as expected. As you use JDBC, that means you’re using a JDBC Provision rule, can you share it with us for troubleshooting. Thank you, Youssef ---
**Author:** ![lampard08](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/lampard08/32/32646_2.png) [@lampard08](https://developer.sailpoint.com/discuss/u/lampard08)\ **Post date:** [November 27, 2025, 3:52pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/6 "2025-11-27T15:52:52Z")
what does your transform do in case it has to return null? can you post your transform here? ---
**Author:** ![vsekar7](https://avatars.discourse-cdn.com/v4/letter/v/aeb1de/32.png) [@vsekar7](https://developer.sailpoint.com/discuss/u/vsekar7)\ **Post date:** [November 27, 2025, 4:12pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/7 "2025-11-27T16:12:56Z")
Hi @aghzere , The JDBC source attribute “Stopdate“ is mapped to Identity Attribute “JDBC Stop Date“ and the identity attribute use the below transform rule. For Employees, the transform rule is sending the JDBC stop date as Null when an Employee is rehired by removing the previous date which was already present. **JDBC Provisioning Rule:** String _inputTerm_ = getAttributeRequestValue(account, “STOPDATE”); ``` if(inputTerm != **null** ) { String *formattedTermDate* = changeDateformat(inputTerm); *statement*.setString(39, inputTerm); } else { *statement*.setString(39, ""); } ``` if(getAttributeRequestValue(account, “STOPDATE”) != **null** ) ``` { statement = *connection*.prepareStatement("UPDATE JJEDS_ADMIN.PERSN_ALL SET STOPDATE = ? WHERE WWID = ?"); String *inputTerm* = getAttributeRequestValue(account, "STOPDATE"); String *formattedTermDate* = changeDateformat(inputTerm); *statement*.setString(1, formattedTermDate); *statement*.setString(2, identity); *statement*.executeUpdate(); } ``` **Transform Rule:** “name”: “Update JDBCStopDate”, ``` "type": "static", "attributes": { "requiresPeriodicRefresh": "true", "getEmployeeType": { "attributes": { "values": \[ { "attributes": { "attributeName": "OU__c", "sourceName": "Workday" }, "type": "accountAttribute" } \] }, "type": "firstValid" }, "contractExpirationDate": { "type": "dateFormat", "attributes": { "type": "firstValid", "input": { "type": "accountAttribute", "attributes": { "attributeName": "CONTRACT_END_DATE", "sourceName": "Workday" } }, "inputFormat": "MM/dd/yyyy", "outputFormat": "ISO8601" } }, "endDate": { "type": "dateFormat", "attributes": { "type": "firstValid", "input": { "type": "accountAttribute", "attributes": { "attributeName": "LAST_DAY_OF_WORK", "sourceName": "Workday" } }, "inputFormat": "MM/dd/yyyy", "outputFormat": "ISO8601" } }, "value": "#{if}($getEmployeeType == 'Employee')$endDate#{elseif}($getEmployeeType == 'Contingent Worker')$contractExpirationDate#{end}" }, "internal": **false** ``` ---
**Author:** ![lampard08](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/lampard08/32/32646_2.png) [@lampard08](https://developer.sailpoint.com/discuss/u/lampard08)\ **Post date:** [November 27, 2025, 4:39pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/8 "2025-11-27T16:39:40Z")
try this model : “contractExpirationDate”: { ```auto "type": "dateFormat", "attributes": { "type": "firstValid", "values": [ { "attributes": { "attributeName": "CONTRACT_END_DATE", "sourceName": "Workday" }, "type": "accountAttribute" }, { "attributes": { "value": "NOENDDATE" }, "type": "static" } ] }, "inputFormat": "MM/dd/yyyy", "outputFormat": "ISO8601" } }, ``` ---
**Author:** ![vsekar7](https://avatars.discourse-cdn.com/v4/letter/v/aeb1de/32.png) [@vsekar7](https://developer.sailpoint.com/discuss/u/vsekar7)\ **Post date:** [November 28, 2025, 8:50am UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/9 "2025-11-28T08:50:28Z")
Hi @lampard08 , The issue is the below transform code is updating new value as Null in Identity attribute but it is not replicated in Oracle db via jdbc source ---
**Author:** ![lampard08](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/lampard08/32/32646_2.png) [@lampard08](https://developer.sailpoint.com/discuss/u/lampard08)\ **Post date:** [November 30, 2025, 9:40pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/10 "2025-11-30T21:40:57Z")
are you using attribute sync to AD for this update? ---
**Author:** ![vsekar7](https://avatars.discourse-cdn.com/v4/letter/v/aeb1de/32.png) [@vsekar7](https://developer.sailpoint.com/discuss/u/vsekar7)\ **Post date:** [December 1, 2025, 7:13am UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/11 "2025-12-01T07:13:14Z")
We are using a transform code to calculate the stop date for Contractors/Employees in ISC and we are using the transform in our AD create/update provisioning policy & we are not using the transform to update in Identity attribute and then using attribute in AD source ---
**Author:** ![lampard08](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/lampard08/32/32646_2.png) [@lampard08](https://developer.sailpoint.com/discuss/u/lampard08)\ **Post date:** [December 1, 2025, 1:16pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/12 "2025-12-01T13:16:53Z")
try to enable attribute sync just for this attribute i you have a test region ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [January 30, 2026, 1:17pm UTC](https://developer.sailpoint.com/discuss/t/isc-is-unable-to-make-an-attribute-as-null-from-an-existing-value-for-active-directory-application-and-jdbc-oracle-db/189392/13 "2026-01-30T13:17:01Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.