Discount Import Failed in PDC
(Doc ID 2765460.1)
Last updated on APRIL 10, 2024
Applies to:
Oracle Communications Pricing Design Center - Version 12.0.0.3.0 and laterInformation 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 |