Hi,
The content of your question apparently got lost somehow… Could you post it again? Remember that the more time you invest in writing a detailed question, the more chances you get to have a reply…
As Gianni pointed out above, please give some details while submission of the question so we have all the necessary info to provide some assistance in the forum. It improves the quality of the forum when there is a question with all details so someone can chime in and help.
If its a scheduled BI job, you may be able to data in Request Property table.
The Jobset and Job Definitions are not stored in any DB tables to query. They are xml documents stored in MDS DB which cannot be queried using SQL.
Alternatively, you could get the Metadata names once they are run from the Scheduled Process UI. You could use the UI to display the Metadata Name or query the following table for information:
select * from FUSION_ORA_ESS.REQUEST_HISTORY
Reference Link:Oracle Support Document 2430380.1 (What are the Tables Where the ESS Jobs and Custom Job Sets are Stored? ) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2430380.1
Thanks,
Abhilash
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
I have been tasked with creating a run book for ESS jobs. Whilst the queries are centred on the ESS_REQUEST_HISTORY table I would appreciate any suggestions/best practice for implementing a set of reports
Hi,😊 I have a technical issue that I am struggling to resolve. I created an RTF layout, and the preview works correctly when using the BI Publisher Add-in tool. However, when I upload the layout in eText format, the generated report displays only question marks (???) instead of the expected data. I have not been able to…
hi Oracle team, Have a scenario: Country = A, then page 1 should have a notification for that country with no header/footer however page 2 onwards, the existing content with header/footer. but if Country != A then no notification and has to display existing one with the header/footer. Tried option A: Native word option…
Hi Oracle Community, I have a requirement in Oracle Fusion HCM Performance Management and would like to understand the recommended approach for BI Publisher. The business flow is as follows: A Manager logs into Oracle Fusion using their manager account. The manager can see the performance documents of their direct reports.…
I have Windows 64-Bit in my system and I have downloaded Oracle BI Publisher Desktop 64-bit. when trying to install Oracle BI Publisher in my system, I get error like "Set Word2007 flg failed" or "Please uninstall the current version using Add or Remove Program from the control Panel" But there is no program for Oracle BI…
