Transcript Presentation Title

Common Pitfalls with Setting
Up and Administering Workflow
Workflow SIG
September 14, 2003
Connection Point
Karen Brownfield
[email protected]
www.solutionbeacon.com
© 2003 Solution Beacon, LLC. All Rights Reserved.
About the Presenter






25+ yrs experience in IT Industry
12+ yrs experience Oracle Applications
5 yrs experience Workflow
OAUG Board of Directors 11 years, Past President, IOUC
Pricing Council
Presenter of Training/Presentations multiple clients,
conferences
Solution Beacon is a leading provider of expert-level resources to
Government Agencies and Fortune 1000 companies specializing in the
Oracle Applications marketplace, providing leading expertise in the
following areas:
 Release 11i Upgrades/Implementations
 Oracle Apps Database Administration
 Oracle Systems Architecture
 Oracle Performance Tuning
 Oracle Workflow
© 2003 Solution Beacon, LLC. All Rights Reserved.
Workflow Administrator
 Oracle
Defaults Administrator to SYSADMIN
(the user)
 Recommend selecting Responsibility
System Administrator
Workflow Administrator
 Should add ability to run concurrent
programs
Must create Program group
 Login as SYSADMIN, System Administrator
responsibility
Workflow | Global Preferences
© 2003 Solution Beacon, LLC. All Rights Reserved.
Notifications to SYSADMIN
Notification or Routing Rules
 Forward to new Administrator
 Exceptions by workflow
 Example – HR setup messages
 Re-assign any existing notifications

© 2003 Solution Beacon, LLC. All Rights Reserved.
Vision – Notification Preference
Global Preferences,
 ‘Send me Electronic Notifications’
 Change to ‘Do not send me mail’

© 2003 Solution Beacon, LLC. All Rights Reserved.
Must use Personal Home Page
177240.1 – Self Service Profile options
won’t load
 Can’t open System Administrator –
FRM-92100 – 135005.1

© 2003 Solution Beacon, LLC. All Rights Reserved.
Monitor – Won’t open



Metalink note 170050.1,
174820.1
Global Preferences
 Jinitiator ClassID
 Jinitiator Version
 Must match
$OA_HTML/bin/
appsweb.cfg
Workflow Web Agent –
not adjusted for cloned
instance
© 2003 Solution Beacon, LLC. All Rights Reserved.
Builder Tool Can’t Access the
Database
SQL*Net issue – 69725.1
 Wrong version of Builder
 2.6.2 – patch 2610507
 Must use apps userid

© 2003 Solution Beacon, LLC. All Rights Reserved.
Notifications Don’t Deliver




Mailer not running
 Add startup/shutdown to database
startup/shutdown script
Mailer quits immediately
 Remove Shutdown file
PO only – make sure ‘Send Notifications for
Purchasing Documents’ concurrent program is
running (and restarts itself)
Make sure background engine is running
 Problems – 174207.1
© 2003 Solution Beacon, LLC. All Rights Reserved.
Notifications Don’t Deliver

If setup to work with Sendmail – validate
Sendmail setup correctly
 11i Notification Mailer Setup and Testing –
Definitive Step by Step Guide – An Oracle
White Paper
 Metalink - Top Tech Docs>E-Business
Suite-ERP> Workflow>Notification
Mailer. Under sub-heading Notification
Mailer Version 2.6X, FAQ
© 2003 Solution Beacon, LLC. All Rights Reserved.
Notifications Don’t Deliver



Validate setup
 MAPI compliant – 104197.1
 SendMail – 104198.1
 OAM – 164871.1
If person setup as employee
 Link employee to FND_USER
 Specify email in PER_ALL_PEOPLE_F record
If person not setup as employee
 Specify email in FND_USER records
© 2003 Solution Beacon, LLC. All Rights Reserved.
Notifications Don’t Deliver
Check integrity of Directory Services
 $FND_TOP/sql/WFDIRCHK.sql
 Oracle Workflows
 Performers that are Item Attributes –
Attribute has default value (see setup
in each module for which performers
must be defined

© 2003 Solution Beacon, LLC. All Rights Reserved.
Notifications Don’t Deliver

Custom Workflows
 Performer name must equal
Display_Name in WF_ROLES
 If Type=Item Attribute, type of Item
Attribute = Role
 If Type = Constant, must load from
Directory Services in Builder Tool
© 2003 Solution Beacon, LLC. All Rights Reserved.
Notifications Don’t Deliver

Top Tech Docs / e-Business SuiteERP/Workflow
 Scripts
 WFSUPPORT.sql
 WFDebugMailer115.zip
• Apply suggested patches
• Fix any errors
© 2003 Solution Beacon, LLC. All Rights Reserved.
Notifications Don’t Deliver

Note 172174.1
 Supptest26.wfl

ftp://oracleftp.oracle.com/apps/patchsets/AOL/SCRIP
TS/WORKFLOW/GENERIC/11i/
© 2003 Solution Beacon, LLC. All Rights Reserved.
ORA-600 error


Wfqclean – if on database < 8.1.5, drop user
or tablespace w/o previously running wfqed
 Symptom – ORA-600 error when recreate
queues
 Paramater – username of schema that
experiences the error
Wfqed – drops queues – run before dropping
user or tablespace
© 2003 Solution Beacon, LLC. All Rights Reserved.
Seeded Workflows Don’t work

Verify all required setups specific to
workflow are done
 Documented in each module’s users
guide
 Performers
 Timeouts
 Profile Options
 PA Account Generators
© 2003 Solution Beacon, LLC. All Rights Reserved.
Performance is Sluggish
Purge Runtime History – set purge to
repeat periodically
 Special purge needed for FAFLEXWF
– persistance type = Permanent
 Ensure ‘Abandoned’ workflows are
purged
 WFRMTYPE.sql – will end all running
copies and then purge

© 2003 Solution Beacon, LLC. All Rights Reserved.
Periodic Scripts
All in $FND_TOP/sql
 WFDIRCHK.sql
 WFREFCHK – check for invalid workflow
data that is missing primary key data
for a foreign key
 WFSTDCHK – check and report any
problems in Workflow data model

© 2003 Solution Beacon, LLC. All Rights Reserved.
Periodic Scripts
Wfverchk – identifies errors in versions
of activities that cause multiple versions
to appear to be active at once
 Wfverupd – correct problems due to
multiple versions of activities active at
same time

© 2003 Solution Beacon, LLC. All Rights Reserved.
Stuck Workflows

End node not an end node
 In Monitor must look like
not
 Resultout not set to Internal Name of
lookup type
 N or Y, not No or Yes
 Spaces between : and result
 Block Functions that don’t have
timeouts
© 2003 Solution Beacon, LLC. All Rights Reserved.
Metalink Notes

Top Tech Docs – e-Business Suite:ERP –
Workflow
 All Sections - Oracle Workflow
Troubleshooting/Resolution Flow Chart
(Embedded WF 2.6)
 Diagnostics – e-Business Suite Release 11i
– e-Business Suite:ERP – Application Core
Technology - Workflow
© 2003 Solution Beacon, LLC. All Rights Reserved.
Metalink Notes
A System Administrators’ Guide: Oracle
Workflow Applications 11i Workflow
 284811 – revised May 2003
 E-Business 11i – Documentation –
Workflow

© 2003 Solution Beacon, LLC. All Rights Reserved.
Thank you!
If you have any questions or comments please contact us:
Karen Brownfield [email protected]
For free Release 11i Tools please visit our website at:
www.solutionbeacon.com
© 2003 Solution Beacon, LLC. All Rights Reserved.