can you explain this table fusion.ess_request_history in oracle fusion each column

Question

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/25284/can-you-explain-this-table-fusion-ess-request-history-in-oracle-fusion-each-column

Hi ,

Welcome to Oracle Analytics community.

As your query is specific to Fusion application, I would suggest you to post your query on customer connect:

Welcome to Cloud Customer Connect

Try checking below link if you are trying to get details of scheduled BIP jobs. But please user customer connect or below forum:

Oracle Transactional Business Intelligence — Oracle Analytics

BIP - Report to extract BIP scheduled jobs - MSPL

Thanks.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/66280#Comment_66280

Hi Narendra,

Thanks for the details.

Apologies, I'm not able to understand the requirement / the issue you are facing here.

Please take a look into the following doc where it has mapping for those job names.

https://docs.oracle.com/en/cloud/saas/human-resources/24d/faucf/what-do-i-select-for-job-application-name-when-i-create-a-job-definition.html

Hope this help.

Thank you.

User_R7XXV · Answer

HI Bhaskar Konar,

I’m currently trying to identify scheduled jobs in the backend. I’ve already prepared a query using the ESS_REQUEST_HISTORY table.

In this column 'APPLICATION' column I can see values like CrmEss, FscmEss, and bipublisher

However, my goal is to specifically find monitoring programs in oracle fusion,

Could you please guide me

Thanks,

Narendra