My Oracle Support Banner

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

Last updated on JUNE 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.