How can we run or set context for a multi org environment (for Oracle eBusiness Suite). Our ERP system has multiple org and to get data based on different org we have to set or run "mo_global.SET_POLICY_CONTEXT" command.
Putting this command inside relational connection (as Connection/Transaction Environment sql is not a good solution) as we may have to change connection or use different connection for Same work-flow. or same data extract.
Is there a way inside the mapping or based on run parameter we may change this dynamically.
Know this is a couple years old but we have the same requirements, does anyone have a solution for this? Thanks