Convert accountexpires in Active Directory to Human Read format using Excel

=IF(C2>0,C2/(8.64*10^11) - 109205,"")

This formula works for GMT.



If your time zone is GMT+10, subtract 10/24 (with 7-8 decimals) leading to 109204.58333333

If it is GMT-10, Add 10/24 leading to 109205.0.416666666666667.

Oracle Identity Manager OIM : How to pre populate process form with OIM User Data

Go To Design Console and Click Adapter Factory and create a prepopulate adapter. 

Adapter Name: OID Prepop String
Adapter Type: Pre-populate Rule Generator
Description: Pre-Populate String Fields

Save

Click on Variable List tab and add a variable:

Variable Name: attrvalue
Type: String
Description: value to be prepopulated
Map To: Resolve at runtime

Save

Click on Adapter Tasks and click Add
Logic Task
SET VARIABLE

Adapter return value = attrvalue

Save and click Build

2. Go Back to Form Designer and find the process form

Create a new version and click on Pre-populate tab.

For each field that you want to prepopulate add the prepop adapter;
Eg:
Field Name: EndDate
Rule:Default
Adapter: OID Prepop String
Order: 1
Map the variable to the User Definition ->EndDate

Do the same for all other fields.

Make the new version of the form ACTIVE.

3. Go to access policy,  Remove the resource form and add it back.as it will pick up the new form version in the access policy.

4. At this point, the adapters should be firing when the access policy provisions the resource and the values from the user definition will be in the process form.