For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
We are not able to get the exact name from the ess job name we are able to get the alternative names but need the excat name in the ESS job schedue page
Comment
Refer below table,
ESS_REQUEST_HISTORY
ESS_REQUEST_PROPERTY
-Senthil
Average Rating:



1 rating
|
Sign in to rate this
But these tables are not storing the required information
for example, job name is import journal its storing the importjournals like this.
in need the detail name like import journals
Be the first to rate this
|
Sign in to rate this
You may need to combine these two tables and if you know the value for the process that you looking for, you can get the details.
Eg. Below query is for the process 'autoInvoices'
SELECT * FROM FUSION.ESS_REQUEST_HISTORY RH
INNER JOIN FUSION.ESS_REQUEST_PROPERTY RP
ON RP.REQUESTID = RH.REQUESTID
WHERE RP.VALUE = '/oracle/apps/ess/financials/receivables/transactions/autoInvoices'
You can check RP.NAME and RP.VALUE
Average Rating:



1 rating
|
Sign in to rate this
Try this one you...
SELECT rp.*,
rh.*
FROM ess_request_property RP,
ess_request_history RH
WHERE RP.requestid = RH.requestid
AND value LIKE '%Program - Import Journals%'
Average Rating:



1 rating
|
Sign in to rate this