Home » Applications » Oracle Fusion Apps & E-Business Suite » View Changes in Discoverer (Oracle Applications Release 12.1.3)
View Changes in Discoverer [message #495638] Mon, 21 February 2011 08:18 Go to next message
Messages: 1
Registered: February 2011
Location: Dubai
Junior Member


We recently Upgraded to R12.1.3 from

We have used CLIENT INFO for our instance Organization and Org Id is same.

How to re-write the query.

  • Attachment: QUERY.txt
    (Size: 4.04KB, Downloaded 248 times)
Re: View Changes in Discoverer [message #496191 is a reply to message #495638] Fri, 25 February 2011 03:18 Go to previous messageGo to next message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
From where you are running this sql?
Concurrent Program / Forms / SQL*Plus / etc?

Try to join org_organization_definitions.
But in R12 each responsibility can have access to many org's.
Which one you want to consider?

Please read the Forum Guide and Apps Forum Guide.

Re: View Changes in Discoverer [message #500236 is a reply to message #496191] Fri, 18 March 2011 09:27 Go to previous message
Messages: 39
Registered: February 2008
Location: Cambridge UK
Hi there,

In R12 because of MOAC, you need to use the new 'MO_GLOBAL' functions, instead of the 'CLIENT_INFO'.

Have a search for R12 MO_GLOBAL, there is lots of info which can help.

Previous Topic: Answer these Financial Interview Questions
Next Topic: Fixed Asset Accounts Functionality
Goto Forum:

Current Time: Wed Aug 23 22:12:18 CDT 2017

Total time taken to generate the page: 0.11626 seconds