The Delivered Update FA Progress Units Process (SFA_FAUNTUPD) Is Running To No Success (Doc ID 2302626.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

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

Symptoms

In CS 9.0

When attempting to run Update FA Progress Units the following error occurs.

ERROR
-----------------------
Error: save conflict error in method updateStdntSession (). 14670,99

error. Stmt #: 1708 Error Position: 76 Return: 1002 - ORA-01002: fetch out of sequence
Failed SQL stmt: SELECT A.EMPLID, A.ACAD_CAREER, A.INSTITUTION, A.STRM, A.CLASS_NBR FROM PS_SFA_FAUNTU_TRGT A WHERE A.PROCESS_INSTANCE = xxxxxx
Process 659801 ABENDED at Step SFA_FAUNTUPD.PRCDTA.Step010 (Do Select) -- RC = 1002 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set up external file or query to select students
2. Run process

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