MSCPDCW - Planning ODS Load Worker Errors - ORA-20001: Oracle error -20002: ORA-20002: [WF_NO_USER] NAME=ABCDE123 ORIG_SYSTEM=NULL ORIG_SYSTEM_ID=NULL has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT (Doc ID 2933446.1)

Last updated on APRIL 26, 2023

Applies to:

Symptoms

After upgrading from 12.2.4 to 12.2.11
Planning ODS Load Worker errors when parameter User Company Association is set to 'Create Users and Enable User Company Association'
No Failure when parameter is set to 'Enable User Company Association'


MSCPDCW: Planning ODS Load Worker
+---------------------------------------------------------------------------+

Current system time is 02-FEB-2023 22:57:02

+---------------------------------------------------------------------------+

[02-FEB-2023 22:57:02]: **Starts**
[02-FEB-2023 22:57:03]: **Ends**
ORA-20001: Oracle error -20001: ORA-20001: Oracle error -20002: ORA-20002: [WF_NO_USER] NAME=ABCDE123 ORIG_SYSTEM=NULL ORIG_SYSTEM_ID=NULL has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT. has been detected in FND_USER_RESP_GROUPS_API.UPLOAD_ASSIGNMENT.
ORA-20001: Oracle error -20001: ORA-20001: Oracle error -20002: ORA-20002: [WF_NO_USER] NAME=ABCDE123 ORIG_SYSTEM=NULL ORIG_SYSTEM_ID=NULL has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT. has been detected in FND_USER_RESP_GROUPS_API.UPLOAD_


STEPS
NAV: Advanced Supply Chain Planner (R) / Collections /Oracle Systems/ Standard Collections - Launch the request set

Changes

Upgraded from 12.2.4 to 12.2.11

Cause

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