I’ll provide a comprehensive solution covering all aspects of the notification configuration issue.
1. Workflow Notification Configuration:
The workflow notification activity needs proper configuration:
a) Access the workflow designer:
- Navigate to: Application Composer > Quality Management
- Select: Quality Inspection Workflow
- Open workflow in edit mode
b) Configure notification activity:
- Locate the ‘Assign Inspection Task’ activity
- Open properties panel
- Notification Settings:
- Send Email: Yes
- Notification Type: Task Assignment
- Recipient Source: Task Assignee
- Include Worklist Link: Yes
- Priority: Normal
c) Recipient resolution:
Recipient Type: User
Resolution Method: From Task Assignment
Fallback: Role (QualityInspector)
Email Field: Primary Email Address
This ensures the notification resolves to the specific inspector assigned to the task.
2. Email Template Setup:
Create or validate the notification email template:
a) Navigate to: Setup and Maintenance > Manage Notification Templates
b) Search for: ‘Quality Inspection Task Assignment’
c) If not found, create new template:
- Template Name: Quality Inspection Task Assignment
- Template Type: Workflow Notification
- Subject: New Quality Inspection Required - {InspectionNumber}
- Body:
Dear {AssigneeName},
A new quality inspection has been assigned to you:
Inspection Number: {InspectionNumber}
Item: {ItemDescription}
Quantity: {InspectionQuantity}
Priority: {InspectionPriority}
Due Date: {DueDate}
Please access your worklist to complete this inspection:
{WorklistLink}
Thank you,
Quality Management System
d) Configure template attributes:
- Map workflow data attributes to template variables
- Ensure all referenced attributes exist in workflow context
e) Associate template with workflow:
- In workflow designer, notification activity
- Template: Select ‘Quality Inspection Task Assignment’
- Save and deploy workflow
3. Notification Service Validation:
Verify the notification infrastructure:
a) Check notification mailer status:
- Navigate to: Setup and Maintenance > Manage Workflow Notification Mailers
- Status should be: Running
- Last Run Time: Recent (within last hour)
b) Validate SMTP configuration:
SMTP Server: mail.company.com
Port: 587 (or 25)
Authentication: Enabled
From Address: noreply@company.com
TLS/SSL: As required by mail server
c) Test SMTP connectivity:
- Use ‘Test Connection’ button in mailer configuration
- Should return: ‘Connection Successful’
- If fails, check firewall rules and mail server settings
d) Review notification processing:
- Navigate to: Tools > Workflow Administrator
- Select: Notification Log
- Filter: Last 24 hours, Status = Failed
- Identify patterns in failures
4. User Profile Email Verification:
Ensure inspector profiles are correctly configured:
a) Validate email addresses:
- Navigate to: Setup and Maintenance > Manage Users
- Search for each quality inspector
- Open user profile
b) Check contact information:
- Email Address: Must be populated
- Primary Email: Should be checked/selected
- Email Type: Business (not Personal)
- Verified: Should show as verified
c) Notification preferences:
- Navigate to user profile > Preferences
- Notification Settings:
- Enable Email Notifications: Yes
- Workflow Notifications: Enabled
- Notification Frequency: Immediate
- Notification Format: HTML
d) Bulk update for multiple users:
-- Diagnostic query to find users with disabled notifications
SELECT user_name, email_address, notification_preference
FROM per_users
WHERE user_name IN (SELECT member_user_name
FROM per_role_members
WHERE role_name = 'QualityInspector')
AND notification_preference != 'ENABLED';
Use this to identify which inspectors need preference updates.
e) Enable notifications programmatically:
- Navigate to: Setup and Maintenance > Manage User Preferences
- Select: Bulk Update
- Filter: Role = Quality Inspector
- Update: Email Notifications = Enabled
- Apply changes
5. Role and Assignment Configuration:
Ensure proper role-to-user mapping:
a) Verify role membership:
- Navigate to: Setup and Maintenance > Manage Roles
- Search: QualityInspector
- View Members tab
- Confirm all active inspectors are listed
b) Check role notification settings:
- Role properties > Notification Settings
- Email Distribution: Individual (not role email)
- This ensures each inspector gets individual notifications
c) Validate assignment logic:
- In workflow, task assignment should be:
Assignment Type: User (specific inspector)
NOT: Role (inspector group)
- Role-based assignments often fail to send individual emails
6. Testing and Validation:
a) Create test inspection:
- Navigate to: Quality Management
- Create new inspection order
- Assign to specific test inspector
- Submit for workflow
b) Monitor notification delivery:
- Check notification log immediately after submission
- Expected log entry:
Notification ID: [new ID]
Recipient: test_inspector@company.com
Status: SENT
Timestamp: [current time]
c) Verify email receipt:
- Check test inspector’s email inbox
- Expected delivery time: 1-5 minutes
- Verify email content matches template
- Test worklist link functionality
d) Check worklist task:
- Login as test inspector
- Navigate to BPM Worklist
- Verify task appears with correct details
- Confirm task and worklist are synchronized
7. Troubleshooting Failed Notifications:
If notifications still fail:
a) Enable detailed logging:
- Navigate to: Setup and Maintenance > Manage Diagnostic Logging
- Component: oracle.apps.fnd.workflow.notification
- Log Level: FINEST
- Duration: 1 hour
b) Review detailed logs:
- After triggering test notification
- Download diagnostic logs
- Search for notification ID
- Identify specific failure point
c) Common issues and fixes:
Issue: “Recipient address not verified”
- Fix: Update user profile, set email as primary, save
- Run: Synchronize User Data scheduled process
Issue: “Template not found”
- Fix: Verify template name matches workflow configuration exactly
- Case-sensitive match required
Issue: “SMTP connection failed”
- Fix: Check network connectivity to mail server
- Verify authentication credentials
- Test from same server/network as Fusion instance
Issue: “Notification queued but not sent”
- Fix: Restart notification mailer service
- Check for processing backlog
- Increase concurrent mailer threads if needed
8. Performance Optimization:
For high-volume inspection workflows:
a) Configure bulk notification processing:
- Navigate to: Manage Notification Mailer Parameters
- Batch Size: 50 notifications per batch
- Processing Interval: 2 minutes
- This prevents email server overload
b) Set up notification priorities:
- High Priority: Urgent inspections (immediate send)
- Normal Priority: Standard inspections (5-minute delay acceptable)
- Low Priority: Routine inspections (15-minute delay acceptable)
c) Monitor notification queue:
- Create dashboard showing:
- Pending notifications count
- Average delivery time
- Failed notification rate
- Set alert if queue exceeds 100 pending
9. Preventive Measures:
a) Regular validation:
- Schedule monthly: “User Email Verification Report”
- Identifies users with invalid/missing emails
- Proactive correction before issues arise
b) Onboarding checklist:
- New inspector setup must include:
- Valid email address in profile
- Email marked as primary
- Notification preferences enabled
- Test notification sent and confirmed
c) Documentation:
- Maintain runbook for notification troubleshooting
- Document all configuration settings
- Include contact info for mail server admin
After implementing these configurations, your quality inspection workflow should reliably deliver email notifications to inspectors when tasks are assigned, while maintaining the tasks in the BPM worklist for tracking and management.
This draft is based on general Oracle Fusion Cloud knowledge. It has not been verified against your specific version and environment. Practitioners: verify the steps and share your experience below.