My Oracle Support Banner

Build Budget Process Erroring Out (Doc ID 2465560.1)

Last updated on OCTOBER 26, 2018

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 and later
Information in this document applies to any platform.

Symptoms

After making changes to the Budget Formulas the process is erring when calculating for a single student and in batch

ERROR
-----------------------
RC=1747  ERR rtncd=1747 msg=ORA-01747: invalid user.table.column, table.column, or column specification
14:28:55.411      15765     0.000     0.000   #17    RC=0     EPO error pos=62
14:28:55.411      15766     0.000     0.000   #0     RC=0       PSORA - OCITransRollback()


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set Up budget requirements
2. Financial Aid --> Budgets --> Build Student Budgets
3. Insert Emplid, Institution and Aid Year
4. Once in the page enter the terms you want to build
5. Click Build Budget
6. review results

Note: the issue occurs for both batch and online budgets as the online budget (Create Student Budget) uses the same run control parameters that are used in batch.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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