R12 Upgrade Driver Fails for glsupdas.ldt -ORA-06508, 'Error loading seed data for GL_DEFAS_ACCESS_SETS: DEFINITION_ACCESS_SET' (Doc ID 1574761.1)

Last updated on AUGUST 07, 2016

Applies to:

Oracle General Ledger - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

As a part of 11.5.10.2 to R12 upgrade, while applying merged R12 upgrade driver(u6678700.drv), the below error occurred:

 

ERROR:

FAILED: file glsupdas.ldt on worker 3 for product gl username APPS.

glsupdas_ldt.log shows:

Error loading seed data for GL_DEFAS_ACCESS_SETS: DEFINITION_ACCESS_SET = SUPER_USER_DEFAS, ORA-06508: PL/SQL: could not find program unit being called

 

Compilation executed for the package errors as following:

SQL> col OBJECT_NAME for a30
SQL> col OBJECT_TYPE for a20
SQL> SELECT OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS
FROM DBA_OBJECTS
WHERE OBJECT_NAME = 'GL_DEFAS_ACCESS_SETS_PKG';  2    3



OWNER                          OBJECT_NAME                    OBJECT_TYPE          STATUS
------------------------------ ------------------------------ -------------------- -------
APPS                           GL_DEFAS_ACCESS_SETS_PKG       PACKAGE              VALID
APPS                           GL_DEFAS_ACCESS_SETS_PKG       PACKAGE BODY         INVALID

SQL> ALTER PACKAGE GL_DEFAS_ACCESS_SETS_PKG COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY GL_DEFAS_ACCESS_SETS_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
39/17    PLS-00302: component 'GL_DEFAS_DBNAME_S' must be declared


Changes

 Upgrade

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