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 MAY 09, 2019

Applies to:

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

Symptoms

When attempting to cancel order line, the following error occurs:

ERROR

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 list of the invoice and log a Service Request
Error: An unexpected error has occurred. Please contact your system administrator.


STEPS

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

Please note:

 Same error occurs when trying to do Actions > Price Order.

 

Changes

 
 

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
Changes
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.