PDC Transformers Throwing Error RA-01000 Maximum Open Cursors Exceeded

(Doc ID 2330431.1)

Last updated on FEBRUARY 01, 2018

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.

REPRODUCIBLE STEPS:

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

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