R12 INVTOMAI Duplicate Line Number While Entering Move Order Lines Gives ORA-00001 Error (Doc ID 1358855.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version: 12.0.0 to 12.1.3 - Release: 12.0 to 12.1
Information in this document applies to any platform.
forms/US INVTOMAI.fmb

Symptoms

In Oracle Inventory, creating move order line manually is not incrementing line number properly which results in following error:
ORA-00001: Unique constratint (INV.MTL_TXN_REQUEST_LINES_U2) VIOLATED IN Package INV_Trolin_Util Procedure Insert_Row

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms