DbAdapter provides all kind of operations that helps you interact with the DB.
I saw more than few times, questions, about how to use dynamic parameters when executing the ‘Execute Pure SQL‘ operation.
In the following step I will explain how to do it.
Execute Pure SQL
Inside the Custom SQL sheet, insert your sql query.
Use the ‘#‘ sign to define the parameter.
For example:
Select order_number
From oe_order_headers_all
Where header_id = #header_id
(header_id is the parameter name)
Notice that inside the input element part, a new “parameter” element was defined.
Verify that the type attribute is not null and being defined properly (for example: xs:integer). Otherwise you will get compilation error.
That’s actually it.
Now you can drag an invoke activity and connect it to the new Partner Link.
Drag also an assign activity before the invoke activity.
Within the assign activity you can assign the required parameter.
Good Luck
Contact Arik Lalo to get an OFFER on Oracle Products
Oracle Fusion Middleware 
Can you tell me how to use Pre sql that takes a parameter that uses the IN clause ..example select * from employee where employee_id IN (#varEmployeeId)
select * from employee where employee_id IN (SELECT (COLUMN_VALUE).GETNUMBERVAL() FROM XMLTABLE(#varEmployeeId))