CREATEPO Approved Requisitions Created Via Punchout Are Not Always Being Autocreated (Doc ID 2125495.1)

Last updated on APRIL 27, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, PO Create Documents Workflow (CREATEPO)

In processing over 9K requisition lines, most of them are being picked up and processed by
CREATEPO workflow, but a small number stayed in the requisition pool after approval.
Buyer can then go to buyer workbench and convert to purchase orders.
No error message is available. All of these requisitions have valid CPA and ASL so all requirements are met for CREATEPO workflow.

 

ERROR
-----------------------

po_wf_debug only shows :
create_doc: Came back from the backend with doc_id = / num_lines_processed =
create_doc: result = CREATE_FAILED

fnd_log_message shows no row for CREATE_FAILED, only CREATE_OK

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. All requisitions are approved via email and the approval is sucessful
2. After a requisition approval, the CREATEPO workflow runs and most time completes and the purchase orders are generated.
3. For some, it appears that CREATEPO runs and completes without any error but the purchase orders are not created.


FND logging -


Sync Attachments from GA to PO Line
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
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
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 process.80;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows
Start of subprogram.
End of subprogram.
ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_PVT. Procedure start_process.120;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows

 

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