1. User's Guide
  2. Working with Management Ledger Profitability
  3. Working with Management Ledger Queries and Reports
  4. Managing Smart View Queries in Management Ledger Profitability Applications
  5. Running Management Ledger Profitability Queries
  6. Running Custom Queries in Management Ledger Applications

Running Custom Queries in Management Ledger Applications

Note:

Creating Custom Smart View Queries in Management LedgerProfitability Applications describes how to create a query.

Before running a query, the database must be deployed. Although the database does not need to be calculated before running the query, results will be missing if it is not.

You can run Management Ledger queries and ddisplay the results in Oracle Smart View for Office for further analysis, validation, and editing.

To run a query and launch it in Smart View:

  1. In the Task Area, select Reporting, and then Manage Queries.

    The Queries screen is displayed, showing all existing queries for all applications for which the user is provisioned as a View User, Interactive User, Power User, or Administrator.

  2. Select the query to run.
  3. Click Arrow button or select Actions, and then select Execute Query.
  4. Smart View opens with query results.