My Oracle Support Banner

One Time Address Is Blanked out in Update Line Page (Doc ID 2326227.1)

Last updated on JANUARY 16, 2020

Applies to:

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


On iProcurement 12.2.6 when attempting to enter a one-time address, the following error occurs:

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;".
at oracle.apps.fnd.framework.OAException.wrapperException(

The issue can be reproduced at will with the following steps:

1. Go to iProcurement > add an item to cart > View Cart and Checkout > Edit
2. On the 'Edit and Submit Requisition' page, click Edit one-time address
3. Enter an alias and deliver-to address > Apply
4. Click Update Line and see that the one time details are gone
5. Re-enter details on this page and click apply
6. Error occurs

Due to this issue, users cannot enter a new one-time address


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

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