My Oracle Support Banner

ORA-23401 Occurs in General Ledger Accounting Setup Program (Doc ID 2402289.1)

Last updated on MAY 23, 2018

Applies to:

Oracle General Ledger - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a new ledger with Accounting Setup Manager, General Ledger Accounting Setup Program ends with an error.

Error

SHRD0203: Oracle error detected in GL_FLATTEN_SETUP_DATA.Main() - ORA-23401: materialized view "APPS"."GL_ACCESS_SET_LEDGERS" does not exist

Steps To Reproduce

The issue can be reproduced at will with the following steps:

1. Navigate to Setup > Financials > Accounting Setup Manager > Accounting Setups.

2. Complete ledger definition.

3. General Ledger Accounting Setup Program ends with above error.

Changes

 

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.