0 Replies Latest reply: Oct 26, 2012 4:04 AM by Roshni Shankar RSS

    how can I map the composite_dn name with a composite in run time

    Roshni Shankar
      Hi All,

      I want to craete a report on number of total business and system faults with the help of Information Publisher in OEM 12c Cloud Control. I am fetching data from the table composite_instance_fault present in SOAINFRA schema. Below os my SQL statement:-

      select error_category,count(error_category) from prefix_SOAINFRA.composite_instance_fault where composite_dn=??EMIP_BIND_TARGET_GUID?? group by error_category

      Now I want to know that how can I map the composite_dn name with a composite in run time. When we fetch data from the repository we used to map target in rumtime by using ??EMIP_BIND_TARGET_GUID?? but here as I am not fetching data from repository, how can I map target in run time.

      On executing the above SQL statement its returing an empty table without any data.

      Please guide!!

      Thanks in Advance!!