Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dunning letters seeded report questions on SendDunningBatchProcess report
I am new to Fusion and trying to modify the report and/or data model for the Dunning process. I see 3 issues so far:
- Account Number column is blank even though when I set up a separate query from one of the data sets, it is not missing (q_payment_history).
- The grouping/repeating section is on Location - which at least in our setup is ALWAYS the same (our city).
- The grouping doesn't surround the Customer information at the top of the report, so even if the grouping worked correctly, it would only show the customer information with the first grouping.
So I don't know if our setup is unique and the seeded report normally works for people or if someone may have a substitute report for this that they created to get around these problems. My thought was to group by Account Number so that it would put Transactions together with that customer and then show all the associated outstanding transactions/invoices.
Best Answer
-
2
Answers
-
Hi @Terri Norris - I moved your question to the Oracle Analytics Oracle Transactional Business Intelligence forum (the Fusion Data Intelligence ERP Analytics forum is for a separate product that I do not believe you are using based on the context of your post).
However, I think you may find more answers to your question in our sister forum here. OTBI is an application-agnostic tool, and the sister forum that I linked is specifically for Fusion ERP customers that use OTBI. Unfortunately, I cannot move this post to that forum, so I recommend you submit a question there too.
0 -
Thanks so much, just one missing underscore! I appreciate it very much!
2
