Update Subledger Accounting Balances Program Getting Error 'Before proceeding with balance calculation, run Open Period Balances Program for Ledger'

(Doc ID 1943732.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.2 version, Accounting Issues in AP

When attempting to run the Update Subledger Accounting Balances program, the following error occurs:

ERROR
-----------------------
An internal error has occurred in the program xla_balances_calc_pkg.calculate_balances. Balances are not initialized for the latest open period.

To check the issue, run:

SELECT DISTINCT
 xlo.effective_period_num xlo_effective_period_num ,
 (
   SELECT
     MAX(gps.effective_period_num)
   FROM
     gl_period_statuses gps
   WHERE
     gps.application_id           = 101
   AND gps.ledger_id              = xlo.ledger_id
   AND gps.closing_status        IN ('O','C','P')
   AND gps.adjustment_period_flag = 'N'
 )
 gps_effective_period_num ,
 xlo.ledger_id
FROM
 xla_ledger_options xlo ,
 xla_ledger_relationships_v xlr ,
 xla_ae_headers xah
WHERE
 xlo.ledger_id = DECODE(xlr.ledger_category_code , 'ALC' ,
 xlr.primary_ledger_id, xlr.ledger_id)
AND xlo.application_id = 200
AND xah.application_id = 200
AND xlr.ledger_id      = xah.ledger_id;

The issue is confirmed if any value from XLO_EFFECTIVE_PERIOD_NUM is smaller than GPS_EFFECTIVE_PERIOD_NUM.



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