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.

Symptoms

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

 

 



Cause

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