R12: Advisory Level Funds Checker Fails with Error APP-SQLGL-08204 Your Transaction(s) Failed Funds Check (Doc ID 549103.1)

Last updated on JUNE 24, 2024

Applies to:

Symptoms

Facts:

• you have enabled Budgetary Control & completed the Budgeting Setup
• you have assigned the range of accounts to your budget and set the budget level to Advisory
• you have available funds that consider your boundary settings

Symptoms:

• GL - you attempt to enter a manual journal in GL using accounts from the mentioned range and the following error message is displayed while saving:
•   'APP-SQLGL-08204 Your transaction(s) failed funds check'
  
  
• GL - click on the 'View results' button: all the accounts combinations/lines have a status of 'Rejected' even if some specific code combinations do not require funds check
  
  
• PO - you create a Requisition and send it for approval; when navigating to: Tools > Check funds displays the following error message:  
•   'Your budgetary control action completed with exceptions'

Note the status is 'pre-approved' and checking the user notification shows: 'Approval workflow database error occurs while approving Standard Purchase order ..';

Give your system administrator the following information:
PO_REQAPPROVAL_ACTION.RESERVE_DOC
Error: User-defined exception

From, sysadmin the error message is visible:

Monitor errors : Workflow errors: POAPPRV...
Failed activity: reserve document
Activity type: Function
Error:-6512
Error message: ORA-06512 at line
Error stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.RESERVE_DOC, POAPPRV, ...)

• AP - while doing invoice fund check the following message is displayed: '
•   There was an error in creation of accounting and budgetary control cannot be performed. Please view accounting from the tools menu to see specific errors'.

Cause

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