Unique Constraint Violation During Update Sales Order Lines (Doc ID 1927109.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Get Unique Constraint Violation during update Sales Order Lines.

Error: A mandatory constraint to generate unique record in ZX_LINES_DET_FACTORS is violated with error code ORA-00001.
Please generate FND Debug Log and APList of the invoice and log a Service Request.

When trying to cancel the sales order Line:
Error: A mandatory constraint to generate unique record in ZX_LINES_DET_FACTORS is violated with error code ORA-00001.
Please generate FND Debug Log and APList of the invoice and log a Service Request.

The error occurs only for orders which are upgraded from 11.5.10.2 to 12.1.3


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