You are browsing the archive for Oracle Application Object Library.

Resend Failed/Error Workflow Notifications

 

NAME: Resend Failed/Error Workflow Notifications
SHORT CODE: FNDWF_NTF_RESEND
MODULE: Oracle Application Object Library

Description: Resend all notifications with FAILED mail status and/or FYI notifications with ERROR mail statu
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_mail_status : Notification mail status. ERROR or FAILED or blank for both
  • p_msg_type : Workflow itemtype to which message belongs to
  • p_role : Workflow notification recipient role
  • p_from_date : Notification sent on or after this date
  • p_to_date : Notification Sent on or before this date

 

Move messages from Exception to Normal Queue of Workflow Agent

 

NAME: Move messages from Exception to Normal Queue of Workflow Agent
SHORT CODE: FNDWF_MOVE_MSGS_EXCEP2NORMAL
MODULE: Oracle Application Object Library

Description: Move messages from Exception to Normal Queue of Workflow Agent
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Agent Name : Workflow Agent Name

 

Retry Errored Workflow Activities

 

NAME: Retry Errored Workflow Activities
SHORT CODE: FNDWFRET
MODULE: Oracle Application Object Library

Description: Retry Errored Workflow Activities
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_item_type : Item type to retry errored activities
  • p_item_key : Item key to retry (If blank, all item keys)
  • p_process_name : Process to which activity belongs (If blank, all processes that has activities in ERROR)
  • p_activity : Activity to retry (If blank, all activities in ERROR)
  • p_start_date : Date on or after which error occured
  • p_end_date : Date on or before which error occured
  • p_max_retry : Maximum no of retries on an activity (Default 5)
  • p_docommit : Perform commit for every 500 items processed