PIPER-Rx - Free Reports

PIPER-Rx
Oracle E-Business Suite Resource Centre

Free Reports

This page contains Reports in TOAD® for Oracle Reports Manager format so you will need a licenced copy of TOAD® for
Oracle to proceed. TOAD® can be obtained from your local Quest Software distrubutor or the Quest Software site.

Initially all reports posted to this site will be fairly simple and therefore provided FREE, that's right FREE, no charge, gratis, to all OEBS professionals who agree to our terms and conditions. Please also refer to our Legal Notice and Disclaimer. Remember all risk is yours alone!

We are keen for your feedback on any of our free reports so if you found these reports useful or you have any feedback please contact us at free_reports@piper-rx.com. There are over 50 FREE reports listed below and don't forget there are over 200 more FREE reports on every aspect of OEBS administration available to you through PAM so why not also give PAM a go?

All report examples are provided in PDF format. To view or download a file you must first agree to our terms and conditions and then if you wish to download a file rather than just view the source you will need to right click on the download link and select "save link as".

All reports are provided in the TOAD® TRD (Toad Report Definition) format so if you require assistance go to How to Import, Export & Delete TOAD® Reports.

Here's a series of links to the reporting categories our free reports are listed under to help you navigate to your area of interest even faster.... (....and dont forget to check out PAM for loads more FREE reports!)

Administration

Report ID Description Version Date Example
Download
FADM001-10 Installed Modules
1.0
Aug-10
View I agree to terms and conditions to Download

Application Accounts

Report ID Description Version Date Example
Download
FAA001-11 Active Accounts
1.1
Aug-09
View
I agree to terms and conditions to Download
FAA002-11 Aged User
1.1
Aug-09
View
I agree to terms and conditions to Download

Concurrent Requests

Report ID Description Version Date Example
Download
FCR001-11 Current Concurrent Requests Summary
1.1
Aug-09
View
I agree to terms and conditions to Download
FCR002-11 Current Concurrent Requests Detailed
1.1
Aug-09
View
I agree to terms and conditions to Download
FCR003-10 Concurrent Requests by User
1.0
Aug-09
View
I agree to terms and conditions to Download
FCR004-10 Concurrent Requests by Requestor Processing Time
1.0
Aug-09
View
I agree to terms and conditions to Download
FCR005-10 Concurrent Program Runtimes by Executions
1.0
Aug-09
View
I agree to terms and conditions to Download
FCR006-10 Concurrent Program Runtimes byTotal Runtime
1.0
Aug-09
View
I agree to terms and conditions to Download
PRXCMS-001 Concurrent Manager List
1.0
Mar-12
View
I agree to terms and conditions to Download
PRXCMS-002 Scheduled Requests
1.0
Mar-12
View
I agree to terms and conditions to Download

Other

Report ID Description Version Date Example
Download
FOT001-11 Attribute Naming
1.1
Aug-09
View
I agree to terms and conditions to Download
FOT002-10 Invalid Objects (all)
1.0
Aug-09
View
I agree to terms and conditions to Download
FOT002-10 Invalid Objects (OEBS object only)
1.0
Aug-09
View
I agree to terms and conditions to Download
FDBA001-10 Patch Details
1.0
Jun-10
View
I agree to terms and conditions to Download
FDBA002-10 Index Rebuilds
1.0
Jan-11
View
I agree to terms and conditions to Download

Performance

Report ID Description Version Date Example
Download
FPF001-11 Application Performance (simple measure)
1.1
Aug-09
View
I agree to terms and conditions to Download

User Activity

Report ID Description Version Date Example
Download
FUA001-11 Active Full Service Connections
1.1
Aug-09
View
I agree to terms and conditions to Download
FUA002-11 Active Self Service Connections
1.1
Aug-09
View
I agree to terms and conditions to Download
FUA003-10 FS User Activity by Sessions (period)
1.0
Aug-09
View
I agree to terms and conditions to Download
FUA004-10 FS User Activity by Connect Time (period)
1.0
Aug-09
View
I agree to terms and conditions to Download
FUA005-10 SS User Activity by Sessions (period)
1.0
Aug-09
View
I agree to terms and conditions to Download
FUA006-10 SS User Activity by Connect Time (period)
1.0
Aug-09
View
I agree to terms and conditions to Download
FUA007-10 SS User Activity by Page Requests (period)
1.0
Aug-09
View
I agree to terms and conditions to Download

