OID: User's Provisioning status stuck in Pending state.

Recently we hit an error when trying to provision a user for Real Time Collaboration within Oracle Collaboration Suite. When the user logged in they were met with the following error:

<username> is not provisioned to this application.

Via the Oracle Internet Directory (OID) Provisioning Console I could see that this user was stucking in pending status. Working with Oracle Support we determined that this user was deleted and recreated for some reason and there was orphan data.

By querying the RTC.RTC_USERS table within the OID database the PROVISION_STATUS column for this user had a value of DELETED. The solution to this problem was to:
  • delete the user via the OID Provisining Console
  • remove the ophan data
  • recreate the user
  • Re-provision the user for the applications they required.

Some queries:

select * from rtc.rtc_users where upper(user_name) = 'JOHNDOE';

Oracle support mentioned there may be more than one row of orphan data. So this query is just to determine how many bad rows there are.

Backup the table just in case you make a mistake or something goes horribly wrong.

create table rtc.rtc_users.BAK20090420 as select * from rtc.rtc_users;

Delete the bad data:

delete * from rtc.rtc_users where upper(user_name) = 'JOHNDOE';

Verify row count is the same as your first query above and commit. You can now recreate the user and provisioning should go through.

1 comment:

Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.