Applying merged patch 5223527 and 6402403, fails on fem5986909_del.sql with ORA-01403 and ORA-06512 (Doc ID 728108.1)

Last updated on MARCH 08, 2011

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.
FEM

Symptoms

When applying the merged patch 5223527 and 6402403, the patching fails at fem5986909_del.sql.

plus80 -s APPS/***** @E:\oracleAPL\sgt2appl\fem\11.5.0\patch\115\sql\fem5986909_del.sql

Error:
Program exited with status 3
Cause: The program terminated, returning status code 3.
Action: Check your installation manual for the meaning of this code on this operating system.DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 7

Users verified that FEM_DIMENSIONS_B table exists; however, the table is empty.

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