My Oracle Support Banner

GLOOAP: Open Periods Program Fails: PERF0005: Oracle error detected in glodpi() - ORA-01031: insufficient privileges (Doc ID 2814965.1)

Last updated on FEBRUARY 16, 2023

Applies to:

Oracle General Ledger - Version 12.2 and later
Information in this document applies to any platform.
GLOOAP: Open Period

Symptoms

GLOOAP: Open Period shows error in the logfile.

Reviewing the logfile, this happens on attempting to drop GL_POSTING_INTERIM tables. All required privileges for DB are granted.


ERROR:


Note: in the interim table's name, such as GL_POSTING_INTERIM_2100 - 2100 is the ledger id, so the error will be slightly different depending on the ledgers used to open the periods for.



STEPS:

The issue can be reproduced at will with the following steps:
1. Upgrade from 12.1.2 to 12.2
2. GL Responsibility > Setup > Open/Close
3. Attempt to open any period
4. A concurrent program is thrown which ends in error



Changes

 Upgraded from 12.1.2 to 12.2

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.