One Time Address Is Blanked out in Update Line Page

(Doc ID 2326227.1)

Last updated on NOVEMBER 08, 2017

Applies to:

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

Symptoms

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(OAException.java:912)
...


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

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