Enhancement Requirement for Fusion Data Intelligence (FDI): Calculation of Total Discount on Ordered

Sumanth V -Oracle

Business Context and Need:
The Procurement team relies on Fusion Data Intelligence (FDI) to analyze purchase order discounts. The subject area 'Procurement—Purchase Orders' provides critical data attributes such as:

• Discount Amount per line
• Discounted Unit Price
• Discounted Ordered Amount
• Base Price
• Based Ordered Amount

Currently, there is a significant data inconsistency in the provided attributes. While Unit Price, Base Price, and Based Ordered Amount are presented in the document currency, the Order Amount is in the analytic currency. This mismatch makes it impractical to calculate a KPI for the total discount on the ordered amount directly within FDI.

Requirement:
The Procurement team needs to view the Based Ordered Amount in analytic currency instead of document currency. This enhancement is critical to:

1. Enable accurate KPI calculations for total discounts at the order level.
2. Automate the KPI tracking within FDI to eliminate the current manual calculation process.
3. Improve reporting efficiency and reduce human error, thereby supporting better procurement decision-making.

Proposed Enhancement:
We request the development of functionality within FDI to:

• Provide the Based Ordered Amount in analytic currency within the 'Procurement—Purchase Orders' subject area.
• Enable automated calculations of total discount at the order level in analytic currency.

This enhancement would align with the business's operational needs and streamline KPI tracking for the Procurement team.

Logging it as suggested by Development in "FAW-57783".