Fusion

Recovering Deleted Shipment History in Fusion SCP; Target Refresh vs Net Change

Introduction/ Issue:  To reload all existing shipment history into Fusion that was deleted when the Load Planning Data from Flat Files process was run in Target mode instead of Net…

Read More

Assembly and Component Items Demand Shortage Report in Fusion SCP

Introduction/ Issue: Developing a BIP report in Fusion to identify component demand shortages for assembly items and improve supply planning decisions. Why we need to do / Cause of the…

Read More

How a Redwood Page differs from a Classic ADF page

Introduction:     Redwood Pages and standard ADF pages represent two different approaches to building user interfaces within Oracle applications. While standard ADF pages have traditionally been used to develop enterprise-grade web applications…

Read More

Query to get vendor master with missing GST Numbers report in fusion.

SELECT Qry_rslt.”Supplier Name”       ,Qry_rslt.”Supplier Number”   ,Qry_rslt.”Supplier Site Name”   ,Qry_rslt.”Supplier Status”   ,Qry_rslt.”Inactive Date”   ,Qry_rslt.”Procurement Business Unit”   ,Qry_rslt.”Currency”   ,Qry_rslt.”Total Amount”   ,Qry_rslt.”No Data…

Read More

Reporting Currency Vs Translation In Oracle Fusion

Introduction/ Issue: Organizations operating across multiple countries and currencies require accurate financial reporting in more than one currency. In Oracle Fusion Financials, finance teams often face confusion between Reporting Currency…

Read More

How AI helps in Oracle Fusion Financials

Introduction/ Issue:    Modern finance teams using Oracle Fusion Financials deal with large transaction volumes, tight close timelines, compliance pressure, and growing expectations for real-time insights. Traditional rule-based processes and…

Read More

Load Sales Forecast into plan without running the plan Upload

Prepare the DPForecasts.csv file The file name should not be changed. Date format must be “YYYY/MM/DD”. If part number has leading zeros, then change the cell to Text. Enter the…

Read More

Add History for a new Item or new Item-Customer

Make sure the new item/customer/customer site is collected and exists in Oracle cloud. Prepare the ShipmentHistory_SI_RD.csv file to load Shipments History data for the new item/new item-customer. File name should…

Read More

Creating Zero Amount Payments in Oracle Fusion Payables

Introduction/ Issue:  In Oracle Fusion Payables, there are scenarios where invoices get fully adjusted through credit memos, prepayments, or rounding adjustments. Although the invoice balance becomes zero, the invoice may…

Read More

Web Services : SOAP, REST Services

Web Services : SOAP, REST Services Introduction: Web Services are services offered over the web that enable communication between different applications. They allow systems built on different technologies, platforms, or…

Read More