How to view data In Oracle apps R12 views

 Tips to Show data In Oracle apps R12 views

Oracle Views containts data from all the different Orgs, so while quering it may not show the data in it , so to fetch data in oracle views below are few tips 

Tip 1>Set multi org context as below,

begin

MO_GLOBAL.SET_POLICY_CONTEXT('S',84);-- — pass in the organization id

end ;

/

Find out org id from below query.

SELECT FND_PROFILE.VALUE('ORG_ID') FROM DUAL --82

/

Tips2 >>Some time you need to perform below setting

Issue got resolved after changing language in sql developer,

Tools>Preferences>Database>NLS>Language >  American .

It was English changed to American and it worked .