My Oracle Support Banner

ORA-01403: no data found in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure import_uda_attrs (Doc ID 2803173.1)

Last updated on AUGUST 30, 2021

Applies to:

Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version,

When doing AutoCreate from Requisitions users are encountering "Unexpected error occurred during autocreate." message.


ERROR:
Unexpected error occurred during autocreate.

When reviewing log file we see following error messages
ORA-01403: no data found in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure import_uda_attrs.0;SQLERRM = ORA-01403: no data found

STEPS:
The issue can be reproduced at will with the following steps:
1. Login to BWC
2. Click on Requisitions
3. Add Filer Requisition and enter req
4. Click Go
5. Click Sort Ascending on Requisition number field.
6. Change dropdown from New Order to Add to Order
7. Click Add
8. Uncheck Group Shipments
9. Click Create
10. Receive Error

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.