GLSTFL:General Ledger Accounting Setup Program Complete With Error When ledger finishes setup (Doc ID 981168.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle General Ledger - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Executable:GLSTFL - General Ledger Accounting Setup Program

Symptoms

When attempting to define the Ledger and submit the General Ledger Accounting Setup Program, the request completes with following errors

ERROR
-----------------------
<< GL_FLATTEN_SETUP_DATA.Release_Lock() 09-DEC-09 21:16:45
SHRD0203: Oracle error detected in GL_FLATTEN_SETUP_DATA.Main() - ORA-23401: materialized view "APPS"."GL_ACCESS_SET_LEDGERS" does not exist

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. GL Responsibility > Accounting Setup Manager > Accounting Setups > Make changes > Save
The program gets submitted automatically.

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