My Oracle Support Banner

While Submit Requisition After Editing Error: Check funds failed.Contact Purchasing Administrator if necessary (Doc ID 2427574.1)

Last updated on AUGUST 31, 2023

Applies to:

Oracle Purchasing - Version 12.2.4 to 12.2.8 [Release 12.2]
Oracle iProcurement - Version 12.2.4 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to submit a requisition after edit, the following error occurs.


Error

Check funds failed. Contact Purchasing Administrator if necessary.

Steps to reproduce

1. Go to IProcurement responsibility > Requisitions > Search for an Incomplete Requisition and click on 'Copy to Cart' button
2. Edit and Submit Requisition > page opens with Check Funds option
3. Got below message while click on Check Funds button
Check Funds completed successfully
4. Got below error while click on Submit button
Error: You do not have the authority to submit this requisition. Click on Manage Approvals button to add an approver
5. Click on Manage Approvals button and add approver.
6. Got below message while click on Submit button
Requisition YYYY has been submitted to ____________ for approval.
7. Login to application as approver
8. Click on requisition approval notification link 'Purchase Requisition YYYY....' from worklist
9. Click on Edit Requisition link
10. Got below error while click on Check Funds from 'Edit and Submit Requisition' page
Error: Check Funds failed. Contact Purchasing Administrator if necessary

 

The FND debug log shows some additional error details:


po.plsql.PO_ENCUMBRANCE_PREPROCESSING.GET_FINAL_AMOUNTS.000.EXCEPTION 4 ;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows
po.plsql.PO_DOCUMENT_FUNDS_PVT.DO_ACTION.055.EXCEPTION 4 ;SQLERRM = User-Defined Exception
po.plsql.PO_DOCUMENT_FUNDS_PVT.DO_ACTION.055.EXCEPTION 4 ;SQLERRM = User-Defined Exception
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.CREATE_EXCEPTION_REPORT.BEGIN 2 Start of subprogram.
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.CREATE_EXCEPTION_REPORT.000 1 p_message_text is null
..
..
po.plsql.PO_DOCUMENT_FUNDS_PVT.CHECK_ADJUST.100.EXCEPTION 4 OTHERS Start;SQLERRM = User-Defined Exception
po.plsql.PO_DOCUMENT_FUNDS_PVT.HANDLE_EXCEPTION.BEGIN 2 Start of subprogram.
po.plsql.PO_DOCUMENT_FUNDS_PVT.HANDLE_EXCEPTION.010 1 p_api_name = CHECK_ADJUST
po.plsql.PO_DOCUMENT_FUNDS_PVT.HANDLE_EXCEPTION.010 1 p_progress = 100
po.plsql.PO_DOCUMENT_FUNDS_PVT.HANDLE_EXCEPTION.100 1 x_return_status = U
po.plsql.PO_DOCUMENT_FUNDS_PVT.HANDLE_EXCEPTION.100 1 x_po_return_code = FATAL
po.plsql.PO_DOCUMENT_FUNDS_PVT.CHECK_ADJUST.100.EXCEPTION 4 ;SQLERRM = User-Defined Exception
po.plsql.PO_DOCUMENT_FUNDS_PVT.HANDLE_EXCEPTION.900 1 x_return_status = U
po.plsql.PO_DOCUMENT_FUNDS_PVT.HANDLE_EXCEPTION.900 1 x_po_return_code = FATAL
po.plsql.PO_DOCUMENT_FUNDS_PVT.HANDLE_EXCEPTION.END 2 End of subprogram.
po.plsql.PO_DOCUMENT_FUNDS_PVT.CHECK_ADJUST.100.EXCEPTION 4 handle_exception done;SQLERRM = User-Defined Exception
po.plsql.PO_DOCUMENT_FUNDS_PVT.CHECK_ADJUST.100 1 l_packet_id is null
po.plsql.PO_DOCUMENT_FUNDS_PVT.CHECK_ADJUST.100 1 x_return_status = U
po.plsql.PO_DOCUMENT_FUNDS_PVT.CHECK_ADJUST.100 1 x_po_return_code = FATAL
po.plsql.PO_DOCUMENT_FUNDS_PVT.CHECK_ADJUST.100 1 x_online_report_id = 3059850
po.plsql.PO_DOCUMENT_FUNDS_PVT.CHECK_ADJUST.100.EXCEPTION 4 OTHERS End;SQLERRM = User-Defined Exception
po.plsql.PO_DOCUMENT_FUNDS_GRP.CHECK_ADJUST.100.EXCEPTION 4 OTHERS Start;SQLERRM = User-Defined Exception
po.plsql.PO_DOCUMENT_FUNDS_GRP.CHECK_ADJUST.100 1 l_report_return_status is null
po.plsql.PO_DOCUMENT_FUNDS_GRP.CHECK_ADJUST.100 1 l_online_report_id = 3059850
po.plsql.PO_DOCUMENT_FUNDS_GRP.CHECK_ADJUST.100 1 x_return_status = U
po.plsql.PO_DOCUMENT_FUNDS_GRP.CHECK_ADJUST.100 1 x_po_return_code = FATAL
po.plsql.PO_DOCUMENT_FUNDS_GRP.CHECK_ADJUST.100.EXCEPTION 4 OTHERS End;SQLERRM = User-Defined Exception
icx.por.schema.server.EncumbranceHelper 1 #Param# returnStatus=U
icx.por.schema.server.EncumbranceHelper 1 #Param# poReturnCode=FATAL
icx.por.schema.server.EncumbranceHelper 1 #Param# infoStruct=null
icx.por.schema.server.EncumbranceHelper 4 doEncumbranceActionInternal(): PL/SQL returned an ERROR.
icx.por.schema.server.EncumbranceHelper 5 OAException:ICX_POR_CHECK_FUNDS_FAILED errorCode=4
icx.por.schema.server.EncumbranceHelper 1 Returning from doEncumbranceActionInternal()
icx.por.schema.server.EncumbranceHelper 1 #Param# result=Fatal
icx.por.req.server.RequisitionSvrCmd 2 submitReq: EncumbranceHelper.checkFundsForSubmit failed
icx.por.req.server.RequisitionSvrCmd 2 submitReq.end

  

 

 

Changes

 

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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