Item Import Using SOAP Webservice – Oracle Fusion

Introduction:

This blog has the SOAP Webservice details that can be used to import the item data into Oracle Cloud application.

Cause of the issue:

Business wants to integrate their supplier system which provides the raw item for their manufacturing purpose. So, whenever there is a new item created in supplier system, business wants to create them in Oracle Cloud as well.

How do we solve:

Oracle provides a SOAP webservice which can be used to import the items in Oracle Cloud in the form of payload. SOAP responds with import status and error details in case of failure. Below is the sample payload used to import the items.

Service WSDL URL: https://servername/fscmService/ItemServiceV2?WSDL

Method: POST

Sample Request URL: https://xx.oraclecloud.com:443/fscmService/ItemServiceV2

Sample Request Body:

<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/” xmlns:item=”http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/” xmlns:cat=”http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/itemSupplier/categories/”

xmlns:item1=”http://xmlns.oracle.com/apps/scm/productModel/items/flex/itemRevision/”

xmlns:cat1=”http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/itemRevision/categories/”

xmlns:cat2=”http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/categories/”

xmlns:item2=”http://xmlns.oracle.com/apps/scm/productModel/items/flex/item/”

xmlns:item3=”http://xmlns.oracle.com/apps/scm/productModel/items/flex/itemGdf/”

xmlns:mod=”http://xmlns.oracle.com/apps/flex/fnd/applcore/attachments/model/”

xmlns:ns12=”http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/categories/”

xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>

<soapenv:Header/>

<soapenv:Body>

<typ:createItem>

<typ:item>

<!–Mandatory:OrganizationCode:–>

<item:OrganizationCode>ORG1</item:OrganizationCode>

<!–Mandatory:ItemClass: –>

<item:ItemClass>XX Item Class</item:ItemClass>

<!–Mandatory:ItemNumber:–>

<item:ItemNumber>Test_Item_Number_001</item:ItemNumber>

<!–Optional:ItemDescription: –>

<item:ItemDescription>Testing SOAP Integration Item 01</item:ItemDescription>

<!–Optional:UnitHeightQuantity–>

<item:UnitHeightQuantity unitCode=”IN”>0.9</item:UnitHeightQuantity>

<!–Optional:UnitLengthQuantity–>

<item:UnitLengthQuantity unitCode=”IN”>1.1</item:UnitLengthQuantity>

<!–Optional:UnitWeightQuantity–>

<item:UnitWeightQuantity unitCode=”POUNDS”>0.03</item:UnitWeightQuantity>

<!–Optional:UnitWidthQuantity–>

<item:UnitWidthQuantity unitCode=”IN”>0.9</item:UnitWidthQuantity>

<!–Optional:ListPrice–>

<item:ListPrice>2.8</item:ListPrice>

<!–Optional:ItemExtensibleFlexfieldCategoryCode: The value “XX_Item_EFF_Category” can be fetched from “Manage Extensible Flexfields” page, Code field under Category section–> <item:ItemExtensibleFlexfieldCategoryCode>XX_Item_EFF_Category</item:ItemExtensibleFlexfieldCategoryCode>

<!–Mandatory:ns12: The value “XXItemEffCategory” can be fetched from “Manage Extensible Flexfields” page, View Context page, API Name field –>

<item:ItemEffCategory xsi:type=”ns12: XXItemEFFCategory ” xmlns:ns13=”http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/contexts/”>

<ns12:ItemMiscAttributes xmlns:ns9=”http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/protectedModel/”>

<!–Mandatory:ContextCode: The value “XX Item EFF Category” can be fetched from “Manage Extensible Flexfields” page, View Context page, Context code field–>

<ns9:ContextCode>XX Item EFF Category</ns9:ContextCode>

<!–Mandatory:CategoryCode: The value “XX_Item_EFF_Category” can be fetched from “Manage Extensible Flexfields” page, Code field under Category section–>

<ns9:CategoryCode> XX_Item_EFF_Category</ns9:CategoryCode>

<!–Optional:Attribute1–>

<ns13:Attribute1>1</ns13:Attribute1>

</ns12:ItemMiscAttributes >

</item:ItemEffCategory>

</typ:item>

</typ:createItem>

</soapenv:Body>

</soapenv:Envelope>

SOAP Response:

The response will have the status code.