I have an integration in Oracle Integration Cloud witch call a webservice to create a PartySite by merging process.
Webservice: /crmService/FoundationPartiesOrganizationService
When OIC tries to invoke merge operation in this WS, it throws the following error:
{
"type" : "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1",
"title" : "oracle.jbo.ReadOnlyAttrException",
"detail" : "\n 300000047564499\n 300000041611164\n 300000047598908\n DUX1000757-2\n 2024-04-09\n 24574-990\n ECCO EMBALAGENS ADDRESS\n HZ_WS\n ",
"o:errorCode" : "27008"
}
In Oracle Integration Fault payload i have error details:
Fault:<soap-env:Fault xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"><faultcode xmlns:faultsrc="http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/applicationModule/">faultsrc:ServiceException</faultcode><faultstring>JBO-27008: Attribute LocationId in view object PartyEO_PartySite_OrganizationPartyVOToPartySiteVO_PartySiteVO cannot be set.</faultstring><detail><ICSfaultVar> <tns:ServiceErrorMessage xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xsi:type="tns:ServiceAttrValErrorMessage"> <tns:code>27008</tns:code> <tns:message>JBO-27008: Attribute LocationId in view object PartyEO_PartySite_OrganizationPartyVOToPartySiteVO_PartySiteVO cannot be set.</tns:message> <tns:severity>SEVERITY_ERROR</tns:severity> <ns2:sdoObject xmlns:ns2="http://xmlns.oracle.com/adf/svc/errors/" xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/" xmlns:ns7="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/partySite/" xmlns:ns5="http://xmlns.oracle.com/apps/cdm/foundation/parties/contactPointService/" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xsi:type="ns1:PartySite"> <ns1:PartySiteId>300000047564499</ns1:PartySiteId> <ns1:PartyId>300000041611164</ns1:PartyId> <ns1:LocationId>300000047598908</ns1:LocationId> <ns1:PartySiteNumber>DUX1000757-2</ns1:PartySiteNumber> <ns1:StartDateActive>2024-04-09</ns1:StartDateActive> <ns1:Mailstop>24574-990</ns1:Mailstop> <ns1:PartySiteName>ECCO EMBALAGENS ADDRESS</ns1:PartySiteName> <ns1:CreatedByModule>HZ_WS</ns1:CreatedByModule> </ns2:sdoObject> <tns:exceptionClassName>oracle.jbo.ReadOnlyAttrException</tns:exceptionClassName> <tns:attributeName>LocationId</tns:attributeName> <tns:objectName>OrganizationAM.PartyEO_PartySite_OrganizationPartyVOToPartySiteVO_PartySiteVO</tns:objectName> </tns:ServiceErrorMessage> </ICSfaultVar><reason>CASDK-0033: Received a SOAP fault while invoking endpoint target: https://fa-ewmj-test-saasfaprod1.fa.ocs.oraclecloud.com:443/crmService/FoundationPartiesOrganizationService. This indicates a processing exception on the service endpoint side. Please check service side logs to further diagnose the problem <![CDATA[ Fault Code : env:Server Fault String : JBO-27008: Attribute LocationId in view object PartyEO_PartySite_OrganizationPartyVOToPartySiteVO_PartySiteVO cannot be set. Fault Details : <tns:ServiceErrorMessage xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="tns:ServiceAttrValErrorMessage"> <tns:code>27008</tns:code> <tns:message>JBO-27008: Attribute LocationId in view object PartyEO_PartySite_OrganizationPartyVOToPartySiteVO_PartySiteVO cannot be set.</tns:message> <tns:severity>SEVERITY_ERROR</tns:severity> <ns2:sdoObject xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns5="http://xmlns.oracle.com/apps/cdm/foundation/parties/contactPointService/" xmlns:ns7="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/partySite/" xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns2="http://xmlns.oracle.com/adf/svc/errors/" xsi:type="ns1:PartySite"> <ns1:PartySiteId>300000047564499</ns1:PartySiteId> <ns1:PartyId>300000041611164</ns1:PartyId> <ns1:LocationId>300000047598908</ns1:Loc:Application Error</reason><operation>mergeOrganization</operation><request_payload/></detail></soap-env:Fault>
This “locationId” is used for a relationship between Location response (in another WS) and Oragnization PartySite. Sometimes when a send a request it goes successfully with no errors but otherwise the service trhows the erros described above, what could be happening?