processSalesOrder BSSV fails with NullPointerException

Hi, all,

Firstly, the config - JDE 8.12, Toolset 8.98.1.4, WebLogic BSSV server.

I am trying to get the processSalesOrder web service (J4200010) to create a Sales Order for me in the PY environment. I have made sure I have basic web service capability - both getSalesOrder and getAddressBook work.

processSalesOrder fails, and returns an XML message reporting a NullPointerException. Log and Debug log show nothing about this, it seems the BSSV runs and does a bit of processing, before failing. I am only providing the bare minimum of input values ("A" for the action type, the same version as the customer uses for their main SO entry, AN8's for SoldTo, ShipTo, and a single ITM item number).

Has anyone been able to create Sales Orders through the processSalesOrder service?

Regards,
Tony

Tony,
Null pointer is thrown directly by the XML parser so you wont find any trace of it in JDE logs. You will have to set nillable all rest of the parameters which you wont use(this is a very big list) . String are fine if they go blank but you will have to take care of Number & date fields in the section you are using for input.
I dont have a sample XML handy but if youa re not able to let me know and i can make one for you.

Chan

In order to pass null values to the business service you have to add declaration to the Envelope
<font class="small">Code:</font><hr /><pre>xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
</pre><hr />

and to the and pass null value to each tag
<font class="small">Code:</font><hr /><pre><childtag1 xsi:nil="true" /> </pre><hr />

here is an example
<font class="small">Code:</font><hr /><pre><soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://oracle.e1.bssv.JP560123/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:ItemMasterAddElement>
<typ:inputItemsCollection>
<typ:unitofMeasureWeight xsi:nil="true" />
<typ:groupWarehouseProcess1 xsi:nil="true" />
<typ:levelPurchasePrice xsi:nil="true" />
<typ:salesCatalogSection xsi:nil="true" />
<typ:salesCategoryCode8 xsi:nil="true" />
<typ:salesCategoryCode6 xsi:nil="true" />
<typ:searchText>TEST</typ:searchText>
<typ:segment7 xsi:nil="true" />
<typ:segment2 xsi:nil="true" />
<typrderRepriceCategory xsi:nil="true" />
<typ:unitofMeasurePrimary xsi:nil="true" />
<typ:template xsi:nil="true" />
<typ:repriceBasketPriceCategory xsi:nil="true" />
<typ:bulkPackedFlag xsi:nil="true" />
<typ:buyerNumber xsi:nil="true" />
<typ:unitofMeasureVolume xsi:nil="true" />
<typ:segment3 xsi:nil="true" />
<typ:salesCategoryCode5 xsi:nil="true" />
<typ:groupWarehouseProcess3 xsi:nil="true" />
<typ:methodKitConfiguratorPricing xsi:nil="true" />
<typ:unitofMeasureShipping xsi:nil="true" />
<typ:bestBeforeDefaultDays xsi:nil="true" />
<typ:salesCategoryCode7 xsi:nil="true" />
<typlannerNumber xsi:nil="true" />
<typ:userLotDate2DefaultDays xsi:nil="true" />
<typ:segment5 xsi:nil="true" />
<typ:categoryGL>UT03</typ:categoryGL>
<typ:stockingType>S</typ:stockingType>
<typ:segment4 xsi:nil="true" />
<typ:subSection xsi:nil="true" />
<typ:carrierNumber xsi:nil="true" />
<typ:unitofMeasureSecondary xsi:nil="true" />
<typ:levelInventoryCost xsi:nil="true" />
<typurchasingEffectiveDays xsi:nil="true" />
<typ:itemMasterVersion>AAGMA0001</typ:itemMasterVersion>
<typ:descriptionLine2>TESTTTT</typ:descriptionLine2>
<typrintMessage xsi:nil="true" />
<typ:segment9 xsi:nil="true" />
<typ:daysShelfLifeDays xsi:nil="true" />
<typreferredCarrierPurchasing xsi:nil="true" />
<typ:lineType>S</typ:lineType>
<typ:segment8 xsi:nil="true" />
<typ:segment10 xsi:nil="true" />
<typ:commoditySubClass xsi:nil="true" />
<typ:userLotDate3DefaultDays xsi:nil="true" />
<typ:itemPool xsi:nil="true" />
<typ:userLotDate5DefaultDays xsi:nil="true" />
<typ:groupItemDimension xsi:nil="true" />
<typ:serialNumberRequired xsi:nil="true" />
<typ:lotExpiratonDateCalculationMethod xsi:nil="true" />
<typ:itemPriceGroup xsi:nil="true" />
<typ:shippingConditionsCode xsi:nil="true" />
<typ:salesCategoryCode10 xsi:nil="true" />
<typ:groupWarehouseProcess2 xsi:nil="true" />
<typ:lotEffectiveDefaultDays xsi:nil="true" />
<typ:salesCategoryCode4 xsi:nil="true" />
<typ:segment6 xsi:nil="true" />
<typ:segment1 xsi:nil="true" />
<typ:unitofMeasurePurchasing xsi:nil="true" />
<typ:commodityClass xsi:nil="true" />
<typ:lotStatusCode xsi:nil="true" />
<typ:unitofMeasureProduction xsi:nil="true" />
<typ:userLotDate4DefaultDays xsi:nil="true" />
<typ:leadtimeLevel xsi:nil="true" />
<typ:salesCategoryCode3 xsi:nil="true" />
<typ:unitofMeasureComponent xsi:nil="true" />
<typ:layerCodeSource xsi:nil="true" />
<typ:userLotDate1DefaultDays xsi:nil="true" />
<typ:commitmentDateMethod xsi:nil="true" />
<typ:secondItemNumber>TEST</typ:secondItemNumber>
<typ:cycleCountCategory xsi:nil="true" />
<typ:thirdItemNumber>TEST</typ:thirdItemNumber>
<typurchasingCategoryCode5 xsi:nil="true" />
<typ:salesCategoryCode9 xsi:nil="true" />
<typ:sellByDefaultDays xsi:nil="true" />
<typ:backordersAllowedYN xsi:nil="true" />
<typ:checkAvailabilityYN xsi:nil="true" />
<typ:unitofMeasurePricing xsi:nil="true" />
<typ:shippingCommodityClass xsi:nil="true" />
<typ:description>TEST</typ:description>
<typ:commitmentMethod xsi:nil="true" />
<typ:levelSalesBasePrice xsi:nil="true" />
</typ:inputItemsCollection>
</typ:ItemMasterAddElement>
</soapenv:Body>
</soapenv:Envelope></pre><hr />

Thanks to ONYX and Chana for the replies.

The NIL values worked, up to a point, when the NullPointerException returned. The solution to that second issue turned out to be setting the ActionType at the Detail level as well (i.e. "A" for Add in the header, and "A" for Add in the detail also).

We are now able to generate Sales Orders by invoking a Business Service. A big step forward in the process!

Regards,
Tony

Hi Tony,
Can you share all the details , how you have created this and how the integration is happening. i am looking for the similar kind of solution and we have the same requirement. I am also facing few challanges, PLease share the step by step method and the websevices code and BSFN code if any you can . I am eagarly waiting for this

Thanks in Advance.
Regards
PVD

Can you pls share the details as to what & how you are invoking Std BSSV. I mean first r u creating header & then how are you creating multiple items - pls share as much as you can
thanks - [email protected]

BSSV - Sales order process

PVD said:

Hi Tony,
Can you share all the details , how you have created this and how the integration is happening. i am looking for the similar kind of solution and we have the same requirement. I am also facing few challanges, PLease share the step by step method and the websevices code and BSFN code if any you can . I am eagarly waiting for this

Thanks in Advance.
Regards
PVD

Click to expand...

Hi PVD,

me also looking for same requirement as u asked for? are you already became an expert on same , please help me on this by providing any documents.

regards
myjde(MJ)

Hi every body,
it's difficult to now what field is NILL or not ! How can we Know them ?
We spend Long Time to test Wich one is NILL, even for other BSSV,
Is there any doc for that? A document that displaed all the fields wich are obligatory for every BSSV?

thank you for help.