My Oracle Support Banner

Cancelling An Order Line Errors With A Mandatory Constraint To Generate Unique Record In ZX_Lines_Det_Factors Is Violated With Error (Doc ID 2003560.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Order Management - Version 12.1.3 to 12.2.6 [Release 12.1 to 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




To view full details, 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 a vibrant support community of peers and Oracle experts.