My Oracle Support Banner

Build Budget Process Erroring Out (Doc ID 2465560.1)

Last updated on NOVEMBER 14, 2019

Applies to:

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


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

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()

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.




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.