OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » org_organization_definitions doesnot view is not available in UAT

Home » Applications » Oracle Fusion Apps & E-Business Suite » org_organization_definitions doesnot view is not available in UAT (Oracle Apps R12)

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

org_organization_definitions doesnot view is not available in UAT [message #494378]

Mon, 14 February 2011 01:34

ravirajapps
Messages: 7
Registered: December 2010
Location: IN

Junior Member

Hi Friends,

We are developing 2 Reports.
Those works fine in Development Instance.
But those are not worked in UAT.
What is the problem is the org_organization_definitions view(R12)
doesn't available for me and the description(F4) is available to see
I am writing query 'select * from org_organization_definitions'
It shows table or view doesn't exist.

But, when i press F4 on the table in TOAD for description
it show the whole description of table.
and then i write a query like
'select * from apps.org_organization_definitions'

It shows no data found.

The organizations are already defined.
hr_organization_units table is having data.
But the standard view org_organization_definitions created based on hr_organization_units doesn't show any data.
how it is possible ? can any one solve my problem?
I struck here from so many days?
help me as early as possible?
And i searched in web about this it shows initialize the language
If it is the problem how to initialize UK language

Report message to a moderator

Re: org_organization_definitions doesnot view is not available in UAT [message #494480 is a reply to message #494378]

Tue, 15 February 2011 02:19

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Please read the Forum Guide.
At least both pointsQuote:

Not able to see the profile option values from back end SQL tools? Have a look at link1 and link2?
Is count(*) giving 0 rows? (Or) Isn't SELECT giving desired output?

By
Vamsi

Report message to a moderator

Previous Topic:	Suppress child-request from appearing in Oracle Concurrent Requests screen
Next Topic:	R12 Applications not getting Started on Server 2003 After Restart

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 23:22:13 CDT 2025