External Awards Posting Error 654 (Doc ID 2245888.1)

Last updated on MARCH 20, 2017

Applies to:

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

Symptoms

On : CS 9 Production

ACTUAL BEHAVIOR
---------------
When loading external awards in offered status, some of the awards fail to load. The process runs successfully, but these transactions end up with an error code 654: "There is an existing Award in non Offered status. You are trying to load an Offered award, but there is an existing Award in a non Offered status." This happens when the item types were previously awarded then cancelled.

EXPECTED BEHAVIOR
-----------------------
The awards should load as the students have not previously been awarded the item types.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Award and cancel item type
2. Load same item type to EA staging table
3. Run EA load process

WHAT IS WORKING
------------------------
Awards are loaded correctly when using the offer/accepted status, and the offer status is working fine if the same item type isn't on the award in cancelled status

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are stuck with a significant number of awards they can't easily 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