Oracle Enterprise Performance Foundation (EPF) Data Loader Rule Requests For Multiple Calendar Periods Stuck In Pending and Running Status (Doc ID 435318.1)

Last updated on OCTOBER 22, 2012

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.9 to 12.0.0 [Release 11.5 to 12]
Information in this document applies to any platform.
FEM
Data Loader Rule
Detail Client Data Loader

Checked for relevance on 22-Oct-2012.

Symptoms

The Data Loader Rule launched 'Detail Client Data Load' requests are stuck in either 'Pending' or in 'Running'. Master process completes with errors saying to check log file of child 'Detail Client Data Load' processes. Problem does not occur if only loading one calendar period of data.  Upon canceling a request, more processes appear to complete.

EXPECTED BEHAVIOR
Expect that the Data Loader completes all requests successfully in a timely fashion.

Steps To Reproduce:
The issue can be reproduced at will with the following steps:

1. Data loader rules were created, approved and run.
2. Create daily data in FEM_DATAX table for one year worth of data.
3. The Data Loader started rule spawns 365 'Detail Client Data Load' requests for each day calendar period and all the requests do not complete and are either stalled in 'Pending' or 'Running'.

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