Core Workflow - EBS (MOSC)

MOSC Banner

How to debug Workflow Notification MAIL_STATUS=FAILED

in Core Workflow - EBS (MOSC) 6 commentsAnswered ✓

Hi

We have a number of Requisition Approval Request notification that have MAIL_STATUS=FAILED in WF_NOTIFICATIONS table and user is complaining he is not receiving emails.

I logged into WF Status Monitor - I can open the notification by querying the workflow item.

I have tried the "Resend Failed/Error Workflow Notifications" concurrent program - the MAIL_STATUS changing momentarily to MAIL - then FAILED again.

Then I used "Retry" from WF Status monitor - this cancels existing notification and generates new one. The new notification (consistently) is showing with a FAILED status.

In applsys.aq$wf_notification_out.MSG_STATE=PROCESSED, RETRY_COUNT=NULL for the new notification. When I open USER_DATE.TEXT_LOB in browser I can see the entire notification.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Workflow Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center