My Oracle Support Banner

Error: Unexpected Error Occurred During Autocreate. (Doc ID 2416748.1)

Last updated on JUNE 28, 2018

Applies to:

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

Symptoms



PO cannot be created through auto create window. user getting the following error-


Error:
-------
Error: Unexpected error occurred during autocreate.


Steps to Reproduce the Issue
-----------------------------------

1. Login to a PO Responsibility with Setup Access (PO Superuser ,etc)
2. navigate to autocreate form
3. select the given requisitions - and choose to create a standard po
4. Click create- error occurs



FND LOG MESSAGES show the following


po.plsql.PO_PDOI_POSTPROC_PVT.copy_req_attachments.40 The po line loc ids table (11) = 3199606
po.plsql.PO_PDOI_POSTPROC_PVT..copy_req_attachments.40.EXCEPTION
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_POSTPROC_PVT.
Procedure copy_req_attachments.40;SQLERRM = ORA-01427: single-row subquery returns more than one row

po.plsql.PO_PDOI_POSTPROC_PVT..create_update_doc.80.EXCEPTION
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure create_update_doc.80
;SQLERRM = ORA-01427: single-row subquery returns more than one row

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!


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