Multiple Internal Id's Got Created For One Trigger (Doc ID 2007100.1)

Last updated on JUNE 27, 2022

Applies to:

Symptoms

On : 11.1.0.6.0 version

1. Single internal id got mapped to different trigger names.

2. Multiple internal id's got created for single trigger.


ACTUAL BEHAVIOR
---------------
InternalID is not unique

EXPECTED BEHAVIOR
-----------------------
InternalID should be unique

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Issue 1:
1. Create discount1 with trigger1 and filter1. Save and submit.
2. Search same discount (discount1)and choose the Save As option. Edit the same and give new name(discount2) and give a new trigger name as "trigger2" for this new discount.
3. New discount got created with different internal id's but trigger2 created with same Internalid. [ issue 1].

Observation:
 A. In discount1, trigger got changed from trigger 1 to trigger2.
 B. If you tried to export trigger1 it will give an error.
 

Issue 2:
4. To correct trigger name from trigger2 to trigger1 [ User want to use the same name like before] for discount 1, export discount1, trigger2 and filter 1 using below command
e.g:
ImportExportPricing -export -pricing -name "discount1","fillter1","trigger2" -l FINER -pdcuser <LOGIN> -appsvruser <LOGIN>

5. Change trigger2 to trigger1 for the discount1 and import
E.g
ImportExportPricing -import -ow -pricing export_pricing2015-04-14_06-40-29.xml  -pdcuser <LOGIN> -appsvruser <LOGIN>

It got submitted successfully and the old trigger has got created with new internal id which is not expected behaviour.
(As two triggers with same names have different internal ID's)

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.