PDC Help Needed On Corrupted Package Data In The PDC DB (Doc ID 2895978.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Symptoms

There is an existing package 11111111 in Pricing Design Center Data Base (PDC DB) which was created and published long ago, now there is a requirement of change in the price, so price is updated and tried to publish the same package which is failing.

While analyzing, found that not able to open this package in Pricing Design Center User Interface (PDC UI) or through ImportExport utility.
 
Customer had tried all the below options, but could not succeed.
./ImportExportPricing -export 11111111 -pricing PACKAGE_OBJ -n 111111119 -inclFailedObjs
./ImportExportPricing -export 11111111 -pricing PACKAGE_OBJ -n 11111111 -inclFailedObjs -expRefs
./ImportExportPricing -export 11111111 -pricing PACKAGE_OBJ -n 11111111 -expObsolete
./ImportExportPricing -export 11111111 -pricing PACKAGE_OBJ -n 11111111 -expObsolete -expRefs

Cannot export pricing objects.No matching pricing objects found.

EXPECTED BEHAVIOR
Looking for script to correct this corrupted package.

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.