Orchestration

Oracle Identity Manager Orchestration  

Any action performed by a user or system in Oracle Identity Manager is an operation.

• The process of any Oracle Identity Manager operation that goes through a predefined set of stages and executes some business logic in each stage is called an orchestration.
• Orchestration is divided into predefined steps called stages. Every operation moves through these stages until it reaches finalization. Orchestration has the following stages

More details about OIM Orchestration                           

Monitoring OIM Orchestration

For OIM R2 PS2:

• EM console: http://fusionsecurity.blogspot.com/2014/06/monitoring-oim-r2-ps2-orchestration.html

• DB with sql queries: 

Tables involved

ORCHPROCESS : Stores the process instances that are being executed.

ORCHEVENTS: Stores event handler names, status and result for all orchestration processes.

Event status like COMPLETED, FAILED, PENDING, etc.

ORCHFAILEDEVENTS : Stores event handler information that are executed because of failures in main flow.

1. The query to get user key from usr table.

select usr_key from USR where usr_login = 'USER_LOGIN_NAME';

2. The query get process instance of enabled user 'USER_LOGIN_NAME'

select id from orchprocess where entityid=’USR_KEY’ and entitytype='User' and operation='ENABLE';

3. The query gets all the event handler for enabled user of step 1

select * from orchevents where processid='RESULT_OF_2' order by orchorder;

*Operation @ query step 2 can be enable, Create User, Provision Account, and Assign Role Membership,etc.

For OIM R2 PS3:

• Table ORCHEVENTS dropped. All Orchestration events logged to server diagnostics log.  
• EM console monitoring only available with MBean due to the above changes.

  Purging Orchestration

OIM Data Purge Job scheduled job

In the Job Details for OIM Data Purge Job, confirm that the Orchestration Entity Selection, the Provisioning Task Entity Selection, and the Recon Entity Selection values are Yes.

Real-time purge supports online mode only. Command-line Archival Purge Utilities support both online and offline modes based on the user input.
http://docs.oracle.com/cd/E40329_01/admin.1112/e27149/archival_utilities.htm#OMADM5348