Duplicate records in OTBI while using Payables Transaction and Payables Payments subject area
Summary
We are on R13 and when we try to create a simple Invoice information along with Payments details using Payables Transaction and Payables Payments subject area, the records are duplicatedContent
I have created a report in OTBI with Payables Transaction and Payables Payments subject area with Invoice Number, Business Unit, Supplier Name, Site, Payment Status, Payment type, Invoice Amount, Paid Amount, Check Number and Gross Amount. The common dimensions are Business Unit, Supplier Name and Site. Facts chosen are Invoice Amount and Gross amount from the respective subject area. As soon as I select the Check Number from the Payables payments subject area, I am getting duplicate records where in it tries to fetch all the invoices for the vendor in the system and stamp the respective payment date. For
0