A Mandatory Constraint to Generate Unique Record in zx_lines_det_factors is Violated with Error (Doc ID 2003560.1)

Last updated on APRIL 23, 2017

Applies to:

Oracle Order Management - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Oracle Order Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.


When attempting to cancel order line the following error occurs.


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
Error: An unexpected error has occurred. Please contact your system administrator.


1. Order Management responsibility (OM)
2. Navigation: Orders,Returns -> Order Organizer
3. Query order
4. Actions -> Cancel


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