My Oracle Support Banner

Budget Formula Error 'ORA-00907: missing right parenthesis' with Process Formula (FAPBDGTF) or Create Student Budget, Build Budget (FAPBUDRC) (Doc ID 2576365.1)

Last updated on SEPTEMBER 21, 2021

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.



After applying Campus Solutions 9.0 Bundle 54 or Campus Solutions 9.2 PUM Image 14, the following error occurs when running the Budget Formula Process in batch or on-line:



The error does not occur in every case with every formula, just certain ones.      

The issue can be replicated with the following steps:

  1. Navigate to Main Menu > Financial Aid > Budgets > Assign Budgets > Process Formula
  2. Enter Run Control
  3. Enter Parameters on the Batch Budget Assignment - Process Formulas Component
  4. Click 'Run' button
  5. Click 'Ok' to run the FAPBDGTF process


  1. Navigate to Main Menu > Financial Aid > Budgets > Create Student Budget
  2. Enter search parameters to pull up student
  3. Click 'Search'
  4. Enter or change Budget Terms if necessary
  5. Click 'Build Budget'




 Changes to the FAPBUDPF.cbl were delivered in Bundle 54 and PUM 14.


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

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