Technology Stack - EBS (MOSC)

MOSC Banner

Can you edit the where clause in Administer Folders (System Administrator)

Our users want to create custom WHERE clauses when using the Folder Tools in the toolbar. A way to administer folders is using the System Administrator responsibility and navigating to Application > Administer Folders. This would provide access to the WHERE clause for a specific folder. The question is how can this WHERE clause be edited to include SQL functions such as NVL as one example, and basically write custom queries which are not created via the F11 query functionality.

We tried setting the Form/Function - Administer Folders with a parameter QUERY_ONLY=NO, but this did not seem to work (in the Form Function form!)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center