My Oracle Support Banner

Unable To Create New Enterprise In Multi Tenant : ORA-30554: function-based index ARGUS_APP.FBI_LMCO_COUNTRY is Disabled (Doc ID 2591471.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.1.1 and later
Information in this document applies to any platform.

Symptoms

Unable to create a new Enterprise in an Argus Multi-tenant environment, when attempting this the below error is received :


Below is subsequently reported in cmn_error_log:

'ORA-30554: function-based index ARGUS_APP.FBI_LMCO_COUNTRY is disabled
Error in processing LM_COUNTRIES. ERROR BACKTRACE ORA-06512: at "ARGUS_APP.PKG_SETUP_NEW_ENTERPRISE", line 1387
ORA-06512: at "ARGUS_APP.PKG_SETUP_NEW_ENTERPRISE", line 1533
 UTL CALL STACK
PL/SQL Call Stack:
1590 PKG_SETUP_NEW_ENTERPRISE.P_SETUP_NEW_ENTERPRISE
1 __anonymous_block'



Steps
The issue can be reproduced at will with the following steps.


 1. In multi-tenant Argus installation attempt to create a new Enterprise.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.