We are in the process of building our own data warehouse with Data Manager against the Oracle EBS R-12 views. We are using Oracle 10g for this implementation. This week I have learned that with R-12 I must execute the following code:
declare
begin mo_global.set_policy_context('S','83');
end;
to set the environment so that I can return data. I can do this within Toad, but at this time I do not know how to execute this code within Data Manager so that my builds will return any data. Has anyone run into this kind of thing? Has anyone run this kind of code within a Procedure Nod?
Can you try it using 'Lookup' function. Add all these inside this function
if it is not working just create a stored procedure with those strings and execute from procedure node