If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Data Manager & Oracle EBS R-12

Started by saunmik, 13 Feb 2009 03:21:55 PM

Previous topic - Next topic

saunmik

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?


UseCog

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