Oracle Enterprise Performance Foundation (EPF) Data Loader Rule Requests For Multiple Calendar Periods Stuck In Pending and Running Status
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.
Data Loader Rule
Detail Client Data Loader
Checked for relevance on 22-Oct-2012.
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.
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'.
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