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

User_R7XXV · Apr 11, 2025 12:42PM

Bhaskar Konar · Apr 11, 2025 3:02PM

Welcome to the Oracle Analytics Community.

Please find below the table structure and take a look into the following post for details.

Hope this help.

Thank you.

User_R7XXV · Apr 11, 2025 3:24PM

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

Bhaskar Konar · Apr 11, 2025 4:22PM

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.

Hope this help.

Thank you.

MandeepGupta · Apr 14, 2025 4:19AM

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:

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

Thanks.

MFA for Oracle Community