Oracle Fusion Cloud SCM REST and SOAP API's to use in OIC( Oracle Integration Cloud)

-

Below is the list of ERP Fusion Cloud REST  and SOAP API's to be used in sequence for the ERP Fusion Manufacturing Flow

Item Creation 

  • https://<<hostname>>/fscmRestApi/resources/11.13.18.05/itemsV2
Item Structure (BOM : Bill of Material)
  • https://<<hostname>>/fscmRestApi/resources/11.13.18.05/itemStructures
Work Definition Creation ( GET Operation Not Supported)
  • https://<<hostname>>/fscmRestApi/resources/11.13.18.05/workDefinitionRequests
PriceList
  • https://<<hostname>>/fscmRestApi/resources/11.13.18.05/priceLists : Using this REST API, fetch the PricelistId to pass in the below REST API to create items in the ERP Fusion PriceList
  • https://<<hostname>>/fscmRestApi/resources/11.13.18.05/priceLists/{PriceListId}/child/items
Enterprise Sales Contract (SOAP API) 
  • https://<<hostname>:<<port>>/fscmService/ContractServiceV2
  1. To Create Enterprise Contract in ERP Fusion Cloud :- Operation : createContract
  2. Get Contract Details to fetch the contractHeader :- Operation : getContract
  3. Update the Adjustment Amount on the created Enterprise Contract :- Operation : mergeContract
  4. Update Contract Status into Active :- Operation : updateContractToActive

Sales Order Creation
  • https://<<hostname>>/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub

Location: Chandigarh, India

Comments

Post a Comment

Popular posts from this blog

How to give NewLine feed to the text in OIC using xslt function

-
Image
The requirement here is , if you get from the source system the text with some delimiters for e.g. here in this case the delimiter used as ## to give uniqueness and we want the text to split into new line wherever you see '##' for that we can use the \n hexadecimal code as &#10; as shown below in OIC mapping. In this case, from source system we got input as below    '(J0D) BRAZILWOOD//(WE) BRAZILWOOD##Laminate Color:(J0D) BRAZILWOOD##Edge Color:(WE) BRAZILWOOD' Now here we want to replace '##' with the new line '\n', use the below code snippet according to your use case in order send the output to the target system.         <xsl: value-of select="translate ($GlobalVarConfigDetails,'##', '&#10;' )"/> Note:- After you use this expression in the mapping, at runtime you won't be able to see the text with new line. We have to go and check the target system there you will be able to see the exact result of this funct...
Read more

ERP Fusion Cloud Cost Rollup Process using OIC via API's

-
 Cost Rollup It is a process of adding all the cost of the underlying materials to obtain the total manufacturing cost per unit. Using OIC, for this cost rollup, we have to first create the cost scenarios with the item numbers added into the same and then using the ERP ESS Scheduled job, we need to pass the Scenario Number to sum the costs i.e. Cost Rollup. Below is the Payload for creating multiple cost scenario's with the item numbers added into it.           REST API:-  /fscmRestApi/resources/11.13.18.05/costScenarios NOTE:- The structure of the below JSON payload is little bit different from the other REST API's in the ERP Fusion Cloud. While testing in POSTMAN tool, just give URL as "https://<hostname>/fscmRestApi/resources/11.13.18.05"  as we giving "/costScenarios" in the body itself and under the headers section the key as Content-Type and value as "application/vnd.oracle.adf.batch+json" { "parts" : [ { "id" : ...
Read more