R12: Purchase Order Is Failing Funds Check - Procedure PSA_BC_XLA_PUB.Budgetary_Control When Calling PO_ENCUMBRANCE_POSTPROCESSING.execute_gl_call (Doc ID 1504603.1)

Last updated on MAY 27, 2022

Applies to:

Symptoms

When attempting to approve a purchase order with Reserve/Unreserve checkbox, the following error occurs.

ERROR
-----------------------
"Procedure PSA_BC_XLA_PUB.Budgetary_Control returns an error without any details to the calling procedure PO_ENCUMBRANCE_POSTPROCESSING.execute_gl_call."

STEPS
-----------------------

1. Log in using a Purchasing responsibility
2. Navigate to Purchase Order Entry form
3. Create a purchase order and save changes
4. Click on Approve and check the Reserve flag
5. The form displays the error

Same issue occurs when trying to unreserve the PO.

FND log shows additional error messages:

po.plsql.PO_DOCUMENT_FUNDS_PVT.IS_REQ_ENC_FLIPPED.0.EXCEPTION 14,824,481.00 10
0ORA-01403: no data found;SQLERRM = ORA-01403: no data found
...
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log 14,825,969.00 -:
XLA-95103: An internal error occurred.  Please inform your system administrator or support representative that:
...
An internal error has occurred in the program xla_je_validation_pkg.budgetary_control.  
PSA_FUNDS_CHECK_PKG.budgetary_control failed. Aug/09/2012

...
po.plsql.PO_DOCUMENT_FUNDS_PVT.HANDLE_EXCEPTION.100 14,826,026.00 x_po_return_code = FATAL
po.plsql.PO_DOCUMENT_FUNDS_PVT.CHECK_RESERVE.100.EXCEPTION 14,826,027.00 ;SQLERRM = User-Defined Exception

Changes

Cause

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