Fusion

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

Converting UTC to Local Time with DST in Oracle Integration

Working with time zones can be tricky—especially when Daylight Saving Time (DST) comes into play. This Oracle Integration recipe offers a ready-to-use solution to convert UTC into any local time…

Read More

Exporting Plan Data in Oracle Fusion Supply Chain Planning

Introduction/ Issue:  In Oracle Fusion Supply Chain Planning, planners often need to extract plan measure data from demand or supply plan layouts for reporting and analysis outside the application. Instead…

Read More