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

Question

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

SantoshKumarBhairi · Answer

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