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 22, 2023

Applies to:

Oracle Inventory Management - Version 12.2.11 and later
Information in this document applies to any platform.

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

Upgrade to 12.2.11

	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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.