My Oracle Support Banner

Discount Import Failed in PDC (Doc ID 2765460.1)

Last updated on APRIL 01, 2021

Applies to:

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

Symptoms

On : 12.0.0.3.0 version, Import Export Utility

While importing discount offer in Pricing Design Center (PDC), getting below issue.

ERROR
-----------------------
EJB Exception: : javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PDC_SCHEMA.SYS_C0045519) violated

Error Code: 1
Call: INSERT INTO ExternalId (ENTITYID, CREATEDDATE, CREATEDUSER, ENTITYCLASS, ENTITYVERSION, LASTMODIFIEDDATE, LASTMODIFIEDUSER, OBSOLETEDENTITYID, PRICINGOBJECTEID, PRICINGOBJECTIID, PRICINGOBJECTTYPE, UPPEREID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [12 parameters bound]
Query: InsertObjectQuery([ ExternalIdDAO oid=oracle.communications.platform.entity.impl.ExternalIdDAO-244965 !PTDND!=TTFTF entityVersion=1 pricingObjectIId=7001ade6-a9f9-49ef-8a69-29202020fef0 pricingObjectEId=MT-FG_XXX_Surf_Abroad_Discount-2110 upperEId=MT-FG_XXX_SURF_ABROAD_DISCOUNT-2110 pricingObjectType=ALTERATION_OFFERING obsoletedEntityID=-1 createdDate=Mon Mar 29 19:26:19 UTC 2021 createdUser=null ])


STEPS
-----------------------
Command used: ./ImportExportPricing -import -pricing SurfAbroad_FG_XXX_pricing.xml -ow

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
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.