Skip to main content

Posts

Outside Processing-1

Introduction: In manufacturing an assembly, organizations could run into scenarios where one or more operations are performed by an external supplier. Though these operations could vary by industry some examples are Powder Coating, Color blasting etc. In an outside processing scenario, a Semi-Finished assembly is sent to the supplier. Below are the high-level steps in Outside Processing Flow: Create an Outside Processing Service Item Create a Supplier Operation Define a Work Definition Including Supplier Operation Review Plant Parameters Create a Work Order and Release Review the Supply Orchestration Receive the Purchase Order In this first we will review the steps up to reviewing plant parameters. Create an Outside Processing Service Item Outside Processing Service Item is used in the Purchase Order line and systematically received from the supplier. This is a non-Inventory, Service item, used for tracking the Supplier services. Product Hub provides a seeded item template- Outside P
Recent posts

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

Automatic Work Definitions

Automatic Work Definition:                     As the title suggests automatic work definition is a work definition that is automatically generated by Fusion Applications. Organizations deal with manufacturing assemblies of different complexity. Certain assemblies are manufactured in multiple operations and consume different components in different operations. Certain assemblies could have a generic operations like kitting etc. This feature addresses the later in which assemblies are manufactured with generic operations. How to Create Automatic Work Definitions: Below are the high-level steps to creating Automatic Work definitions.  Define a Standard Operation Define Item Structure.  Define a Standard Operation Navigation: Supply Chain Execution-->Work Definition-->Manage Standard Operations 2. Defining Item Structure For the test case, a test assembly FB_SA_ITEM1 is considered.  From Item Details, Switch to Structures tab and from Actions, Click on Create Automatic W

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