PJM_PROJECTS_V -- 11i vs R12
I am querying pjm_projects_v (select * from pjm_projects_v) in 11i, i am able to see the results in toad by set dbms_application_info.set_client_info('84').
when i am querying the same view pjm_projects_v(select * from pjm_projects_v) in R12, i am not seeing any results. I have set dbms_application_info.set_client_info('84'), but still no results found. I have also tried apps.initialization also.
We are upgrading from 11i to R12(12.1.3).
Can anyone please help me. Am i missing something here?.
Is there any setup issue?.