table name for input value in BIP report oracle

Question

Abhilash K - Deloitte USI · Answer

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

Gianni Ceresa · Answer

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…