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 APRIL 20, 2023

Applies to:

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

Changes

Cause

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