Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Include Query or Show Query Option is disabled in Save Folder Screen

Srinath MushamApr 20 2020 — edited Feb 9 2021

Hi Team,

Include Query or Show Query Option is disabled in Save Folder Screen for Sales Order Line Items Tab.

I have enabled the below profile options at User level still include query or show query is disabled.

Folder:Allow Customization

OM: Administer Public Queries

Could you please let us know how to enable it.

Regards

Srinath

Comments

fac586
Answer

van Baal HR wrote:

I want to query the APEX data dictionary for the pages I have created. The authorisation concept here dictates, that the pages created with APEX, must be granteable to roles and therefore I need to query the dictionary. Unfortunately I do not know what tables to access. Some stay empty, even when I connect to the database as DBA

Does anybody have a tip, what I can do here?

Many of the APEX views contain restrictions based on the database user being the parsing schema for the application, or a schema associated for the workspace. Some are dependent on being queried from an active APEX session.

The views can be interactively explored using the APEX Views utility in the Application Builder, and the dictionary is extensively documented in the APEX_DICTIONARY metadata view:

select * from apex_dictionary where apex_view_name = '<view name>'

Marked as Answer by van Baal HR · Sep 27 2020
van Baal HR

The query, that gave me the wanted information is:

SELECT *

  FROM apex_application_pages

WHERE application_id = 103

1 - 2

Post Details

Added on Apr 20 2020
1 comment
92 views