My Oracle Support Banner

Changing Price On Copied RMA Errors With Mandatory Constraint Error ORA-00001 to Generate Unique Record in ZX_LINES_DET_FACTORS (Doc ID 2102406.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to change price on an RMA copied from a sales order 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 AP List of the invoice and log a Service Request


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Order Management Super User
2. Navigate Orders Workbench, Order Organizer: Sales orders , Returns >
3. Open the Sales order > Query the RMA copied from Sales order >
4. Try to change the price >
5. Receive error.

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!


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