OGL EPF : Balances Rule Erroring Out With 'Snapshot Load Has Already Been Run'
Last updated on JULY 28, 2017
Applies to:Oracle Enterprise Performance Foundation - Version 11.5.9 to 22.214.171.124 [Release 11.5]
Information in this document applies to any platform.
OGL EPF Data Integration
This problem can occur on any platform.
When attempting to rerun a balances rule to pick up changes in GL balances, the following error occurs:
Dataset Code 10062 and period JAN-05 registration failed.
The Snapshot load has already been run. Additional loads for this Ledger,
Dataset, and Period must be run in Incremental mode.
Cannot execute rule with this set of parameters.
All periods could not be processed for Dataset Code 10062 because there is a period gap.
All periods could not be processed for the Balances Rule version.
The Output log file for the Balance Rule request shows the following error:
Date: 10-MAR-2006 07:03:36 General Ledger Balances Rule
Execution Report Page 1
Balances Rule Version : Actuals
From Period : JAN-05
To Period : OCT-05
As-Of Date :
From Balancing Segment Value :
To Balancing Segment Value :
Period Registration Status
JAN-05 Failed because of execution lock
FEB-05 Failed because of period gap
MAR-05 Failed because of period gap
APR-05 Failed because of period gap
MAY-05 Failed because of period gap
JUN-05 Failed because of period gap
JUL-05 Failed because of period gap
AUG-05 Failed because of period gap
SEP-05 Failed because of period gap
OCT-05 Failed because of period gap
The issue can be reproduced at will with the following steps:
1. EPF Administrator -> Data Rules -> Oracle Data Sources
2. Rerun GL Balances Rule
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