My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.