Cannot Approve Requisitions - Form Errors With "APP-PO-14142: In exception of Start_WF_Process ()- PO_REQAPPROVAL_INIT1" and "ORA-20002: 3108: Root Process Could not be Determined for Item AZNM005" (Doc ID 300745.1)

Last updated on MARCH 12, 2015

Applies to:

Oracle Purchasing - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Enter Requisition screen - POXRQERQ.fmb
***Checked for relevance on 21-Aug-2012***

Symptoms

When an Internal/purchase requisition is submitted for approval in the Enter Requisition screen in the core application with the Submit and Forward checkboxes enabled, the approval errors fails with the following error displayed on a popup error message window:

APP-PO-14142: In exception of Start_WF_Process ()- PO_REQAPPROVAL_INIT1 . Start_WF_Process:  In Exception handler:
ORA-20002: 3108: Root process could not be determined for item 'AZNM005/4527072-674547'. There may a problem with the item type selector function, or you may be required to supply a starting process name.
Cause: A SQL error has occurred in In Exception of Start_WF_Process(). The SQL error is &LSQL_ERR

Also an error occurs in the workflow with a notification to sysadmin :

ERROR
-----------------------
An Error occurred in the following Workflow.

Item Type = AZNM005
Item Key = 2933-6090
Error Name = WFENG_NOTIFICATION_PERFORMER
Error Message = 3120: Activity 'AZNM005/74533' has no performer.
Error Stack = Wf_Engine_Util.Notification_Send(AZNM005, 2933-6090, 74533, AZNM005:AZN_MS_MINMAX)
Wf_Engine_Util.Notification(AZNM005, 2933-6090, 74533, RUN)
Activity Id = 74533
Activity Label = AZN_PR_INTREQ:AZN_NA_MINMAX
Result Code = #EXCEPTION
Notification Id =
Assigned User =

Sequence of events
--------------------------------
1. Submit an internal/purchase requisition for approval from the Enter Requisition screen
2. Just after submitting the internal/purchase requisition for approval while still in the screen the error modal window appears.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms