Running pin_setup Throws Error While Loading BRM Stored Procedures (Doc ID 733615.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 20-May-2010***
***Checked for relevance on 12-July-2013***
***Checked for relevance on 24-Septemeber-2015***


Goal

While executing pin_setup for the first time, the script is aborted with the error "Portal Stored Procedures loading failed.".

In pin_setup log file the error starts with:

39/5 PL/SQL: Statement ignored
39/5 PLS-00201: identifier 'DBMS_LOCK' must be declared
Warning: Procedure created with compilation errors.



Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms