Skip to Content
0
Former Member
May 04, 2014 at 08:04 AM

Query hangs when getting apps schema objecs(Ebs R12) objects from BO Designer

34 Views

Hello Guys,

We are facing an issue on Production instance that the query given by BO support hangs when getting the objects from apps schema by login from BO designer.

We are able to get the objects from Ebs 11i instance with the same query. Below is the instances details for Ebs 11i and R12.

Ebs R12 Application Version : 12.1.3

Ebs R12 DB Version : 11.2.0.3

Ebs 11i Appl Ver : 11.5.9

Ebs 11i DB Ver : 9.2.0.5

Below is the query.

SELECT NULL, u1.owner, u1.object_name, u1.object_type, NULL

FROM all_objects u1, role_tab_privs rtp, all_tab_privs atp

WHERE u1.object_type IN ('TABLE', 'VIEW', 'SYNONYM')

AND u1.object_name LIKE '%' /* Type selection : can be empty */

AND u1.owner = rtp.owner(+)

AND u1.object_name = rtp.table_name(+)

AND u1.owner = atp.grantee(+)

AND 'SELECT' = atp.PRIVILEGE(+)

AND u1.object_name = atp.table_name(+)

AND u1.owner = 'APPS' /* Owner selection : can be empty */

UNION

SELECT NULL, asy.owner, asy.synonym_name, 'SYNONYM', NULL

FROM all_synonyms asy

WHERE asy.synonym_name LIKE '%' /* Type selection : can be empty */

AND asy.owner = 'APPS' /* Synonym Owner selection : can be empty */

ORDER BY 4, 2, 3;

Please help me out as it's very urgent. As users are unable to do transaction.

Thanks

Khan