Using the Asset Management WorkCenter – Queries Pagelet
The Queries section of the Reports/Queries tab can include links to Query Manager, public queries, private queries, and actionable operational analytics (such as grids and graphs). Click on any link in the Queries pagelet to display the query or analytics in the transaction area of the WorkCenter.
The system administrator can add queries to this pagelet and determine if an end user can add public queries in Query Manager.
This example illustrates how the Queries pagelet in Asset Management WorkCenter can be set up:
The Queries group level includes these links to transaction areas:
Field or Control |
Description |
|---|---|
PO/ AM Reconciliation |
Displays a purchase order or receiver related asset, that is not an asset in AM yet. |
AP/AM Reconciliation |
Displays a voucher related asset, that is not an asset in AM yet. |
PC/AM Reconciliation |
Displays a project related asset, that is not an asset in AM yet. |
Incomplete Procurement Group |
Displays pre-interface transactions already existing in the pre-AM table longer than the number of days entered as the procurement group is incomplete. |
Asset with Inactive Chartfield |
Displays assets with inactive chartfields based on the date entered. |
Pending Depreciation Close |
Displays assets that need depreciation close run on them for the period based on a given As of Date. |
Lease Expiration |
Displays leases that will expire within the days entered. Note: This query searches for expired leases in the Asset Management tables only, it does not search the Lease Administration tables. |
Fully Depr Asset – End Depr Dt |
Displays fully depreciated assets based on the date entered and the asset’s end depreciation date. |
Asset Scan History |
Displays the entire scan history for assets, by business unit. |
Asset Scan History – Most Recent |
Displays the most recent scan history for assets, by business unit. |
The Pivot Grids group level includes these links to transaction areas:
Field or Control |
Description |
|---|---|
Acct Entry not Journal Gen |
Displays data in asset accounting entry distribution rows that have not had Journal Generator run on them yet and allows modification of filters and charts. |
Asset Acquisition by Category |
Displays data in asset acquisition costs as charts based on business unit, book and category and also allows modification of filters and charts. |
Asset Depreciation by Category |
Displays data in asset depreciation as charts by business unit, book and category and also allows modification of filters and charts . |
Asset Retirement by Category |
Displays data in asset retirement costs as charts based on business units, books and categories and allows modification of filters and charts. |
Asset Cost by Acquisition Code |
Displays data in asset costs by acquisition cost as charts based on business units and books and allows modification of filters and charts. |
The Queries pagelet can provide access to public queries, private queries, and Pivot Grids.
To set up the WorkCenter Queries pagelet as a system administrator, see Configure Pagelets – Queries Page.
To use and personalize the WorkCenter Queries pagelet as an end user, see Working With and Personalizing the Classic Queries Pagelet As an End User.