R12 E-Business Suite User Management New User Creation Workflow Process Fails With Error 'ORA-06550 - PLS-00302: Component 'LAUNCH_RESETPWD_WF' Must Be Declared' And No Email Notification Is Sent To The User
Last updated on OCTOBER 24, 2017
Applies to:Oracle User Management - Version 12.1.3 and later
Information in this document applies to any platform.
E-Business Suite R12 User Management, Forgot Password Workflows and Business Events issues
When creating a user via the User Management (UMX) (Internal or External Organization Contact Registration process), the user is created but the parent workflow fails with the following error:
'ORA-06550 - PLS-00302: component 'LAUNCH_RESETPWD_WF' must be declared'
No e-mail is sent to this new user with the login credentials or failure notifications.
Further review of the issue shows the following after checking the log FNDCPGSC100000.txt:
>$ grep PLS-00302 FNDCPGSC100000.txt
1, column 29:PLS-00302: component 'LAUNCH_RESETPWD_WF' must be
PLS-00302: component 'LAUNCH_RESETPWD_WF' must be declared
The FNDCPGSC log may grow in size and display the following message repeatedly:
Event Error Message: 3142: Process 'UMXREGWF/40000' has no activities waiting to receive event 'oracle.apps.fnd.umx.startaccountrequestwf'.<BR>
Wf_Engine.Event(UMXREGWF, 40000, SELF_SERVICE_ACCOUNT_REQUEST, oracle.apps.fnd.umx.startaccountrequestwf)
Applied <Patch 25449171> - ORACLE APPLICATIONS RELEASE 12.1: CPU PATCH FOR APR 2017, which contains a new version of file UMXMRGWF.wft 120.8.12010000.4.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms