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

Last updated on MARCH 02, 2023

Applies to:

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 (XX) = <po_line_loc_id>
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

Changes

Cause

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