My Oracle Support Banner

Troubleshooting Open Period Balances Program (XLABAOPE) (Doc ID 1478724.1)

Last updated on JUNE 07, 2023

Applies to:

Oracle Financials Accounting Hub - Version 12.1.3 and later
Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
merged with 1230404.1
merged with 1324070.1
merged with 1538517.1
merged with 2093487.1


Purpose

The purpose of the subledger open period balances program is to maintain the subledger accounting (SLA) balances in the subledger database objects. The program is submitted automatically by the General Ledger open period program (GLOOAP).  There is a business event which is triggered when the user opens a period in General Ledger (GL).  The subscription to this event is no longer needed in release 12 due to changes in the SLA architecture. This program does not affect the success or failure of the General Ledger open periods program. It is a separate program. Sometimes this program completes with an error. This document provides guidance on how to analyze the possible errors and the steps to take to resolve the unsuccessful execution of the program.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 General Patch Application Steps
 How to disable the subscription to the associated business event
 Target period AAA-YY is not Open/Close/Pending close Period
 PLS-00306: wrong number or types of arguments in call to 'Open_Period_SRS'
 Balances upgrade script xlabalupg.sql has not been run
 There is no record in xla_ledger_options for ledger
 PLS-00201:identifier 'XLA_BALANCES_CALC_PKG.OPEN_PERIOD_SRS' must be declared
 Balances exists for the target period XXX and ledger XXX
 Opening a Period for a Ledger with ADB: Target period XXX-NN is not Open/Close/Pending close Period
 ORA-20001: -: XLA-95103: An internal error occurred.
 How to Disable the SLA Open Period Balances program (XLABAOPE) from being spawned by the Open Period program
References

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