Copy Requisition Line Gets JBO-26048: Constraint PO_REQUISITION_LINES_U2 Violated During Post Operation of Update
(Doc ID 2413036.1)
Last updated on JANUARY 13, 2023
Applies to:Oracle iProcurement - Version 12.1 to 12.2.9 [Release 12.1 to 12.2]
Information in this document applies to any platform.
On : 12.1.3 or 12.2 version, Requisition Creation
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"
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