EGRC 8.6.5.1000: New Install Failed with "PLS-00905: object GRCUSER.GRC_SEED_LOOKUPS_CONTROL is invalid"

(Doc ID 1905933.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.6.5 to 8.6.5 [Release 8]
Information in this document applies to any platform.

Symptoms

On : 8.6.5.100 version, Install, Migration, Upgrade

When attempting to install AACG, the following error occurs.

ERROR
-----------------------

2014-07-09 02:34:23,669 ERROR [Thread-27] DataMigrationManager:471 **************************************************
2014-07-09 02:34:23,670 ERROR [Thread-27] DataMigrationManager:472 Error while executing Patch Data Migration. Patch # 3902
2014-07-09 02:34:23,670 ERROR [Thread-27] DataMigrationManager:474 **************************************************
2014-07-09 02:34:23,940 ERROR [Thread-27] DataMigrationManager:1087 Exception occured while executing stored procedure grc_seed_lookups_control
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00905: object GRCUSER.GRC_SEED_LOOKUPS_CONTROL is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

...

...
2014-07-09 04:14:09,472 ERROR [Thread-27] DBConfigService:362 Schema initialization failed with error:Unknown Error in the installation/Updating the Schema
2014-07-09 04:14:09,477 ERROR [Thread-27] GrcInitializationService:432 Error occurred during initialization:
oracle.apps.grc.dataservices.exception.DataServiceException: Schema initialization error for:ALL
at oracle.apps.grc.dataaccessfacade.impl.DBConfigService.upgrade(DBConfigService.java:363)
at oracle.apps.grc.dataaccessfacade.impl.DBConfigService.upgrade(DBConfigService.java:270)
at oracle.apps.grc.dataaccessfacade.impl.DBConfigService.upgrade(DBConfigService.java:255)
at oracle.apps.grc.appservices.initialization.GrcUpgradeService.upgrade(SourceFile:154)
at oracle.apps.grc.appservices.initialization.GrcInitializationService$a.run(SourceFile:178)
at java.lang.Thread.run(Thread.java:745)
2014-07-09 04:14:09,478 ERROR [Thread-27] GrcInitializationService:435 ********************************************************
2014-07-09 04:14:09,478 ERROR [Thread-27] GrcInitializationService:436 ********************************************************
2014-07-09 04:14:09,478 ERROR [Thread-27] GrcInitializationService:437 * Application Initialization completed with Error. *
2014-07-09 04:14:09,479 ERROR [Thread-27] GrcInitializationService:438 ********************************************************
2014-07-09 04:14:09,479 ERROR [Thread-27] GrcInitializationService:439 ********************************************************


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Unzip the AACG
2. Deploy the file using Weblogic
3. Access the Url and update the Config UI page

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform the installation successfully.

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