My Oracle Support Banner

Unexpected error occurred during autocreate "ORA-01403: no data found in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure import_uda_attrs" (Doc ID 2803173.1)

Last updated on SEPTEMBER 29, 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 FND debug 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 Buyer Work Center
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

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