Context Value should be defaulted as "Changes made to invoice" in AP Invoice Header in Oracle Fusion
Hi Team,
We have a requirment to default the Context Value as "Changes made to invoice" only for invoice source is "ISP"
We tried to use SQL option in the DFF setting and tried to write below SQL , but we recieve :ERROR {PARAMETER.InvoiceId} is not available for AP_INVOICE DFF.
select (case when SOURCE = 'ISP' then 'Changes made to invoice' else '' end)
from AP_INVOICES_ALL
where INVOICE_ID = :{PARAMETER.InvoiceId}
Since this is basic requirment , is there a way to do it , why we receive above error
We we can not use this :{PARAMETER.InvoiceId} , is there any avaibale parameter to use ?
Tagged:
0