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
narvakumar
Messages: 1
Registered: February 2011
Location: Dubai
Junior Member

Hi,

We recently Upgraded to R12.1.3 from 11.5.10.2.

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

How to re-write the query.

Regards/Prasanth
  • Attachment: QUERY.txt
    (Size: 4.04KB, Downloaded 126 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: 2089
Registered: October 2003
Location: Riyadh, Saudi Arabia
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.

By
Vamsi
Re: View Changes in Discoverer [message #500236 is a reply to message #496191] Fri, 18 March 2011 09:27 Go to previous message
garylythgoe
Messages: 39
Registered: February 2008
Location: Cambridge UK
Member
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.

Regards,
Gary
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 Apr 19 05:14:22 CDT 2014

Total time taken to generate the page: 0.12419 seconds