After Upgrade From R11i To R12 GL_RESTORE_JOURNALS_PKG Is Invalid Due To ORA-00904 SET_OF_BOOKS_ID Invalid Identifier (Doc ID 1404315.1)

Last updated on DECEMBER 03, 2015

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
glrjprb.pls - GL_RESTORE_JOURNALS_PKG

Goal

After Upgrade to R12 from R11i one package is invalid PACKAGE BODY GL_RESTORE_JOURNALS_PKG, why?

When try to compile the package body GL_RESTORE_JOURNALS_PKG the following error occurs:

13/5 PL/SQL: SQL Statement ignored
20/9 PL/SQL: ORA-00904: "GBP"."SET_OF_BOOKS_ID": invalid identifier
31/5 PL/SQL: SQL Statement ignored
36/31 PL/SQL: ORA-00904: "SET_OF_BOOKS_ID": invalid identifier


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