Copy Requisition Line Gets JBO-26048: Constraint PO_REQUISITION_LINES_U2 Violated During Post Operation of Update

(Doc ID 2413036.1)

Last updated on JULY 13, 2018

Applies to:

Oracle iProcurement - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Requisition Creation

ACTUAL BEHAVIOR
---------------
JBO-26048: Constraint "PO_REQUISITION_LINES_U2" violated during post operation:"Update"

Existing Requisition with status = Returned
Requisition has 14 lines.
Line 1 is not on any PO and is Finally closed
Line 2 to 13 are on PO
Line 14 is not on any PO

When copying requisition line 14, system copies to new line but new line number is 1, same has already existing line 1 which is Finally Closed.
When saving requisition, gets:

JBO-26048: Constraint "PO_REQUISITION_LINES_U2" violated during post operation:"Update" using SQL Statement "UPDATE PO_REQUISITION_LINES_ALL PoRequisitionLineEO SET LINE_NUM=:1,LAST_UPDATE_DATE=:2,LAST_UPDATED_BY=:3,LAST_UPDATE_LOGIN=:4,ITEM_DESCRIPTION=:5,QUANTITY=:6,TAX_ATTRIBUTE_UPDATE_CODE=:7 WHERE REQUISITION_LINE_ID=:8"



Changes

 

Cause

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 hundreds of Community platforms