Oracle View Returning No Data,,,,,,,, Pls Help !

[SUbba LIngam]

oka view undi danni query cheste data emi raatle, but dani underlying SQL ni query cheste data vastundi.

This happening only in test env whereas its working fine in Dev.

 

Grants and Synonyms check chesa, everythng looks good to me.  watelse I need to take care of, wat could be the issue ?? 

[pinky123]

can you PM me the view SQL and the query you are trying to run?

[Aryaa]

It might be org specific view

You need to initialize the org in database using set org context and then run again

[SUbba LIngam]

can you PM me the view SQL and the query you are trying to run?

 

PM chesa.

[SUbba LIngam]

It might be org specific view

You need to initialize the org in database using set org context and then run again

 

  koncham artham ayyettu telugu lo cheppu bhayya 

[Aryaa]

koncham artham ayyettu telugu lo cheppu bhayya

Aa view custom view or oracle apps view like standard view
View name eyi chepta

[SUbba LIngam]

Aa view custom view or oracle apps view like standard view
View name eyi chepta

custom view. Starts with PS_EP%

[loveindia]

view join chestunna anni tables lo data unda in the other environment where it is throwing an error... I believe one table u are running it doesn't have the data related to the join critieria....

[loveindia]

Do you have select permissions on the view??? if not grant the permissions... Also look if the view is created under the same schema you are looking at...

[iTeachSAP]

Material view ayithe refresh cheyamani adugu .. Ledha nuvve refresh cheyi dev ayithe..

[Baadshah_Afdb]

Underlying SQL nuvvu dev di run chesaavemo...test env lo aa view def sarigga choosaava...