How to use Parameters - Web ADI

Many friends commented about parameter use while importing pl/sql API or concurrent program. Sorry for very late post but here you go.

You can create parameters in the 'Uploader' section.

It can be of four types:
None
Value Set
Fnd Lookup
Bne Query - Simple/Complex

Here I am showing you Bne Query type, Go to 'Uploader' section your integrator and 'Add Parameter'

Provide the details as below and note down the Parameter name, Apply

Provide the details as below and note down the Parameter name

Apply and it should look like this

Now, next and move to the 'Importer' section, here I am calling PL/SQL API. Same will be applied to Synchronous/Asynchronous concurrent request call.

Under the Importer Rule section add the PL/SQL API Call rule.

For source, you have four options

Environment Variables

Import  -- Attributes reference of the 'Interface' section, the value you pass from the Spread sheet

Interface Table

Uplaod Parameters 

Here I am showing how to use parameters we created above and the Environment variables

$env$.userid: returns the current user ID

$env$.appid: returns the application ID

$env$.respid: returns the responsibility ID

And these parameters will appear when you upload the data and Importer will be called 

Related Topic: Calling Concurrent Program - Web ADI