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 OCTOBER 11, 2019

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

On : 12.2.7 version, Requisition Creation

When attempting to submit requisition after edit, the following error occurs.
ERROR
Check funds failed. Contact Purchasing Administrator if necessary.

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

1. Navigate to iProcurement,  -> iProcurement Home page -> Shop -> Non-Catalog Request

2. Select Item Type 'Goods or Services ..'

3. Enter Item Description

4. Got below error while selecting Category from LOV

Error

You are trying to access a page that is no longer active.

- The referring page may have come from a previous session. Please select Home to proceed.

5. Navigate back to Requisition tab

6. Search for an Incomplete Requisition # and click on 'Copy to Cart' button

7. Edit and Submit Requisition  page opens with Check Funds option

8. Got below message while click on Check Funds button

Check Funds completed successfully

9. 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.

10. Click on Manage Approvals button and add approver.

11. Got below message while click on Submit button

Requisition NNN has been submitted to ____________ for approval.

12. Login to application as approver

13. Click on requisition approval notification link 'Purchase Requisition NNN....' from worklist

14. Click on Edit Requisition link

15. Got below error while click on Check Funds from 'Edit and Submit Requisition' page

Error

Check Funds failed. Contact Purchasing Administrator if necessary.

16.When click on Approve button from notification, requisition approved successfully, and Approval History for Requisition  shows, 

                   Sequence Approver Action

                   3 <Approver>    Approved

                   2  <Submitter>  Reserved

                   1  <Submitter>  Submitted

17.However, Requisition  status shows, Incomplete.

 

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

  

 

 

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
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.