Oracle Transactional Business Intelligence

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

USE OTBI TO CREATEPROJECT REPORT DEPEND ON AP

Received Response
71
Views
4
Comments

I NEED TO CREATE OTBI REPORT FOR PROJECT

PROJECT NAME,SUM INVOICE,SUM PAYMENTS,UNPAID AMOUNT

Tagged:

Answers

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    You should be able to get this information from the Payables Invoices - Installments Real Time Subject Area

  • Nicolas_Trojack
    Nicolas_Trojack Rank 1 - Community Starter

    Where is Project Name in that?

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    Hi Nicolas,

    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.

  • ghrbia
    ghrbia Rank 1 - Community Starter

    project name is not segment , is a name of project from oracle project