How To Delete BALANCE_BUILD Processes Created By Errors (ORA-08102: index key not found) in Generate Run Balance Process (Doc ID 1374578.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Payroll - Version 11.5.10.2 to 12.2.3 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

The Generate Run Balance process completed with error:

ORA-08102: index key not found, obj# 215600, file 25, block 2054857 (2)


Review of the associated erring assignments shows that there are now many rows in the Assignment Process Results window that can't be deleted.  These records are all a Magnetic Report name "BALANCE_BUILD". 

How can these rows be deleted?

Solution

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