Skip to main content

Inventory- Get All Reservations


Reservations is one of the critical business functionality in Inventory Management. Reservations provides a way to link the Supply Source to a demand source.
In the current post, We are discussing on REST API’s provided by Oracle Fusion Inventory Management Cloud Service to access/create/update Reservations.
Fusion Applications standard documentation can be accessed from the below URL.
https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/19d/fasrp/api-inventory-reservations.html
Below are the various operations available for reservations.
1.  Get all Reservation
2.  Create Reservation
3.  Delete a Reservation
4.  Get a Reservation
5.  Update a Reservation

    A.   Get All Reservations

Resource Path:

/fscmRestApi/resources/11.13.18.05/inventoryReservations

Request URL:

https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/inventoryReservations

Method: Get

Prerequisites:
Authentication user needs to have
-          Inventory Manager Role
-          Data Access for Inventory Organization.
Full Request URL: 

https://servername.fa.us2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/inventoryReservations?q=ItemNumber="MA-Std Item";OrganizationCode="INVDEN"&orderBy=DemandSourceHeaderNumber:desc

This includes below parameters
     o   Item Number
     o   Organization Code


Comments

Post a Comment

Popular posts from this blog

Technical Details- Automatic Work Definition

 Table Details:  Operations that are enabled for Automatic Work Definition can be found from the below table  WIS_STANDARD_OPERATIONS_B. Column - USED_IN_AUTO_WD_FLAG indicates whether operation is assigned to Automatic Work definition. Query1: All Standard Operations across the orgs that are used in Automatic Work Definition. select io.organization_code, standard_operation_code,used_in_auto_wd_flag, count_point_flag, auto_transact_flag from wis_standard_operations_b wsob, inv_org_parameters io where wsob.organization_id=io.organization_id and wsob.used_in_auto_wd_flag='Y'   Query2: All the automatic work definitions in the application across organizations. select io.organization_code, esi.item_number, wwd.system_generated_flag System_Generated, wwd.* from inv_org_parameters io, egp_system_items_b esi, wis_work_definitions wwd where esi.inventory_item_id=wwd.inventory_item_id and esi.organization_id=wwd.organization_id and io.organization_id=wwd.org
Post a Comment
Read more

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: Construct the Request URL   Set the Authentication Prepare the Request Body Submit the request       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 documentatio
Post a Comment
Read more

Creating Item Lots Using REST API in Oracle Fusion

Creating Item Lots Using REST API in Oracle Fusion   Oracle Fusion Inventory Management provides multiple REST API services to create the transactions and to fetch the data from Inventory Management.    Below are the steps involved in creating an Item Lot using REST API.     Construct the Request URL   Set the Authentication Prepare the Request Body For more information on Step#1 and 2, You may review my earlier post https://xplorefusion.blogspot.com/2020/03/prerequisites-in-invoking-rest-api.html   Prepare the Request Body: Elements in the request body will depend on the business requirement. Below is a simple example to create an Item Lot.   {         "OrganizationId":"300000043518896",         "InventoryItemId": 300000045573119,         "LotNumber": "SF20181208",         "ActiveLot":"Yes",         "OriginationDate":"2020-03-31T18:30:00+00:00" } Prerequisit
Post a Comment
Read more