In Bursting query parameter3 will be auto generated automatically based on instance how can we fetch, could you please help me.
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
