Kibana Visualization ep_po_effectiveness_Top5_suppliers Shows Incorrect Data by Summarizing Duplicate Data. (Doc ID 3072187.1)

Last updated on FEBRUARY 14, 2025

Applies to:

Symptoms

Kibana Visualization is Summarizing Duplicate Data for ep_po_effectiveness_Top5_suppliers,it is showing incorrect totals for Purchase Orders(PO) amounts.

The issue can be reproduced at will with the following steps:
1. Create a Purchase Order(PO) for quantity 10 ,price 100 and dispatch . Navigation : Purchasing > Purchase Orders > Add/Update POs.
2. Create 3 receipts for quantity of 10. Navigation : Purchasing > Receipts > Add/Update Receipts
3. Run full index for search definition ep_po_receipts_kib. Navigation : PeopleTools > Search Framework > Administration > Schedule Search Indexes
4. Go to procurement dashboards and click on Purchasing effectiveness .
5. On top suppliers visualization notice that  amount is showing as $3000 even though PO is only for $1000.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.