Oracle Fusion Custom ESS Job Details Query
select DISTINCT
erh.application, erh.product, erh.type,
erh.definition , erh.jobtype , frp.name PROPERTY_TYPE, frp.value PROPERTY_VALUE
from fusion.ESS_REQUEST_HISTORY erh , fusion.REQUEST_PROPERTY frp
where 1=1
AND erh.definition like '%oracle/apps/ess/custom/%'
and erh.requestid = frp.requestid
Comments |0|
Category: OracleSaaS