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 JANUARY 04, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.
PO_PDOI_POSTPROC_PVT.plb

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

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 hundreds of Community platforms