R12: Getting Unexpected Error Occurred During Autocreate Purchase Order From Multiple Requisition Lines That Has Same Item, Organization, Ship to And Bill to Location (Doc ID 1986620.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

When attempting to Autocreate PO from multiple requisition lines with same Item, Organization, Ship to and Bill to Location, the following error occurs.

ERROR

Error: Unexpected Error occurred during Autocreate.


Steps to reproduce:

1. Responsibility: PO Super User

2. Navigate to: Purchase Orders > Autocreate

3. When selecting multiple requisition lines with same Item, Organization, Ship to and Bill to Location as same

4. Getting the above mentioned error.

As such there is no issue to Autocreate otherwise.
For example, when selected 4 lines from another requisition with different items it is allowing to Autocreate.

Same issue also occur in Buyers Work Center as well.

FND Logging is showing -
ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure process.80;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows
rollback to savepoint po_pdoi_doc_postproc_sp
ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure create_update_doc.81;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows
ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure sync_ga_attachments.10;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows
Sync Attachments from GA to PO Line

Cause

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