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 :: 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 1636 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: 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.

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: Fri Aug 28 21:43:22 CDT 2026