Oracle Reports (MOSC)

MOSC Banner

How to use view in value set ?

edited Jun 4, 2012 11:20PM in Oracle Reports (MOSC) 8 commentsAnswered ✓
 Hi ,

There are some views does not retrieve any data when you select from it .

like  AR_SHIP_ADDRESS_V 

unless you set the ORG_ID prior to running the script , by using this procedure

begin
mo_global.set_policy_context('S',&org_id);
end;

the question is : how can i use a view like this in my value set  ?

Thanks in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center