JBDC Request results

So that wasn't it (as you said). Since I had it narrowed down to the JDBC Request and it was working intermittently, I discussed it with our architect (as I have been all along this journey) and it turned out to be my SQL statement in the JDBC Request but not a quote issue. My SQL statement is now:

select HP.party_number
,HP.party_id
,HP.person_first_name
,HP.person_last_name
,HCP.phone_area_code||HCP.phone_number AS PHONE_NUMBER
,HP.email_address
,HP.address1
,HP.address2
,HP.address3
,HP.address4
,HP.city
,HP.county
,NVL(HP.state,HP.province) AS STATE
,HP.country
,HP.postal_code
,HP.party_name
,HP.party_type
from apps.hz_parties HP
,(
select *
from apps.hz_contact_points
where 1 = 1
and contact_point_type = 'PHONE'
and primary_flag = 'Y'
and status = 'A'
and owner_table_name = 'HZ_PARTIES'
) HCP
where 1 = 1
and HP.party_id = HCP.owner_table_id (+)
and rownum = 1
and HP.party_number = :partyNumber

Without the "contact points" being an in line query, anyone without a primary phone number didn't return any data. So SoapUI was working perfectly/as it should but I wasn't understanding the "messaging".

Thanks so much for your time and effort. It helped narrow it down to the real issue.

This ticket can be resolved.