Enable USER_LOCK package

For inbound web services to work, the USER_LOCK must be enabled at the database level. This is a one-time step. If this is not already enabled, enable it using the following steps:

1. Login as SYS user.

2. On SQL prompt run.

@<ORACLE_HOME>/rdbms/admin/userlock.sql

3. Grant permission by running following SQL:

grant execute on USER_LOCK to public;

Note that grant can also be made to the database user that the application connects to (for example, cisuser), instead of ‘public’.