Interface Trip Stop Errors With Error: A Mandatory Constraint to Generate Unique Record in ZX_LINES_DET_FACTORS is Violated With Error Code ORA-00001
(Doc ID 2139908.1)
Last updated on APRIL 19, 2024
Applies to:
Oracle Shipping Execution - Version 12.1.3 and laterOracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
On : 12.2.4 version, Interface Trip Stop
When attempting to run the Interface Trip Stop(ITS), the following error occurs:
ERROR
The error(s) is present in the ITS log file.
ship_confirm_new UNEXPECTED ERROR : User-Defined Exception
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
LEAVING OE_MSG_PUB.COUNT_AND_GET 2
rollback to om_ship_confirm :
After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 05/11/2016 10:00:23 AM
l_return_status ==> U
NO. OF OE MESSAGES :2
Calling program unit OE_MSG_PUB.GET
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 msg: 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
STEPS
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Shipping
3. Release Sales Orders
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 |