Eamdffup.Sql is Failing with error: ORA-06512: at "APPS.FND_FLEX_DSC_API", line 298 when calling the procedure FND_FLEX_DSC_API.CREATE_SEGMENT (Doc ID 1274063.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Enterprise Asset Management - Version 12.0.0 and later
Information in this document applies to any platform.
.


**Checked for relevance on 18-MAY-2012**

Symptoms

While applying R12 Upgrade <Patch.6394500> - UPGRADE DRIVER FOR 12.0.4, the eamdffup.sql fails with the following:


ERROR
--------

sqlplus -s APPS/***** @/visapps/oracle/apps/apps_st/appl/eam/12.0.0/patch/115/sql/eamdffup.sql
DECLARE
*
ERROR at line 1:
ORA-06501: PL/SQL: program error
ORA-06512: at "APPS.FND_FLEX_DSC_API", line 1626
ORA-06501: PL/SQL: program error
ORA-06512: at "APPS.FND_FLEX_DSC_API", line 298
ORA-01403: no data found
ORA-06512: at line 177



STEPS
-----------------------
1. apply patch.6394500
2. review worker logs

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