Skip to main content

How to Create Items using REST API in Oracle Fusion


 Fusion Applications provide multiple ways to create Items such as
  • Using FBDI Process(File Based Data Import)
  • Using REST API
  • Using SOAP WebService
In this post, we will see the basic data elements required to create Items using REST API. 


You can find Oracle Standard Documentation at the below URL
https://docs.oracle.com/en/cloud/saas/supply-chain-management/20a/fasrp/op-fscmrestapi-resources-11.13.18.05-itemsv2-post.html

End Point:  fscmRestApi/resources/11.13.18.05/itemsV2
Method: Post
Steps in Invoking a REST API:
  1. Construct the Request URL 
  2. Set the Authentication
  3. Prepare the Request Body
  4. Submit the request 
  1.     Construct the Request URL: 
There are two parts in a Request URL.
    a.       Server 
    b.       Resource Path
 
https://<server>/<resource-path>

The server will be the URL of your Oracle Cloud service. 
 https://servername.fa.us2.oraclecloud.com 
Resource Path is the value provided in the documentation as shown below. 
/fscmRestApi/resources/11.13.18.05/itemsV2
 
 

 

Hence the Request URL will be  
https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources
/11.13.18.05/itemsV2
 
2.  Set the Authentication
 
In a REST API client, you can enter the User name and Password 
in the Authorization tab as shown below. 
 
 
3.  Prepare the Request Body 
Elements in the request body will depend on the Item Class setup and the business requirement. Below is a simple example to create a Finished Good Item.  
{
  "ItemNumber":"TQ032901",
  "ItemDescription":"Item Creation using REST API",
  "ItemClass":"Root Item Class",
  "OrganizationCode":"AQ_IMO",
  "Template":"Finished Goods",
  "PrimaryUOMValue":"Each",
  "LifecyclePhaseValue":"Production",
  "ItemStatusValue":"Active",
  "ApprovalStatusValue":"Approved"
}
 
4.  Submit the Request; 
 
Once the Request Body is saved, click on Send. 
As shown in the below screen shot, received the response status as 201(Created). 
 
 

Screen shot of the Items from Fusion Application.





 
 
 
 
 

Comments

Post a Comment

Popular posts from this blog

How to Import Items using FBDI

Creating Items using FBDI There are multiple steps involved in creating the items using FBDI. Few of the initial steps are common for all the FBDI processes. Download the FBDI sheet that matches to your environment.    Below is the location for 20A Item Import FBDI.    https://docs.oracle.com/en/cloud/saas/supply-chain-management/20a/oefsc/product-master-data-management.html#itemimport-3041  2. There are multiple tabs in ItemImportTemplate.xlsm, for the current post, Lets focus on the first tab i.e. EGP_SYSTEM_ITEMS_INTERFACE  3. Fill the data as per your business need. Attached is a template that worked in my internal instance. 4. Once the data is entered, Switch to Instructions and CSV Generation. Click on ‘Generate CSV File’ 5.        egpitemsimport.zip file will be created   6.        Select Tools à Scheduled Processes , Click on Schedule ...
Post a Comment
Read more

Steps in Invoking a REST API

Below steps are applicable for invoking all the REST API’s in Fusion. You can find more details on this process in the below link. https://docs.oracle.com/en/cloud/saas/supply-chain-management/20a/fasrp/Quick_Start.html   Construct the Request URL   Set the Authentication Prepare the Request Body  While step#3 will dependent on the REST API you are invoking, 1 and 2 remain same for all REST API calls. Construct the Request URL:   Request URL contains two paths     a.        Server     b.        Resource Path https://<server>/<resource-path> The server will be the URL of your Oracle Cloud service.   https://servername.fa.us2.oraclecloud.com   Resource Path is the value provided in the documentation as shown below.     /fscmRestApi/resources/11.13.18.05/itemsV2 Hence the Request URL will be   https://server...
Post a Comment
Read more