Presentation Title

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

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 11 i 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

Must use Personal Home Page

  177240.1 – Self Service Profile options won’t load Can’t open System Administrator – FRM-92100 – 135005.1

Monitor – Won’t open

   Metalink note 170050.1, 174820.1

Global Preferences   Jinitiator ClassID Jinitiator Version  Must match $OA_HTML/bin/ appsweb.cfg

Builder Tool Can’t Access the Database

   SQL*Net issue – 69725.1

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

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

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 Suite ERP/Workflow  Scripts  WFSUPPORT.sql

 WFDebugMailer115.zip

Notifications Don’t Deliver

 Note 172174.1

 Supptest26.wfl



ftp://oracle ftp.oracle.com/apps/patchsets/AOL/SCRIP TS/WORKFLOW/GENERIC/11i/

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

Thank you!

If you have any questions or comments please contact us: Karen Brownfield [email protected]

For free Release 11 i Tools please visit our website at: www.solutionbeacon.com