My Oracle Support Banner

Deleting A Product Offer Is Not Deleting Data From The Reference Tables (Doc ID 2997857.1)

Last updated on JANUARY 22, 2024

Applies to:

Oracle Fusion Digital Experience for Communications - Launch Experience - Version 11.13.23.10.0 and later
Information in this document applies to any platform.

Symptoms

A new revision of a product offer was imported into an environment then deleted using REST API. When trying to import the product offer again an error occurs.

When trying to import the prodduct offer a second time a 'Unique constraint' error occurred.

The deleted POs exist in ATC_PROD_OFFER_REFS table but don't exist in the table ATC_PROD_OFFERS.


ERROR
-----------------------

JBO-26048: Constraint \"atc_prod_offer_refs_U1\" is violated during post operation


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Updated packages in DEV1
2. Export the packages and import into TEST environment
3. Error occurred during import

Changes

 

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