Workflow

Report ID Description Version Date Example
Download
FWF001-11 Aged Workflows (Months)
1.1
Aug-09
View
I agree to terms and conditions to Download
FWF002-11 Aged Workflows By Workflow (Month)
1.1
Aug-09
View
I agree to terms and conditions to Download
FWF003-11 Workflow Activity By Workflow
1.1
Aug-09
View
I agree to terms and conditions to Download
FWF004-11 Workflow Details
1.1
Aug-09
View
I agree to terms and conditions to Download
FWF005-11 WF Purgable Estimate
1.1
Aug-09
View
I agree to terms and conditions to Download
FWF006-10 WF Background Processes
1.0
Sep-10
View
I agree to terms and conditions to Download

Managing Workflow Paper 2008 (Aged Workflows)

Paper Title - "Managing workflow as you would Accounts Receivable"
Report ID Description Version Date Example
Download
MWP001 Activity Counts
1.0
Nov-08
View
I agree to terms and conditions to Download
MWP002 Step 1 - WF Runtime Stats
1.0
Nov-08
View
I agree to terms and conditions to Download
MWP003 Step 2A - Aged Workflows (Months)
1.0
Nov-08
View
I agree to terms and conditions to Download
MWP004 Step 2B - Aged Workflows (Days)
1.0
Nov-08
View
I agree to terms and conditions to Download
MWP005 Step 3A - Aged Workflows By Workflow (Month)
1.0
Nov-08
View
I agree to terms and conditions to Download
MWP006 Step 3B - Aged Workflows By Workflow (Days)
1.0
Nov-08
View
I agree to terms and conditions to Download
MWP007 Step 3B - Aged Workflows By Workflow (Days)
1.0
Nov-08
View
I agree to terms and conditions to Download
MWP.zip All Reports in this group (zip)
1.0
Nov-08
 
I agree to terms and conditions to Download

Managing Workflow Paper (AUSOUG 2009)

Paper Title - "A better approach to OEBS workflow management" (Aged Workflows)
Report ID Description Version Date Example
Download
PAMAWF001-10 Workflow Activity Counts
1.0
Nov-09
View
I agree to terms and conditions to Download
PAMAWF002-10 Workflow Counts
1.0
Nov-09
View
I agree to terms and conditions to Download
PAMAWF003-10 WF Runtime Stats
1.0
Nov-09
View
I agree to terms and conditions to Download
PAMAWF004-10 Aged Workflows (Months)
1.0
Nov-09
View
I agree to terms and conditions to Download
PAMAWF005-10 Aged Workflows (Days)
1.0
Nov-09
View
I agree to terms and conditions to Download
PAMAWF006-10 Aged Workflows By Workflow (Month)
1.0
Nov-09
View
I agree to terms and conditions to Download
PAMAWF007-10 Aged Workflows By Workflow (Days)
1.0
Nov-09
View
I agree to terms and conditions to Download
PAMAWF008-10 Workflow Activity By Workflow
1.0
Nov-09
View
I agree to terms and conditions to Download
PAMAWF009-10 Workflow Notification
1.0
Nov-09
View
I agree to terms and conditions to Download
PAMAWF010-10 Workflow BG Processes
1.0
Nov-09
View
I agree to terms and conditions to Download

Note 1: All reports in this set call a stored procedure. For more in formation refer to the readme.pdf in the download

Monitoring OEBS Paper (AUSOUG 2009)

Paper Title - "Effective OEBS Application monitoring and management – latest news, views and techniques"
Report ID Description Version Date Example
Download
PRXGL_001 GL Un-posted Batches
1.0
Nov-09
View
I agree to terms and conditions to Download
PRXAA_001 Application Activity (current)
1.0
Nov-09
View
I agree to terms and conditions to Download
PRXAA_002 Application Activity (period)
1.0
Nov-09
View
I agree to terms and conditions to Download
PXRCR_001 Request Run Times (by average runtime)
1.0
Nov-09
View
I agree to terms and conditions to Download

Note 1: All reports in this set call a stored procedure
Note 2: As the GL Sets of books table structure has changed between OEBS 11i and 12, two (2) procedures have been provided, one for OEBS 11i and one for OEBS 12
For more in formation refer to the readme.pdf in the download