Failed To Reserve Funds For Purchase Requisition At "RESERVE_AT_START_OF_WF" Workflow, But Can Reserve For the Same Later (Doc ID 1617692.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle iProcurement - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

iProcurement requisition intermittently fails to reserve funds, and then sends an FYI notification advising the same. The same can be processed without error later, so it is confusing why it sometimes fails and sometimes does not fail.

ERROR

Here is an example of a notification sent to the user

Subject: FYI: Failed to reserve funds for Purchase Requisition 13000006
...

Failed to reserve funds for Purchase Requisition 13000006.

Reason(s) for Reserve failure:
The requested action is not allowed for current document status

Please note that your Requisition would not be Approved unless funds have been reserved for it.

You can take one of the following actions:
1) Withdraw the requisition from the approval process and resubmit it after modifications.
2) Try to have Budgetary Controls updated so that Reservation succeeds in the next attempt.
3) Have your requisition forwarded to a person who has authority to override Reservations failure.

----------------

DEBUG LOG shows these errors

ZX.PLSQL.ZX_SRVC_TYP_PKG.INSUPD_LINE_DET_FACTORS Processing for Transaction Line with APPLICATION_ID: 201, ENTITY_CODE: REQUISITION, EVENT_CLASS_CODE: REQUISITION, EVENT_TYPE_CODE: REQ_DISTRIBUTED, TRX_ID: 5320991, TRX_LINE_ID: 5168685, TRX_LEVEL_TYPE: LINE, INTERNAL_ORGANIZATION_ID: 84, LINE_LEVEL_ACTION: UPDATE, TRX_DATE: 19-JUL-2013, TRX_DOC_REVISION: , LEDGER_ID: 2021, TRX_CURRENCY_CODE: , CURRENCY_CONVERSION_DATE: , CURRENCY_CONVERSION_RATE: , CURRENCY_CONVERSION_TYPE: , MINIMUM_ACCOUNTABLE_UNIT: , PRECISION: , TRX_SHIPPING_DATE: , TRX_RECEIPT_DATE: , LEGAL_ENTITY_ID: 23275, ROUNDING_SHIP_TO_PARTY_ID: , ROUNDING_SHIP_FROM_PARTY_ID: , ROUNDING_BILL_TO_PARTY_ID: 84, ROUNDING_BILL_FROM_PARTY_ID: , RNDG_SHIP_TO_PARTY_SITE_ID: , RNDG_SHIP_FROM_PARTY_SITE_ID: , RNDG_BILL_TO_PARTY_SITE_ID: , RNDG_BILL_FROM_PARTY_SITE_ID: , ESTABLISHMENT_ID: , TRX_LINE_TYPE: ITEM, TRX_LINE_DATE: 19-JUL-2013, TRX_BUSINESS_CATEGORY: , LINE_INTENDED_USE: , USER_DEFINED_FISC_CLASS: , LINE_AMT: 26285, TRX_LINE_QUANTITY: 1, UNIT_PRICE: 26285, EXEMPT_CERTIFICATE_NUMBER: , EXEMPT_REASON: , CASH_DISCOUNT: , VOLUME_DISCOUNT: , TRADING_DISCOUNT: , TRANSFER_CHARGE: , TRANSPORTATION_CHARGE: , INSURANCE_CHARGE: , OTHER_CHARGE: , ASSESSABLE_VALUE: 26285, PRODUCT_ID: , PRODUCT_FISC_CLASSIFICATION: , PRODUCT_ORG_ID: 117, UOM_CODE: EA, PRODUCT_TYPE: , PRODUCT_CODE: , PRODUCT_CATEGORY: , TRX_SIC_CODE: , LINE_CLASS: INVOICE, FOB_POINT: , SHIP_TO_PARTY_ID: 117, SHIP_FROM_PARTY_ID: , POA_PARTY_ID: , POO_PARTY_ID: , BILL_TO_PARTY_ID: 84, BILL_FROM_PARTY_ID: , MERCHANT_PARTY_ID:
ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS.BEGIN ZX_SRVC_TYP_PKG:DB_INSERT_LINE_DET_FACTORS()+
ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS "ORA-00600: internal error code, arguments: [qerltcInsertSelectRop_error], [1], [], [], [], [], [], [], [], [], [], []
ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated"
ZX.PLSQL.ZX_SRVC_TYP_PKG.INSUPD_LINE_DET_FACTORS RETURN_STATUS = U
ZX.PLSQL.ZX_API_PUB.INSERT_LINE_DET_FACTORS ZX_API_PUB: INSERT_LINE_DET_FACTORS:ZX_SRVC_TYP_PKG.insupd_line_det_factors returned errors
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()+
ZX.PLSQL.ZX_API_PUB.DUMP_MSG 0 Error Message(s) dumped into Zx_Errors_GT.
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()-
po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_REQUISITION.350 insert_line_det_factors returned with status U


