OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » View Changes in Discoverer (Oracle Applications Release 12.1.3)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

View Changes in Discoverer [message #495638]

Mon, 21 February 2011 08:18

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 100 times)

Report message to a moderator

Re: View Changes in Discoverer [message #496191 is a reply to message #495638]

Fri, 25 February 2011 03:18

vamsi kasina
Messages: 2083
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

Report message to a moderator

Re: View Changes in Discoverer [message #500236 is a reply to message #496191]

Fri, 18 March 2011 09:27

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 15:31:03 CDT 2013

Total time taken to generate the page: 0.19826 seconds