Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
ESS Request History SQL - is it possible to extract Job Name? — Cloud Customer Connect
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

ESS Request History SQL - is it possible to extract Job Name?

Received Response
30
Views
2
Comments
edited Mar 27, 2020 10:50AM in Applications Security 2 comments

Content

Hi,

Over time I've built up an SQL statement which has a DECODE statement to look up the definition value from the definition field of the request_history table.

This is a sample of the SQL:

select rh.requestid
, flv_state.meaning status
, to_char(rh.processstart, 'YYYY-MM-DD HH24:MI:SS') process_start
, to_char(rh.processend,   'YYYY-MM-DD HH24:MI:SS') process_end
, rh.definition full_definition
, decode(regexp_substr(rh.definition, '[^/]+', 1, length(regexp_replace(rh.definition, '[^/]', ''))), 'aaa','aaa'
                      , 'IBY_FD_FINAL_PMT_REGISTER',            'Payment File Register'
                      , 'IBY_FD_PAYMENT_FORMAT',                'Format Payment
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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