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 378 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: 2112
Registered: October 2003
Location: Cincinnati, OH
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: My Group Requisitions in iProcurement
Next Topic: How Should I implement Multi Org Structure with 2 SOB for India and USA?
Goto Forum:

Current Time: Sat Sep 25 00:34:39 CDT 2021