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 laterInformation 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 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
STEPS:
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
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 |