Enter One Time Address In Requisition Shows JBO-2604 Error

(Doc ID 2219403.1)

Last updated on JANUARY 30, 2017

Applies to:

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


On : 12.2.4 version, Requisition Creation

In Oracle iProcurement, when users attempt to enter one time address during requisition creation,
the following error is shown:

oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "POR_ITEM_ATTRIBUTE_VALUES_U1" violated during post operation:"Insert" using SQL Statement "BEGIN INSERT INTO POR_ITEM_ATTRIBUTE_VALUES(ITEM_TYPE,REQUISITION_HEADER_ID,REQUISITION_LINE_ID,ORG_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9) RETURNING ROWID INTO :10; END;".

The issue can be reproduced at will with the following steps:
1. Search item in iProcurement.
2. Add item to cart.
3. View cart and checkout.
4. Edit the Requisition.
5. Change Destination type to expense.
6. Click on Enter one-time address, select a existing one-time address.
7. Click apply , the one time address is NOT displayed in Requisition.
8. Click on enter on-time address again and the error is shown.


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