Project and Portfolio Management Practitioners Forum
cancel

New request /KNTA-10073

Highlighted
Ravi_Kumar
New Member.

New request /KNTA-10073

Hi,

i created a new user which is not present in a particular security group .

I am able to select validation values in new request when i am logged in with members of that security group but not able to select validation values when i am logged in with new user.

 

Exact error is as follows :

 

 

One of the tokens in the validation was unparseable. This can be caused by an invalid token name or missing data from the field the token represents. (KNTA-10073)

 

select user_id, full_name,username from ( select user_id, full_name,first_name,last_name,username,'No' rt from KNTA_USERS users where NVL(start_date, CURRENT_DATE) <= CURRENT_DATE AND NVL(end_date, CURRENT_DATE + 1) > CURRENT_DATE and user_id not in (select parameter8 from kcrt_table_entries where request_id ='[REQD.P.H_REQUEST_ID]' and parameter6 = 'Approve' and parameter7 is null) union select user_id, full_name, first_name,last_name,username,'Yes' rt from KNTA_USERS users where NVL(start_date, CURRENT_DATE) <= CURRENT_DATE AND NVL(end_date, CURRENT_DATE + 1) > CURRENT_DATE and user_id in (select parameter8 from kcrt_table_entries where request_id ='[REQD.P.H_REQUEST_ID]' and parameter6 = 'Approve' and parameter7 is null) ) where rt ='No' and ((UPPER(first_name) like UPPER('999999920' || '%') AND (first_name like upper(substr('999999920',1,2)) || '%' OR first_name like lower(substr('999999920',1,1)) || upper(substr('999999920',2,1)) || '%' OR first_name like upper(substr('999999920',1,1)) || lower(substr('999999920',2,1)) || '%' OR first_name like lower(substr('999999920',1,2)) || '%')) OR (UPPER(last_name) like UPPER('999999920' || '%') AND (last_name like upper(substr('999999920',1,2)) || '%' OR last_name like lower(substr('999999920',1,1)) || upper(substr('999999920',2,1)) || '%' OR last_name like upper(substr('999999920',1,1)) || lower(substr('999999920',2,1)) || '%' OR last_name like lower(substr('999999920',1,2)) || '%')) OR (UPPER(full_name) like UPPER('999999920' || '%') AND (full_name like upper(substr('999999920',1,2)) || '%' OR full_name like lower(substr('999999920',1,1)) || upper(substr('999999920',2,1)) || '%' OR full_name like upper(substr('999999920',1,1)) || lower(substr('999999920',2,1)) || '%' OR full_name like lower(substr('999999920',1,2)) || '%')) OR (UPPER(username) like UPPER('999999920' || '%') AND (username like upper(substr('999999920',1,2)) || '%' OR username like lower(substr('999999920',1,1)) || upper(substr('999999920',2,1)) || '%' OR username like upper(substr('999999920',1,1)) || lower(substr('999999920',2,1)) || '%' OR username like lower(substr('999999920',1,2)) || '%')))

 

Please suggest if there is any solution to that

1 REPLY
Celil
Acclaimed Contributor.

Re: New request /KNTA-10073

Hi Ravi,

It could be, you have security depend on particular security group in the token [REQD.P.H_REQUEST_ID]
Celil

IT Governance Professional
& PPM Solution Architect