Skip to main content

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. 



Comments

Post a Comment

Popular posts from this blog

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...
Post a Comment
Read more

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

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",         "Ac...
Post a Comment
Read more