I NEED TO CREATE OTBI REPORT FOR PROJECT
PROJECT NAME,SUM INVOICE,SUM PAYMENTS,UNPAID AMOUNT
You should be able to get this information from the Payables Invoices - Installments Real Time Subject Area
Where is Project Name in that?
Project Name is one of the GL segments for one of my implementations. So i had combined the Payables Invoices - Installments Real Time Subject Area, with the Payables Invoices - Transactions Real Time SA to create a report combining project name(from the Project subfolder, in the Accounting folder) and the ap payment metrics. However, no other Project module specific attributes can be combined into such a report. So it may not fulfill your requirement completely, especially of Project is not one of the GL segments for your implementation.
Apologies for not having shared the complete information earlier.
project name is not segment , is a name of project from oracle project