Conflict Resolution Manager Can Not Start Due to Error ORA-01722 (Doc ID 1903831.1)

Last updated on SEPTEMBER 24, 2015

Applies to:

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.

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.

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