My Oracle Support Banner

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

Last updated on SEPTEMBER 22, 2023

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

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
Cause
Solution
References


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