Run the following update queries, that will update this account with the original seed data prior to upgrade. For both the queries below, only one row each should be updated. If there is more than one row being updated, do not commit.
UPDATE SRM_RESOURCES
SET LAST_NAME = 'Invalid_User',
FIRST_NAME ='PPM',
MIDDLE_NAME = NULL,
EMAIL = '
[email protected]',
SMS_EMAIL = NULL,
PERSON_TYPE =300,
USER_ID = '-99',
DATE_OF_HIRE = NULL,
DATE_OF_TERMINATION = NULL,
MANAGER_ID = NULL,
IS_ACTIVE = 0,
FULL_NAME ='Invalid_User, PPM',
IS_EXTERNAL = 0,
EXTERNAL_SOURCE_ID =1,
EXTERNAL_ID = NULL,
--RESOURCE_TYPE = NULL,
USE_IN_FRC_BUDGET =0,
SLICE_STATUS = NULL,
INCLUDE_FLAG =1,
BOOK_MANAGER_ID = NULL,
ENTITY_CODE = NULL,
FORECAST_RATE = NULL
WHERE USER_NAME = 'ppm_invalid_user';
UPDATE CMN_SEC_USERS
SET ID ='-99',
USER_NAME ='ppm_invalid_user',
PWD ='977637977634d34664e6a4833494a7a6b6943073e5ad7c4022926c5c2c9aa4b124249',
PWD_REQUIRED = NULL,
USER_STATUS_ID =202,
OBS_ID = NULL,
DESCRIPTION = NULL,
FIRST_NAME ='PPM',
MIDDLE_NAME = NULL,
LAST_NAME = 'Invalid_User',
EMAIL_ADDRESS ='
[email protected]',
SMS_EMAIL_ADDRESS = NULL,
PHOTO_FILE = NULL,
LOCALE = 'en_US',
TIMEZONE ='Europe/London',
LANGUAGE_ID =1,
COUNTRY_ID =1,
CURRENCY_CODE = NULL,
LOGIN_COUNT = NULL,
BAD_LOGIN_COUNT = NULL,
FORCE_PWD_CHANGE =1,
FULL_NAME = NULL,
COMPANY_ID =0,
EXTERNAL_SOURCE_ID = 1,
EXTERNAL_ID = NULL,
IS_LDAP =1,
USE_PROXY =0,
PROXY_USER_ID = NULL,
HOME_URL = NULL,
NAV_STATE =0,
BO_USER = NULL,
SCREEN_READER_OPT =0,
HIGH_CONTRAST_UI =0,
NO_CSRF_MSG = NULL,
SALT ='ywcM4fNjH3IJzkiC',
USER_UID = 'ppm_invalid_user'
WHERE USER_NAME = 'ppm_invalid_user';