Search This Blog

Sunday, September 18, 2011

Query -To set status to Revoked for any resource for any user

update oiu set ost_key=(select ost_key from ost where obj_key=(select obj_key from obj where obj.obj_name = 'AD User') and ost_status='Revoked') where   oiu.orc_key in (
SELECT orc_key  FROM ud_aduser WHERE  ud_aduser_uid in ('test1')) ;
commit;

Wednesday, August 31, 2011

Query to find the rejected task in a package(Resource) for a particular task

select usr.usr_login, pkg.pkg_name, mil.mil_name, oti.sta_bucket
from oti, orc, oiu, usr, mil, tos, pkg
where oti.orc_key = orc.orc_key
and   orc.orc_key = oiu.orc_key
and   oiu.usr_key = usr.usr_key
and   oti.mil_key = mil.mil_key
and   mil.tos_key = tos.tos_key
and   tos.pkg_key = pkg.pkg_key
and   pkg.pkg_name = 'AD User'
and   mil.mil_name = 'Create User';

Courtesy : Amitabh Gangwar

Friday, July 8, 2011

How to Disable Change Password At Next Logon in OIM 11g

In OIM 9.1.0.2 there was a parameter that could be set to disable forced password changes:

System prop XL.ForcePasswordChangeAtFirstLogin

This parameter is no longer implemented in OIM 11g.

Steps

1. Go to WebLogic Domain ->
2. Right click and open 'System MBean Browser'
3. In the 'System MBean Browser' left panel, go to 'servername' -> Server: --> Application:oim --> XML Config --> Config --> XMLConfig.SSOConfig --> SSOConfig
4. Set the SsoEnabled flag to 'true' and apply

Then restart OIM server.

Thursday, March 31, 2011

How to change the status in the Response Tab from R to C (Rejected/Completed)


How to change the status in the Response Tab from R to C

1. First find the mil key for the task

select * from mil;

2. Find the sta key from sta table (R=1 and C=2)

3. Update the RSC Table

update rsc set sta_key = 1 where mil_key = 1300 and rsc_data = 'FAILURE';

Thanks



Thursday, January 13, 2011

Table is missing in Form Desginer after editing GTC.

Hi All,

I noticed this few times. While making changes in GTC - say from Full recon to incremental recon - UD_TABLE in form designer is missing in design console and we can see the table in The database.

Solution for this is check the FUG table and check the sdk entry for that table and if it is missing add it.

->select * from fug where sdk_key ='1';  - here whatever your sdk_key is for that table.

-> If not there , Add that entry - It goes out sometime.

-> update fug set fug_rowver= '0000000000000000' where sdk_key='1';

-> Also check for

select unique SDL_CURRENT_VERSION,SDL_LABEL, test.sdl.sdk_key
from test.sdk, test.sdl where sdk.sdk_name = 'UD_TEST' and sdk.sdk_key = sdl.sdk_key;     (Here test. - where test is schema name)

->update ud_test set ud_test_version = 3;

select unique ud_test_version from test.ud_test;

This will update all the users to the new version - ud_test_version.





Thanks