My Oracle Support Banner

iSupplier Portal View Orders ends in ORA-01403: NO DATA FOUND Cannot View Order Details Page in iSupplier Portal (Doc ID 2417285.1)

Last updated on JUNE 29, 2018

Applies to:

Oracle iSupplier Portal - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Home page Issues

ACTUAL BEHAVIOR

After creating a Purchase order with Acceptance Required as “Document”
and once the PO is approved, the notification goes to the iSupplier portal
and the status is “Requires Acknowledgement”.

When the document is opened from isupplier portal the error occurs
 

EXPECTED BEHAVIOR

Unexpected error  

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no
data found
ORA-06512: at line 1

java.sql.SQLException: ORA-01403: no data found
ORA-06512: at line 1

at
oracle.apps.pos.changeorder.server.PosViewHeadersVORowImpl.getShipAddr1(PosVie
wHeadersVORowImpl.java:1696)
at
oracle.apps.pos.changeorder.server.PosViewHeadersVORowImpl.getAttrInvokeAccess
or(PosViewHeadersVORowImpl.java:3103)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)


STEPS TO REPLICATE
 
The issue can be reproduced at will with the following steps:
1. Purchasing > Purchase Orders > Terms and Conditions
2. Set Acceptance Required = Document and approve PO
3. iSupplier Portal > Orders tab > View: All Purchase Orders
4. Opening the PO with status: Acceptance Required (Click the PO number Hyper link) error occurs 

 

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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