You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to best analyze ESS Job Schedules?

edited Dec 9, 2019 1:45PM in Financials – General (READ ONLY) 3 comments

Summary

How to best analyze ESS Job Schedules?

Content

We have a basic need which we are struggling to find an answer to:

How do we best analyze the jobs from ESS schedule? 

Per our SR with Oracle, we cannot write a BIP SQL to extract the data from ESS tables because the NAMES of the jobs are not stored in the database. This means that the SQLs we can write are of no use to use because it does not contain the basic element NAME along with all the other relevent info.

We also cannot effectively use the ESS UI because the search functionality is very limited, including not allowing a large download of the ESS data. SQL would be much better.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!