Upgrading To Release 12.2.11 Fails With Error 'ORA-00001: unique constraint (INV.MTL~TRANSACTION~TYPES~B~U1) violated' In Adworker Log File Due To Presence Of Duplicate Transaction Type Identifiers
(Doc ID 2966350.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Inventory Management - Version 12.2.11 and laterInformation in this document applies to any platform.
Symptoms
While upgrading to 12.2.11, the below error is seen in the adworker log file
Error Message
insert into MTL_TRANSACTION_TYPES_B
*
ERROR at line 1:
ORA-00001: unique constraint (INV.MTL~TRANSACTION~TYPES~B~U1) violated
Steps
1. Apply the 12.211 RUP patches
2. Observe the above error in the adworker log file
Changes
Upgrade to 12.2.11
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 |