Approval Workflow assignment not showing in “Pending Approval”, but visible from “Inbox” - OIM PS3

Problem Description:

After migrating OIM to PS3 from any previous version it was observed that, for all newly created SOA composite workflow assignment not getting visible in “Pending Approval” tile. But it is visible in “Inbox”. This problem occurred only with the newly created composites, not with any existing one, even if they are redeployed.

Reason:

In OIM PS3, there are some VIEWs created for displaying different types of pending approval tasks like below. These VIEWs are located in SOAINFRA schema.

In general, during SOA workflow composites deployment, the NameSpace url get registered with this view in order to display the pending approval task in the “Pending Approval” tile.

NameSpace URL

targetNamespace=http://xmlns.oracle.com/ApprovalApp/CustomManagerApproval/ApprovalTask

After upgrading OIM to PS3 from any previous version, this NameSpace url of newly created composites not getting registered with PENDING_APPROVALS_VIEW after deployment.

This problem will not occur if you install a fresh OIM PS3.

Resolution:

Register the NameSpace url of the composite manually with the PENDING_APPROVALS_VIEW. In order to perform this action, follow the below procedure:

1. Login to SOAINFRA schema (Use SQLDeveloper)
2. Open the table WFUSERTASKVIEW
3. Double Click on the BLOB and click on the pencil icon                                                   
4. Download the BLOB message in your desktop (save it as XML)       
5. Get the NameSpace url of the SOA composite from the ApprovalTask.task file and copy the same  
6. Open the BLOB message XML file and add the copied NameSapce url under the <valueList> tag as below:
7. Save the XML file.
8. Open the same SQLDeveloper and select the PENDING_APPROVALS_VIEW row of table WFUSERTASKVIEW
9. Double click on the BLOB and click on the pencil icon.
10. Click on the “Load” and select the modified XML file.       
11. Click on open the load the modified XML file.
12. Commit the changes in the database table.
13. No restart required.

Now you can see the Notification of the pending task in “Pending Approval” tile.