You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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 ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!