Home » Applications » Oracle Fusion Apps & E-Business Suite » org_organization_definitions doesnot view is not available in UAT (Oracle Apps R12)
org_organization_definitions doesnot view is not available in UAT [message #494378] Mon, 14 February 2011 01:34 Go to next message
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
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 Go to previous message
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?
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:

Current Time: Tue Sep 28 10:56:12 CDT 2021