OGL EPF : Balances Rule Erroring Out With 'Snapshot Load Has Already Been Run' (Doc ID 361892.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
OGL EPF Data Integration
FEM
This problem can occur on any platform.

Symptoms

When attempting to rerun a balances rule to pick up changes in GL balances, the following error occurs:

ERROR
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 :


Dataset Default


Registration Status:

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


STEPS
The issue can be reproduced at will with the following steps:
1. EPF Administrator -> Data Rules -> Oracle Data Sources
2. Rerun GL Balances Rule

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