Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
