My Oracle Support Banner

JBO-26048 Error Occurs When Adding Item To Shopping Cart in iProcurement (Doc ID 2222069.1)

Last updated on MARCH 20, 2018

Applies to:

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

Symptoms

Problem Statement
  When trying to add an item from the catalog to the shopping cart, the following error occurs.

Error
  oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "PO_REQUISITION_HEADERS_U2" violated during post operation:"Insert" using SQL Statement "INSERT INTO PO_REQUISITION_HEADERS_ALL(ORG_ID,AUTHORIZATION_STATUS,TYPE_LOOKUP_CODE,ATTRIBUTE_CATEGORY,REQUISITION_HEADER_ID,PREPARER_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,SEGMENT1,SUMMARY_FLAG,ENABLED_FLAG,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,PCARD_ID,APPS_SOURCE_CODE,ATTRIBUTE1,CONTRACTOR_REQUISITION_FLAG,ACTIVE_SHOPPING_CART_FLAG,CONTRACTOR_STATUS,SUPPLIER_NOTIFIED_FLAG) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21)".

Steps to Reproduce

  1. Find an item from Stores.
  2. Click "Add to Cart" to add it to the shopping cart.
  3. Click "View Cart and Checkout", when click "Checkout" button, the above error occurs.

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!


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