Cloud ERP

Transfers Orders are used in Oracle Fusion SCM for the intercompany material transfers, similar to the Internal Requisition/Internal Sales Order process in the Oracle EBS. No cost markup for the material transfers within the BU. Across the Business Units/Legal entities, Transfer Pricing policies can be setup based on the Cost Plus markup / List Less … Read more

Most of the businesses have requirement to get Indented BOM (Bill of Material) export of the assembly into the excel to validate the bill of material/item structure for the Engineering Change Request/Change Order changes, impacted Work orders/Sales orders etc., This is much needed for ETO (Engineer to Order) and CTO (Configure to Order) model items. … Read more

Here is the Item extract SQL which i used for the item data analysis and item updates thru FBDI. SELECT ESI.INVENTORY_ITEM_ID,ESI.ORGANIZATION_ID,ESI.ITEM_NUMBER,IOP.ORGANIZATION_CODE INV_ORG,— EIC.ITEM_CLASS_ID,EIC.ITEM_CLASS_NAME ITEM_CLASS,ESI.ITEM_TYPE ITEM_TYPE,(SELECT MEANINGFROM FND_LOOKUP_VALUES_VLWHERE LOOKUP_TYPE = ‘EGP_ITEM_TYPE’AND lookup_code = ESI.ITEM_TYPE) User_Item_type,ESI.PRIMARY_UOM_CODE PRIMARY_UNIT_OF_MEASURE,— ESI.WIP_SUPPLY_TYPE BUILD_IN_WIP,ESI.BUILD_IN_WIP_FLAG BUILD_IN_WIP,ESI.COSTING_ENABLED_FLAG COSTING_ENABLED,ESI.INVENTORY_ASSET_FLAG INVENTORY_ASSET_VALUE,DECODE (ESI.WIP_SUPPLY_TYPE,1, ‘Push’,2, ‘Assembly Pull’,3, ‘Operation Pull’,4, ‘Bulk’,5, ‘Vendor’,6, ‘Phantom’) PIM_SUPPLY_TYPE,(SELECT MEANINGFROM FND_LOOKUP_VALUES_VLWHERE LOOKUP_TYPE = ‘EGP_SERIAL_NUMBER_CONTROL_TYPE’AND … Read more

Problem: For the Global Order Promising Assignment Set, We have Item and Organization, Category and Organization, Category & Global level sourcing assignments. The global level sourcing rule was setup to source from multiple suppliers based on the priority. Some reason sales orders were processed as drop ship orders when the warehouse wasn’t entered at the … Read more

Here are the some commonly used SQLs/Tables in the Fusion SCM Cloud applications for implementation and support resources. This will help to understand the enterprise structure, setting up custom lookup and base tables in the SCM modules etc., 1. Business Units: Business Unit is nothing but operating unit in Fusion applications — Business UnitsSELECT * … Read more

Here is another SQL Which I extensively used to validate the price list conversions in the OM Cloud implementations and getting the price list(s) export from the Fusion SCM Applications. SELECT qplt.name “Price List”,qplt.price_list_type_code,qplt.currency_code Currency,qplt.start_date,qplt.end_date,qplt.description,qplt.org_id Business_Unit_ID,qplt.status_code Status,— qpli.price_list_item_id, qpli.price_list_id,qpli.item_level_code,(SELECT item_number FROM fusion.egp_system_items esi WHERE esi.inventory_item_id = qpli.item_id AND esi.organization_id=300000007099064) “Item”, — Master Org Id(SELECT unit_of_measure … Read more

Below is the SQL to get sales order export from Fusion Apps Order Mgmt Cloud. Please use Oracle Transaction Business Intelligence (OTBI) Data model (SQL) and Report to create the report. I have used the script extensively to validated the converted Sales Orders. SELECT (SELECT name FROM fusion.hr_operating_units where organization_id = h.org_id) BU_NAME,h.order_number,h.SOURCE_REVISION_NUMBER revision_NUM, — … Read more

The main cloud deployment models are public cloud, private cloud, hybrid cloud and multi cloud.  Public cloud: Public clouds are the most common way of deploying cloud computing. The cloud resources (like servers and storage) are owned and operated by a third-party cloud service provider and delivered over the Internet. Oracle Cloud Infrastucture (OCI)/ AWS/Microsoft … Read more

Cloud computing is the practice of using a network of different servers that host, store, manage and process data online — in “the cloud”. Cloud computing is classified into three categories – Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS). The services automatically scale as demand increases. … Read more