Used below SQL to generate link/URL for invoice.
('https://'
|| (SELECT external_virtual_host INVOICE_URL
FROM ask_deployed_domains
WHERE deployed_domain_name = 'FADomain')
||'/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId='||AIA.Invoice_id||';OrgId='||AIA.org_id
)
INVOICE_URL
INVOICE_URL tag is used in rtf to generate output.
In normal report output it is working expected. But in notifications when click on the link then it is opening in same tab and there is no way to go back to notification page to check other invoices.
Expectation is to open that invoice in separate tab so that we can easily navigate to notification page to check other invoices.
Please let me know if we can achieve this in notifications.