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 AUGUST 21, 2016

Applies to:

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

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

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