R12:GL: After Upgrading From R12.1.3 to R12.2, Some Standard Objects, Such as GLFG* And GLBG*, Are No Longer Exist
(Doc ID 2918072.1)
Last updated on MAY 26, 2023
Applies to:
Oracle General Ledger - Version 12.2 and laterOracle Financials Intelligence - Version 12.0.1 and later
Information in this document applies to any platform.
Symptoms
ISSUE:
-----------------------
Upon upgrading from 12.1.3 to 12.2.X, it has been noted that certain standard objects (VIEWS and SYNONYMS) are missing from the "APPS" schema.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into SQL*PLUS
2. Connect as "APPS" User
3. Run SQL command:
4. No Rows Returned
Missing Objects List:
VIEWS:
GLFG_GL_BUDGETS
GLFG_GL_BUDGET_ASSIGNMENTS
GLFG_GL_BUDGET_ORGANIZATIONS
GLFG_JOURNAL_BATCHES
GLFG_JOURNAL_LINES
GLBG_JOURNAL_BATCHES
GLBG_JOURNAL_LINES
GLFG_ACTUAL_JOURNAL_BATCHES
GLFG_BUDGET_JOURNAL_BATCHES
GLFG_ENCUMBRANCE_BALANCES
GLFG_ENCUMB_JOURNAL_BATCHES
GLBG_ACTUAL_JOURNAL_BATCHES
GLBG_BUDGET_JOURNAL_BATCHES
GLBG_ENCUMBRANCE_BALANCES
GLBG_ENCUMB_JOURNAL_BATCHES
GLBG_GL_BUDGETS
GLBG_GL_BUDGET_ASSIGNMENTS
GLBG_GL_BUDGET_ORGANIZATIONS
GLFG_JOURNAL_ENTRIES
GLFG_GL_STANDARD_BALANCES
GLFG_GL_AVERAGE_BALANCES
GLFG_ENCUMB_JOURNAL_ENTRIES
GLFG_BUDGET_JOURNAL_ENTRIES
GLFG_BUDGET_BALANCES
GLFG_ACTUAL_JOURNAL_ENTRIES
GLFG_ACTUAL_BALANCES
GLBG_JOURNAL_ENTRIES
GLBG_GL_STANDARD_BALANCES
GLBG_GL_AVERAGE_BALANCES
GLBG_ENCUMB_JOURNAL_ENTRIES
GLBG_BUDGET_JOURNAL_ENTRIES
GLBG_BUDGET_BALANCES
GLBG_ACTUAL_JOURNAL_ENTRIES
GLBG_ACTUAL_BALANCES
SYNONYMS:
GLFG_GL_BUDGETS
GLFG_GL_BUDGET_ASSIGNMENTS
GLFG_GL_BUDGET_ORGANIZATIONS
GLFG_JOURNAL_BATCHES
GLFG_JOURNAL_LINES
GLBG_JOURNAL_BATCHES
GLBG_JOURNAL_LINES
GLFG_ACTUAL_JOURNAL_BATCHES
GLFG_BUDGET_JOURNAL_BATCHES
GLFG_ENCUMBRANCE_BALANCES
GLFG_ENCUMB_JOURNAL_BATCHES
GLBG_ACTUAL_JOURNAL_BATCHES
GLBG_BUDGET_JOURNAL_BATCHES
GLBG_ENCUMBRANCE_BALANCES
GLBG_ENCUMB_JOURNAL_BATCHES
GLBG_GL_BUDGETS
GLBG_GL_BUDGET_ASSIGNMENTS
GLBG_GL_BUDGET_ORGANIZATIONS
GLFG_JOURNAL_ENTRIES
GLFG_GL_STANDARD_BALANCES
GLFG_GL_AVERAGE_BALANCES
GLFG_ENCUMB_JOURNAL_ENTRIES
GLFG_BUDGET_JOURNAL_ENTRIES
GLFG_BUDGET_BALANCES
GLFG_ACTUAL_JOURNAL_ENTRIES
GLFG_ACTUAL_BALANCES
GLBG_JOURNAL_ENTRIES
GLBG_GL_STANDARD_BALANCES
GLBG_GL_AVERAGE_BALANCES
GLBG_ENCUMB_JOURNAL_ENTRIES
GLBG_BUDGET_JOURNAL_ENTRIES
GLBG_BUDGET_BALANCES
GLBG_ACTUAL_JOURNAL_ENTRIES
GLBG_ACTUAL_BALANCES
Changes
EBS Application upgraded to 12.2.9
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 |
References |