My Oracle Support Banner

During Requisition Approval - unique constraint (ZX.ZX_LINES_DET_FACTORS_U2) violated (Doc ID 2831519.1)

Last updated on JANUARY 10, 2022

Applies to:

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


On : 12.1.3 version, Approval List and Workflow

When an Approver open approval notification and clicks on "Edit the Requisition", perform few changes and submit, the following error occurs.

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20000: Exception at POR_UTL_PKG.restore_working_copy(p_origHeaderId:13485179,p_tempHeaderId:13485179) 170 SQLERRM:ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U2) violated ORA-06512: at "APPS.POR_UTIL_PKG", line 1453 ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Preparer creates the requisition with multiple lines and submits for approval.
2. Approver opens the notification, choose edit requisition, change the charge account for first line, and check the box to apply the changes to all the lines.
3. Submit the requisition change and see the errors.


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

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