Brm 7.4 Pricing Discount Model Procedure (Doc ID 1301822.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 19-Jun-2013***

Goal

The INTEGRATE schema and the PIN schema are in different databases.
The aim is to load the discount procedure from "create_pricing_discountmodel_procedures.plb" .

In order to do so:

- Created a DB link from the PIN database to the INTEGRATE database
- Created the corresponding synonyms on PIN schema to access the IFW tables over the DB link.
- Executed the "create_pricing_discountmodel_procedures.plb"

and then the following error comes:
PLS-00739: FORALL INSERT/UPDATE/DELETE not supported on remote tables


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