Issue While Getting CustomerAccountSiteUse From FindCustomerAccount (Doc ID 2295327.1)

Last updated on OCTOBER 25, 2023

Applies to:

Symptoms

On : 11.1.11.1.0 version, Accounts, Contacts, Households


ACTUAL BEHAVIOR
---------------
Customer is using a webservice to get customer account data however the web service is returning inactive CustomerAccountSiteUse

EXPECTED BEHAVIOR
-----------------------
Customer is expecting only Active CustomerAccountSiteUse

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open SOAP UI
2. Enter WSDL link as following:

WSDL: https://<ENV>.oraclecloud.com:443/foundationParties/CustomerAccountService?WSDL
Method: findCustomerAccount

3. Use Request Payload as indicated below:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/cdm/foundation/parties/customerAccountService/applicationModule/types/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:findCustomerAccount>
<typ:findCriteria>
<typ1:fetchStart>0</typ1:fetchStart>
<typ1:fetchSize>-1</typ1:fetchSize>
<typ1:filter>
<typ1:conjunction/>
<typ1:group>
<typ1:conjunction/>
<typ1:item>
<typ1:conjunction/>
<typ1:upperCaseCompare>false</typ1:upperCaseCompare>
<typ1:attribute>AccountNumber</typ1:attribute>
<typ1:operator>=</typ1:operator>
<typ1:value>58</typ1:value>
</typ1:item>
</typ1:group>
<typ1:nested/>
</typ1:filter>
<typ1:findAttribute>CustomerAccountSite</typ1:findAttribute>
<typ1:excludeAttribute>false</typ1:excludeAttribute>
<typ1:childFindCriteria>
<typ1:fetchStart>0</typ1:fetchStart>
<typ1:fetchSize>-1</typ1:fetchSize>
<typ1:filter>
<typ1:group>
<typ1:upperCaseCompare>false</typ1:upperCaseCompare>
<typ1:item>
<typ1:upperCaseCompare>false</typ1:upperCaseCompare>
<typ1:attribute>Status</typ1:attribute>
<typ1:operator>=</typ1:operator>
<typ1:value>A</typ1:value>
</typ1:item>
</typ1:group>
</typ1:filter>
<typ1:excludeAttribute>true</typ1:excludeAttribute>
<typ1:childFindCriteria/>
<typ1:childAttrName>CustomerAccountSite</typ1:childAttrName>
</typ1:childFindCriteria>
</typ:findCriteria>
<typ:findControl>
<typ1:retrieveAllTranslations>false</typ1:retrieveAllTranslations>
</typ:findControl>
</typ:findCustomerAccount>
</soapenv:Body>
</soapenv:Envelope>

4. Execute the WSDL call with the request payload above.
5. check the response.
6. We do see that CustomerAccountSiteUse is returned for both active and inactive ones.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users get inactive CustomerAccountSiteUse which shouldn't be visible for business as its soft-deleted.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.