My Oracle Support Banner

How To Load "create_pricing_discountmodel_procedures.plb" With Multiple Pin User Installation (Doc ID 1066398.1)

Last updated on AUGUST 20, 2018

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.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.