AERS Report Failing with PORTAL.THINGS_PARENTID_IDX is disabled (Doc ID 1378361.1)

Last updated on MARCH 08, 2017

Applies to:

Adverse Event Reporting System - Version: 4.6.0 and later   [Release: 4.6 and later ]
Information in this document applies to any platform.

Goal

In AERS 4.6.0

When a generating a report in the AERS Application the report is failing.

The reports trace file is capturing the following error:

Exception 6510 (): ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWSBR_API", line 1631
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWERR_API_EXCEPTION", line 71
ORA-06512: at "PORTAL.WWV_THINGSAVE", line 4203
ORA-30554: function-based index PORTAL.THINGS_PARENTID_IDX is disabled
ORA-06512: at "PORTAL.WWSBR_API", line 1678
ORA-06512: at "PORTAL.WWV_RW_SB", line 309
ORA-06512: at "PORTAL.WWV_RW_SB", line 252
ORA-06512: at line 1


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