Cloud ERP

Cloud ERP

Oracle Fusion 24A Upgrade – GOP didn’t honor all the sourcing assignments while scheduling the Sales Orders lines other than the Global sourcing assignment

by

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

Commonly used SQLs/Tables in Fusion SCM Cloud

by

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

Oracle Fusion Pricing Cloud – Price List Export SQL

by

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

Oracle Fusion Order Mgmt Cloud – SQL Script to get the Sales Orders export

by

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

Public Cloud vs Private Cloud vs Hybrid Cloud

by

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

Oracle Business Network or Oracle Supplier Network

by

Oracle Business Network (OBN) is a cloud-based supplier registration and messaging service provided to Oracle customers and their trading partners. For example, organizations can use OBN to automate electronic transmission of important business documents such as Purchase Orders and Invoices with their trading partners. The OBN service is hosted at https://businessnetwork.oracle.com. You will need to … Read more

Cloud Computing Service Models – IaaS, PaaS & SaaS and their Key differences

by

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