iSupport Multi Party Access:ORA-01745 Error While Trying to View Service Requests of ALL Parties When Having More Than 100 Parties Associated With the User (Doc ID 1953972.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle iSupport - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Service Request

When attempting to view service requests of ALL parties When having more than 100 parties associated with the user using multi party access feature in isupport
the following error occurs.

ERROR
-----------------------
Exception while rendering bin 1020: java.lang.Exception: java.sql.SQLSyntaxErrorException: ORA-01745: invalid host/bind variable name :ORA-01745: invalid host/bind variable name *** select /*+ first_rows */ sr.incident_id, sr.incident_number , sr.SUMMARY , sr.INCIDENT_TYPE_ID ,typet.name, sr.INCIDENT_STATUS_ID ,stat.name, sr.incident_date , sr.last_update_date ,sr.customer_id from CS_INCIDENTS_ALL_VL sr ,cs_incident_types_tl typet,cs_incident_statuses_tl stat,hz_parties p1 where sr.INCIDENT_STATUS_ID in (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57,:58,:59,:60,:61,:62,:63,:64,:65,:66,:67,:68,:69,:70,:71,:72,:73,:74,:75,:76,:77,:78,:79,:80,:81,:82,:83,:84,:85,:86,:87,:88,:89,:90,:91,:92,:93,:94,:95,:96,:97,:98,:99,:100,:101,:102,:103,:104) and sr.customer_id = :105 and typet.incident_type_id = sr.incident_type_id and typet.language = userenv('LANG') and stat.incident_status_id = sr.incident_status_id and stat.language = userenv('LANG') and p1.party_id = sr.customer_id order by upper(sr.incident_number)*** select count(*) from cs_incidents_all_vl sr where sr.INCIDENT_STATUS_ID in (:10,:21,:32,:43,:54,:65,:76,:87,:98,:109,:1110,:1211,:1312,:1413,:1514,:1615,:1716,:1817,:1918,:2019,:2120,:2221,:2322,:2423,:2524,:2625,:2726,:2827,:2928,:3029,:3130,:3231,:3332,:3433,:3534,:3635,:3736,:3837,:3938,:4039,:4140,:4241,:4342,:4443,:4544,:4645,:4746,:4847,:4948,:5049,:5150,:5251,:5352,:5453,:5554,:5655,:5756,:5857,:5958,:6059,:6160,:6261,:6362,:6463,:6564,:6665,:6766,:6867,:6968,:7069,:7170,:7271,:7372,:7473,:7574,:7675,:7776,:7877,:7978,:8079,:8180,:8281,:8382,:8483,:8584,:8685,:8786,:8887,:8988,:9089,:9190,:9291,:9392,:9493,:9594,:9695,:9796,:9897,:9998,:10099,:101100,:102101,:103102,:104103) and sr.customer_id = :105


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to isupport
2. View Service Requests


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