Projects - EBS (MOSC)

MOSC Banner

Employee with Labor Schedule Deleted in HR - Now GMS_Balances has orphan encumbrances

edited Mar 10, 2016 4:06AM in Projects - EBS (MOSC) 4 commentsAnswered

We had an employee who was created in HR, and had a labor schedule attached to them for a specific project.  The employee never started, so instead of terminating the HR record, they deleted the HR record. No payroll had ever been run against the record, so Oracle let that go through.  However, that left orphan encumbrance records in the gms_balances table for the salary and fringe.  Has anyone had an issue like this?  I am looking at the tables that might need updates to "correct" this issue but wondered if anyone had already gone down this road.

It can't be fixed from LD because the person_id and assignment_id no longer relate to anything.  We need to close the award/project, but want to try to get this back in sync first.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center