Oracle Transactional Business Intelligence

Home› Oracle Analytics› Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Project Number for Payables Invoices in Journals

Received Response
21
Views
3
Comments
JMLMIII
JMLMIII ✭✭
edited May 20 in Oracle Transactional Business Intelligence

Good Day,

Where can I pull the correct project number field for payables sources?

We use 3 subject areas for our report where both Journals Real Time are mainly used:
- General Ledger - Journals Real Time
- Subledger Accounting - Journals Real Time
- Payables Invoices - Transactions Real Time

I tried using Project Number field from 'Payables Invoices - Transactions Real Time' > 'Distributions' > 'Invoice Details Distribution - Project Information' > 'Project' > 'Project Number' but some Invoice Number is only pulling NULL value while some pull a 'Project Number' but it seems incorrect as the amount is not matching with our Summary Report as the details report is getting all project number?

Removing this project number field, Summary report and this details report is matching.

Maybe you have insight.

Thank you.

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa mod

    Hi,

    Could you please share product name and version?

    Based on your reply the question can be moved to the right category, or you can be pointed to the forum covering the product you are using (if it's a Fusion product).

  • JMLMIII
    JMLMIII ✭✭

    Good Day, I am using OTBI report.

    Oracle Fusion Cloud Applications | 24A (11.13.24.01.0)

  • Gianni Ceresa
    Gianni Ceresa mod

    The question has been moved in the OTBI category. Being a "content" question, you could also consider asking in the Fusion forum if you find a matching category ( https://community.oracle.com/customerconnect ).