After Clicking Continue Button When Shopping: ORA-00001: Unique Constraint(PO.PO_REQUISITION_LINES_U2) Violated ORA-06512 (Doc ID 2189238.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Symptoms

On : 12.2.4 version,

When attempting to click View Car and Checkout,
the following error occurs.

ERROR
-----------------------
Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException:
JBO-26048: Constraint "PO_REQUISITION_LINES_U2" violated during post
operation:"Insert" using SQL Statement "BEGIN INSERT INTO
PO_REQUISITION_LINES_ALL(REQUISITION_LINE_ID,REQUISITION_HEADER_ID,LINE_NUM,LAST_UPDATE_DATE, LAST_UPDATED_BY,LAST_UPDATE_LOGIN,
CREATION_DATE,CREATED_BY,DELIVER_TO_LOCATION_ID,TO_PERSON_ID,
ITEM_DESCRIPTION,CATEGORY_ID,UNIT_MEAS_LOOKUP_CODE,UNIT_PRICE,QUANTITY,LINE_TYPE_ID,SOURCE_TYPE_CODE,ITEM_ID,
ITEM_REVISION,QUANTITY_DELIVERED,SUGGESTED_BUYER_ID,ENCUMBERED_FLAG,RFQ_REQUIRED_FLAG,NEED_BY_DATE,LINE_LOCATION_ID,MODIFIED_BY_AGENT_FLAG,
PARENT_REQ_LINE_ID,JUSTIFICATION,NOTE_TO_AGENT,NOTE_TO_RECEIVER,PURCHASING_AGENT_ID,DOCUMENT_TYPE_CODE,BLANKET_PO_HEADER_ID,
BLANKET_PO_LINE_NUM,CURRENCY_CODE,RATE_TYPE,RATE_DATE,RATE,CURRENCY_UNIT_PRICE,SUGGESTED_VENDOR_NAME,SUGGESTED_VENDOR_LOCATION
.
.
.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. login to iProcurement
2. Navigate to Non-Catalog Request
3. Create a requisition
4. Click View Cart and Checkout
5. Receive the error


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