po.plsql.PO_TAX_INTERFACE_PVT.APPEND_ERROR.BEGIN p_message_text = An unexpected error has occurred. Please contact your system administrator.
po.plsql.PO_TAX_INTERFACE_PVT.APPEND_ERROR.20 l_length= 1
po.plsql.PO_TAX_INTERFACE_PVT.APPEND_ERROR.END End of subprogram.
po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_REQUISITION.350.EXCEPTION An unexpected error has occurred. Please contact your system administrator.;SQLERRM = User-Defined Exception
po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_REQUISITION.END x_return_status = U
po.plsql.PO_DOCUMENT_CHECKS_PVT..CHECK_REQUISITIONS.013 REQ 11: Calculate tax raised unexpected error
po.plsql.PO_DOCUMENT_CHECKS_GRP..PO_SUBMISSION_CHECK.008 Back in GRP package. Returning to the caller
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 Submission check results (i = 1)
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 l_sub_check_action = DOC_SUBMISSION_CHECK
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 l_doc_type = REQUISITION
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 l_doc_subtype = PURCHASE
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 l_doc_level = HEADER
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 l_doc_level_id_tbl(i) = 5320991
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Number of records in ZX_TRANSACTION_LINES_GT :1
po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_REQUISITION.170 calculate_tax returned with status S

ZX.PLSQL.ZX_VALID_INIT_PARAMS_PKG.INSUPD_LINE_DET_FACTORS.END ZX_VALID_INIT_PARAMS_PKG: INSUPD_LINE_DET_FACTORS()-
ZX.PLSQL.ZX_SRVC_TYP_PKG.INSUPD_LINE_DET_FACTORS.BEGIN ZX_SRVC_TYP_PKG: INSUPD_LINE_DET_FACTORS()+
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Total Time :0:0:1
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.INSERT_REPORT_AUTONOMOUS.050 l_single_message_flag = TRUE
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.INSERT_REPORT_AUTONOMOUS.900 x_online_report_id = 9684638
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.INSERT_REPORT_AUTONOMOUS.END End of subprogram.
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.CREATE_EXCEPTION_REPORT.010 x_online_report_id = 9684638
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.CREATE_EXCEPTION_REPORT.END End of subprogram.
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.560 l_exc_code = 3
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.560 l_exc_message_name = PO_ALL_INVALID_DOC_STATE
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.560 x_validation_successful_flag = N
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.560 x_sub_check_report_id = 9684638
po.plsql.PO_DOCUMENT_FUNDS_PVT.DO_ACTION.035.EXCEPTION ;SQLERRM = User-Defined Exception
po.plsql.PO_DOCUMENT_FUNDS_PVT.DO_RESERVE.900 l_packet_id is null
po.plsql.PO_DOCUMENT_FUNDS_PVT.DO_RESERVE.900 x_return_status = E
po.plsql.PO_DOCUMENT_FUNDS_PVT.DO_RESERVE.900 x_po_return_code = FAILURE
po.plsql.PO_DOCUMENT_FUNDS_PVT.DO_RESERVE.900 x_online_report_id = 9684638
po.plsql.PO_DOCUMENT_FUNDS_PVT.DO_RESERVE.END End of subprogram.
wf.plsql.wf_engine_util.function_call.actfunc_callout End executing PLSQL procedure - PO_REQAPPROVAL_ACTION.RESERVE_DOC [End time -16647302] [Time taken - 1.96 secs]
wf.plsql.wf_engine_util.function_call.actfunc_callout Start executing PLSQL procedure - PO_WF_REQ_NOTIFICATION.GET_REQ_PREPARER_MSG_ATTRIBUTE [Start time -16647301]

po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 l_return_status = U
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 l_sub_check_status = E
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 "l_msg_data = Unexpected error occurred during Tax Calculation.
Exception: 013 - An unexpected error has occurred. Please contact your system administrator.
Please correct the problem or contact your System Administrator."
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.550 x_sub_check_report_id is null
po.plsql.PO_ENCUMBRANCE_PREPROCESSING.DO_ENCUMBRANCE_VALIDATIONS.560.EXCEPTION ;SQLERRM = User-Defined Exception
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.CREATE_EXCEPTION_REPORT.BEGIN Start of subprogram.
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.CREATE_EXCEPTION_REPORT.000 p_message_text = The requested action is not allowed for current document status
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.CREATE_EXCEPTION_REPORT.000 p_user_id is null
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.INSERT_REPORT_AUTONOMOUS.BEGIN Start of subprogram.
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.INSERT_REPORT_AUTONOMOUS.000 p_reporting_level = TRANSACTION
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.INSERT_REPORT_AUTONOMOUS.000 p_message_text = The requested action is not allowed for current document status


------------------------------

STEPS TO REPRODUCE

1. Create a requisition in iProcurement
2. Submit for approval
3. Approve and get the errors (sometimes)


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