PDC Upgrade From 11.1.0.8.0 To 11.1.0.10.0 Is Failing With ORA-01403: No Data Found

(Doc ID 2355977.1)

Last updated on FEBRUARY 14, 2018

Applies to:

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

Symptoms

On : 11.1.0.10 version, Pricing Design Center

While performing PDC upgrade from 11.1.0.8.0 (patch set 8) to 11.1.0.10.0 (patch set 10), below error is produced :

Snippet from "installActions2017-11-28_09-48-29PM.log" :


See below, additional data collected to analyze the issue :

SQL> SELECT ENTITYID FROM PDC.APRICINGPROFILE WHERE NAME = 'ECE_RATING';

 ENTITYID
----------
  139

SQL> SELECT ENTITYID FROM PDC.PRICINGTYPE WHERE APRICINGPROFILE = 139 AND PRICINGTYPEVALUE = 'USAGE_CHARGE';

 ENTITYID
----------
  107

SQL> select distinct pricingtype from pdc.PRICINGCAPABILITY WHERE NAME = 'PriceSelector' ;

PRICINGTYPE
-----------
  238
  411


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