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
Hi, We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be…
Hi everyone, I'm using Oracle BI Publisher version 12c and recently I notice a strange error: when I schedule some reports that use excel templates (.xls), their output can not be opened without the error message "The file format and extension of <report_name> don't match. The file could be corrupted or unsafe. Unless you…
Hi everyone, We configured a SOAP connection in Oracle Integration Cloud (OIC) using OAuth authentication. However, when we run our integrations, the SOAP invocation fails intermittently. Some integration iterations fail. Most iterations succeed. Sometimes, all iterations complete successfully without any issues. When we…
OTM/GTM Product is currently using OAC for reporting. We wanted to know what is the limitation for oracle BI Publisher rtf template size. We already have verified the documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/top-faqs-design-publisher-reports.html But wanted to know if this generic figures…
Hi, We are trying to retrieve the complete history Bip report of assignment updates where the same assignment record has been modified multiple times with an unchanged Effective Start Date. We are currently using PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_M_; however, the data returned does not consistently reflect all…
