Entitlements not showing under Catalog in OIM 11G R2 PS2

For entitlements & App instances to show under catalog in the OIM self-service page, we need to SET IS_REQUESTABLE column to ‘1’ in the database Catalog table.

Query to show Entitlements under OIM self-service catalog page :

Update catalog set is_requestable=1 where entity_display_name='<Name of the entitlement which is not showing under catalog in OIM self-service page>';

Commit;

Query to show Application Instance under OIM self-service catalog page :

Update catalog set is_requestable=1 where entity_display_name='<Name of the App Instance which is not showing under catalog in OIM self-service page>';

Commit;