Can Not Cancel Sale Order Line ZX_LINES_DET_FACTORS Is Violated With Error Code ORA-00001

(Doc ID 1933442.1)

Last updated on APRIL 07, 2018

Applies to:

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


When attempting to cancel a sales 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


1. Log in to Order Management Super User
2. query the sales order
3. select the line
4. Action -> cancel
5. enter the reason
6. error message


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