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.
On : 12.2.9 version,
When doing AutoCreate from Requisitions users are encountering "Unexpected error occurred during autocreate." message.
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
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
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