In Bursting query parameter3 will be auto generated automatically based on instance how can we fetch

Manabolu Swetha

In Bursting query parameter3 will be auto generated automatically based on instance how can we fetch, could you please help me.

SantoshKumarBhairi

hi Swetha,

Good to meet you here :)

You will have to get the instance from this query :

(

select external_virtual_host instance_url 

from  fusion.ask_deployed_domains

where deployed_domain_name='FADomain'

)

and then based on instance_url, construct your fusion instance.

 ,case 

when instance.instance_url = 'aa-bbb-test-saasfaprod1.fa.ocs.oraclecloud.com' then 'aa-bbb-test.bi.sender@workflow.mail.em2.cloud.oracle.com'

  when instance.instance_url = 'aa-bbb-dev1-saasfaprod1.fa.ocs.oraclecloud.com' then 'aa-bbb-dev1.bi.sender@workflow.mail.em2.cloud.oracle.com'

  when instance.instance_url = 'aa-bbb-dev2-saasfaprod1.fa.ocs.oraclecloud.com' then 'aa-bbb-dev2.bi.sender@workflow.mail.em2.cloud.oracle.com'

  when instance.instance_url = 'aa-bbb-saasfaprod1.fa.ocs.oraclecloud.com'   then 'aa-bbb-bi.sender@workflow.mail.em2.cloud.oracle.com'

else 'no.sender@workflow.mail.em2.cloud.oracle.com'

end PARAMETER3