Conflict Resolution Manager Can Not Start Due to Error ORA-01722 (Doc ID 1903831.1)
Last updated on SEPTEMBER 24, 2015
Oracle Concurrent Processing - Version 12.1.3 and later Information in this document applies to any platform.
When attempting to start the CRM manager, the following error occurs.
ERROR ----------------------- The CRM manager can not be started.
Get following error message in the manager's log:
ORA-01722: invalid number select level_value, profile_option_value from fnd_profile_options p, fnd_profile_option_values v, fnd_user u, fnd_concurrent_requests fcr where v.level_id = 10004 and v.application_id = p.application_id and v.profile_option_id = p.profile_option_id and p.profile_option_name = 'CONC_REQUEST_LIMIT' and v.level_value = u.user_id and (u.end_date >= sysdate or u.end_date is null ) and u.user_id = fcr.requested_by An error occurred in routine rxcrm_user_init.
STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Start the manager services
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