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 MARCH 12, 2019
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
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'.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document