Oracle Fusion Data Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Not able to calculate aggregated amounts for 'Discount' Column in Purchase Order Line Detail Folder

Needs Votes
21
Views
0
Comments
Gamal
Gamal Rank 3 - Community Apprentice

We have a requirement to generate reports in FDI that display the following metrics for Purchase Orders (POs):

  1. PO amount before discount
  2. Discount amount
  3. PO amount after discount (Available)

These metrics should be available in both the document currency and the analytics currency (USD).

Specifically, we are treating the discount amount on POs as a savings measure, and require the ability to calculate the savings at various levels such as Business Unit (BU), Buyer, Department, Category, etc.

However, when using the 'Procurement - Purchase Order' subject area to create these reports, the 'Discount' column in the Purchase Order Line Detail folder only provides amounts at the line level. There is currently no functionality to aggregate these discount amounts across different levels.

This limitation prevents us from effectively analyzing and reporting on discount-related savings as required.

Please refer to SR: SR 3-37836332931 for additional context and details.

2
2 votes

Needs Votes · Last Updated