My Oracle Support Banner

PO Summary > Tools > Communicate > Email Results In Error ORA-01403: no data found ORA-06512: at "APPS.PO_COMMUNICATION_PVT" (Doc ID 1263281.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Purchasing - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.
***Checked for relevance on 13-Aug-2012***

Symptoms

On 12.0.6 version for one supplier when trying to manually email a Purchase Order (PO) to the supplier via PO Summary an error occurs.   This is only happening for certain supplier / supplier sites.

ERROR
-----------------------
ORA-01403: no data found
ORA-06512: at "APPS.PO_COMMUNICATION_PVT", line 2795
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01403.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to PO Summary > (Query a PO for supplier that is having this issue)
2. Go to Tools > Communicate
3. Enter email address in the form
4. Click OK button from the form to send the Purchase Order

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
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.