My Oracle Support Banner

R12 Step Down Auto Allocation Not Starting All Related Allocation Workflow Processes (Doc ID 1537074.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Project Costing - Version 12.1.3 to 12.2.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.


The PRC Generate Allocations Transactions process runs and completes without issue.
However, the Allocation Workflow processes are not getting submitted automatically and produce an error.

Example error in wfstat.sql for Item Type = PASDALOC  /  PA_AUTO_ALLOC_PROCESS :

*** Error Process Activity Statuses

Begin Date         Activity                                      Status   RESULT          User              NID Status                                
------------------ --------------------------------------------- -------- --------------- ------------ -------- --------                              
04-MAR-13 18:23:34 ROOT/DEFAULT_ERROR                            ACTIVE   #NULL                                                                      
04-MAR-13 18:23:34 DEFAULT_ERROR/START-1                         COMPLETE #NULL                                                                      
04-MAR-13 18:23:34 DEFAULT_ERROR/INITIALIZE_ERROR                COMPLETE COMPLETE                                                                    
04-MAR-13 18:23:34 DEFAULT_ERROR/DEFAULT_RESET_ERROR_NTF         ERROR    #MAIL           SYSADMIN     ######## OPEN  

**** Error Process Errored Activities

Activity                                      RESULT          Error Name                                                                              
--------------------------------------------- --------------- ------------------------------                                                          
Error Message                                                                                                                                        
Error Stack                                                                                                                                          
DEFAULT_RESET_ERROR_NTF                       #MAIL           WF_ERROR      
[WF_ERROR] ERROR_MESSAGE=3835: Error '-6508 - ORA-06508: PL/SQL: could not find program unit being called' encountered during execut                  
ion of Generate function 'WF_XML.Generate' for event ''. ERROR_STACK=                                                
Wf_Event.setMessage(, 25823297, WF_XML.Generate)                                                                      







To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.