How To Load "create_pricing_discountmodel_procedures.plb" With Multiple Pin User Installation

(Doc ID 1066398.1)

Last updated on APRIL 11, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.5.0.0.0 [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.
***Checked for relevance on 28-Nov-2011***
Checked for relevance on 03-Jun-2016.

Goal

Consider the following scenario:

Installed BRM in separate schemas, the tables for PIN and IFW. So, there are user pin and ifw for PortalBase and Pipeline databases; and, there are one tablespace and other index tablespace for multiple pin users, pin1, pin2, ..., pin7, ...

Grants are as mentioned on the Pipeline Manager installation instructions:

grant select, update, insert, delete on ifw7.ifw_discountmodel to pin7;
grant select, update, insert, delete on ifw7.ifw_dscmdl_ver to pin7;
grant select, update, insert, delete on ifw7.ifw_dscmdl_cnf to pin7;
grant select, update, insert, delete on ifw7.ifw_dsctrigger to pin7;
grant select, update, insert, delete on ifw7.ifw_dsccondition to pin7;
grant select, update, insert, delete on ifw7.ifw_discountrule to pin7;
grant select, update, insert, delete on ifw7.ifw_discountstep to pin7;
grant select, update, insert, delete on ifw7.ifw_dscbalimpact to pin7;
grant select, update, insert, delete on ifw7.ifw_discountmaster to pin7;
grant select, update, insert, delete on ifw7.ifw_discountdetail to pin7;
grant select on ifw7.ifw_seq_discountmodel to pin7;
grant select on ifw7.ifw_seq_discountconfig to pin7;
grant select on ifw7.ifw_seq_discounttrigger to pin7;
grant select on ifw7.ifw_seq_discountcondition to pin7;
grant select on ifw7.ifw_seq_discountrule to pin7;
grant select on ifw7.ifw_seq_discountstep to pin7;
grant select on ifw7.ifw_seq_discountbalimpact to pin7;
grant select on ifw7.ifw_seq_discountmaster to pin7;


When trying to install package "create_pricing_discountmodel_procedures.plb" for BRM 7.4 as pin7 user, there was a compilation error and leaving the package in invalid status:

Loading the plb file as pin7 user:

sqlplus -s pin7/pin7@pindb < create_pricing_discountmodel_procedures.plb


Also, there was the following error message:

 Warning: Package created with compilation errors.

 Warning: Package Body created with compilation errors.

 Errors for PACKAGE BODY PRICING_DISCOUNTMODEL:

 LINE/COL ERROR
 -------- -----------------------------------------------------------------
 0/0      PL/SQL: Compilation unit analysis terminated
 1/14     PLS-00304: cannot compile body of 'PRICING_DISCOUNTMODEL'
         without its specification

 1/14     PLS-00905: object PIN.PRICING_DISCOUNTMODEL is invalid

 Synonym created.


 Grant succeeded.



As verified, the package XMLDOM was installed on the Database.


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