Skip to main content

Posts

Showing posts from 2020

Discrepancy in Material Quantity

In this post, We will discuss on an interesting scenario in Oracle Manufacturing Cloud Service.  Problem Statement:  Required Quantity of the component item is different when work order is created from User Interface and When created from REST API.  Explanation:  INV_QUANTITY_DECIMAL_PRECISION profile specifies the precision to which the quantities are rounded. In the POD, where we saw the discrepancy  - This profile is set to 5.  - User is creating a Work order for Assembly Quantity in 7 decimals. From the User Interface, When the user tabs out of the Quantity field, Quantity is auto adjusted as per the profile. This does not happen from user interface. 

Get Cycle Count Definitions

Hi Every one, In this post, we will review the approach to Cycle Count Details using REST API in Oracle Fusion Inventory Management Cloud Service. WebService: /fscmRestApi/resources/11.13.18.05/cycleCountDefinitions Oracle Fusion Applications documentation can be found in the below URL: https://docs.oracle.com/en/cloud/saas/supply-chain-management/20b/fasrp/op-fscmrestapi-resources-11.13.18.05-cyclecountdefinitions-get.html End Point URL: https://servername.fa.us2.oraclecloud.com:443//fscmRestApi/resources/11.13.18.05/ cycleCountDefinitions If you would like to view details for one Cycle Count, End Point URL: https://servername.fa.us2.oraclecloud.com:443//fscmRestApi/resources/11.13.18.05/ cycleCountDefinitions/{CyclecountHeaderId}

Create Structure Components-REST

Hi Every one,  In this post, we will review the approach to add components to an Item Structure using REST API in Oracle Fusion Product Life Cycle Management.  WebService:  /fscmRestApi/resources/11.13.18.05/itemStructures/{BillSequenceId}/child/Component Oracle Fusion Applications documentation can be found in the below URL:  https://docs.oracle.com/en/cloud/saas/supply-chain-management/20b/fasrp/op-fscmrestapi-resources-11.13.18.05-itemstructures-billsequenceid-child-component-post.html Endpoint URL:  https://servername.fa.us2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/itemStructures/{BillSequenceId}/child/Component Request Body:  {    "ComponentItemNumber":"AQFG1001",    "Quantity": 5,    "ItemSequenceNumber": 10,    "WipSupplyType": 2,    "Yield": 1,    "Comments": null,    "PlanningPercent": 100,    "BasisType": 1    } 

Create Item Structure- REST API

Hi Every one ,  In this post, we will review the approach to create an Item Structure using REST API in Oracle Fusion Product Life Cycle Management.  WebService:   /fscmRestApi/resources/11.13.18.05/itemStructures Oracle Fusion Applications documentation can be found in the below URL:  https://docs.oracle.com/en/cloud/saas/supply-chain-management/20b/fasrp/op-fscmrestapi-resources-11.13.18.05-itemstructures-post.html Endpoint URL: https://servername.fa.us2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/itemStructures Request Body:  {   "ItemNumber":"AQFG041120",  "OrganizationId": 300000043515825,   "AlternateBOMDesignator": "Primary",    "EffectivityControl": 1 } This REST call creates the Stucture Header;  The Bill Sequence ID returned in the response need to be passed to add Structure components.   Review the 'Create Structure Components REST' for ex

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

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