My Oracle Support Banner

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 JANUARY 31, 2019

Applies to:

Oracle Order Management - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Oracle Shipping Execution - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
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, the following error occurs:

ERROR
-----------------------

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


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