Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Project Number for Payables Invoices in Journals
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.
Answers
-
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).
0 -
Good Day, I am using OTBI report.
Oracle Fusion Cloud Applications | 24A (11.13.24.01.0)0 -
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 ( ).
1
