Sales Cloud to JDE integration - groovy - JDE actiontype not recognized

openidsankar

Member
Hi,

Trying to Create (also update) the JDE E1 addressbook, inputs are taken from OSC , and service call is via groovy script.

Webservice name: Customer And Contact Manager Service
Method : processCustomerAndContactV2

Code:

println " Call B4 record Update";
def processCustomerAndContactV2 =
[
processAddressBookV2:
[
addressBook:
[
businessUnit :'10000001',
entityId :'30000000',
entityName :'TsetRecord',
entityTypeCode :'C',
categoryCodesAddressBook:
[
categoryCode001 :'123',
categoryCode003 :'456',
categoryCode011 :'89',
],
electronicAddresses:
[[
actionType :'1',
//contactId :integerValue,
electronicAddress :[email protected],
electronicAddressClassificationCode :null,
electronicAddressTypeCode :'E',
messageIndicatorCode :'03'
]],
phoneNumbers:
[[
actionType :'1',
areaCode :'123',
// contactId :integerValue,
phoneLineNumber :'1',
phoneNumber :'456789',
phoneTypeCode :'W',
]],
processing:
[
actionType :'2',
processingVersion :'SA570001'
],
],
],
],
call = adf.webServices.AddresBookCreation.processCustomerAndContactV2(processCustomerAndContactV2);
println('Call: '+call);


response recieved:
Client received SOAP Fault from server : CAUSE . . . The action code entered either is not one of the following codes. Valid action codes are:
'1' - Add;
'2' - Change;
'3' - Delete;
RESOLUTION . . . Verify that the program allows the attempted action.

I am not sure why the actiontype is not recognized.

But I am able to create addressbook with this
service: RI_Address Book Manager Service
method: addAddressBook


But unable to create/update any addressbook, who's who, phone, or email address.
Can someone let me know the correct service to be used. also the Let me know why this issue occured.
 
Last edited by a moderator:
Haven't used this service yet but my initial guess would be since you are using part of segment as add and part in update in same call that might be the reason. Try to break add & update into multiple single call and check if that works. Sometimes the error message would be misleading.

Chan
 
Sure, will try that.
I have another question. In that service, the method processAddressBookV2: e m is used. But on one of the oracle documentation page i noticed processAddressBookV3 is available. What is the significance of this V2 and V3?
When consume the WSDL in SOAP UI V3 method is not available. Where can i get that V3 method.
 
Last edited by a moderator:
Hi,

Sorry to deviate from the main question but I am having tough time using the service: RI_Address Book Manager Service method: addAddressBook.

Can you please share the basic payload you used to create a AB record , I always get the MBF failed error when I try to create one.
 
Somehow figured out the issue. OsalesCloud is not parsing the WSDL properly.

I have added the processing section once the processAdddressBookV2 ends. (like the one shown below)

def processCustomerAndContactV2 =
[
processAddressBookV2:
[
addressBook:
[
electronicAddresses:
[[ ]]
phoneNumber:
[[ ]]
processing:
[ ]
]
]
//added one more processing section here
processing:
[ ]
]


It worked. Thanks a ton for you guys.



RI_Address Book Manager Service method:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:eek:rac="http://oracle.e1.bssv.JPR01000/">
<soapenv:Header/>
<soapenv:Body>
<orac:addAddressBook>
<businessUnit>1234567890</businessUnit>
<entityAddress>
<address>
<addressLine1>1234 5TH ST</addressLine1>
<city>SACRAMENTO</city>
<countryCode>US</countryCode>
<countyCode>SACRAMENTO</countyCode>
<mailingName>TESTRECORD</mailingName>
<postalCode>95814-5701</postalCode>
<stateCode>CA</stateCode>
</address>
</entityAddress>
<entityName>TEST RECORD</entityName>
<entityTypeCode>C</entityTypeCode>
</orac:addAddressBook>
</soapenv:Body>
</soapenv:Envelope>
 
Last edited by a moderator:

Similar threads

JDE integration using business function
Replies
0
Views
1K
ronbapa
Back
Top