My Oracle Support Banner

PDC Transformers Throwing Error ORA-01000 Maximum Open Cursors Exceeded (Doc ID 2330431.1)

Last updated on MARCH 21, 2019

Applies to:

Oracle Communications Pricing Design Center - Version 11.1.0.8.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.0.8.0 version, Transformation for PDC

After creating PDC objects(ChargeOffers, DiscounutOffers, Bundles and packages), PDC is not pushing these objects to BRM automatically due to transformer error.

Steps to reproduce:

1.Create 1 plan, 1 deal and 1 charge_offer in single changeset and submitted to BRM. Status was pending since RRE_transformer was not up. (newPkg01)

2.Start RRE_transformer. The plan, deal and charge_offer was created with no issues and transformer was running in background.

3.Create two more charge offers and submitted to BRM. (testCharge01)

4.Transformer not picked this charge offer automatically without restart.

It looks like after publishing/creating of offers, the transformers start giving the following error.

Error in RRE_Transformer log is:

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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