PIPER-Rx
Papers
Case Reviews, Papers and PAMtutorials
After over 20+ years working with Oracle (the product, not the Company) and Oracle E-Business Suite (since Release 5) I have been lucky enough to have been involved in many organisations and a diverse range of E-Business services spanning from strategic planning to problem solving and database administration both nationally and internationally. I have visited hundreds of sites and pretty much seen it all when it comes to Applications Administration. Since the late 1990's I have spent more time sharing these learnings and have been a regular conference presenter at OAUG conferences internationally. The most popular papers and case studies I have presented are available here, as well as links to all of the PAMtutorials . I hope you find them useful!
| Case Reviews |
|---|
|
|
-
A workflow Case Review on how to lower the number of Workflow Background Processes
|
|
-
Why do I have 30 million rows in the FND_LOGINS table? (pdf)
|
|
|
| Papers on Concurrent Managers | |
|---|---|
|
|
|
| - Concurrent Managers 101 and 202 | |
|
-
How to create a long running request for use in testing
|
|
|
-
How to register a concurrent program
|
|
- Concurrent Manager Series
|
|
|
| Papers on Workflow |
|---|
|
|
| - The Hidden cost of Workflow |
| - Managing workflow as you would Accounts Receivable |
| - A better approach to OEBS workflow management |
|
-
Improving the business efficiency of OEBS workflow. Part 1 (pdf) Missing e-mail addresses
|
|
-
Improving the business efficiency of OEBS workflow. Part 2 (pdf) Validating e-mail addresses
|
|
|
|
|
| Papers - Other |
|---|
|
|
| - A business approach to Oracle E-Business Suite response time, E-to-E and SLAs |
| - Effective OEBS Application monitoring and management – latest news, views and techniques |
|
|
A number of the earlier papers were written and presented whilst I was with Quest Software. Once a paper is presented it becomes public domain. Most of these papers will also be available on various OAUG sites.
| PAMtutorials |
|---|
|
|
|
1
Usage profiling - Your OEBS Application - an introspective
|
|
2
Performance profiling - Performance profiling, managing workflow background processes
|
|
3
Database stuff for Apps Admins - Entropy antidotes (maintenance must haves for the more
technically inclined)
|
|
4
Coping with crisis - What to do when the sh#! hits the fan...
|
|
5
Concurrent Manager activity - Cunningly clairvoyant (Am I having a bad day?)
|
|
6
Workflow basics - What lurks beneath... (Workflow activity)
|
|
7
More Concurrent Managers Activity - Managing user behavior through fear and guilt
|
|
8
User Account Security - Basic security salvos
|
|
9
User Activity - Basic user activity
|
|
10
Database session statistics - Monitoring database sessions statistics
|
|
11
Intraday user and CM activity - Intraday application activity
|
|
12
More on concurrent managers - Proficiently psychic (Is bad stuff going on?)
|
|
13
More on Workflow - Business bottleneck busters (or how to make you look good)
|
|
14
Managing your OEBS customers - On top of the game
|
|
15
Customising PAM - Customising PAM
(Adding your own monitors & alerts)
|
|
16
Print Requests - Printers: (Who, What, Where and When)
|
|
17
Workflow - invalid e-mails - E-Mail address validation - (Not known at this address)
|
|
18
Specialisation rules - Getting to grips with Specialisation Rules
|
|
19
Scheduled requests - When scheduled requests go wrong
|
|
|
About PAM - All you need to know about PAM the FREE Oracle E- Business suite Application monitor.
|
|
Use of this web site and information available from it is subject to our Legal Notice and Disclaimer and Privacy Statement.
Oracle®, Oracle Applications® & Oracle E-Business Suite® are registered
trademarks of Oracle Corporation
© 2009 - 2013 G Piper All Rights Reserved
|
