@Shobana Kapyarath-Oracle SR: 4-0002154290

@Shobana Kapyarath-Oracle I did log an SR. The invoices are accounted. We do not use multi funded AR. I'm going through the items the Oracle Service team member provided. I'm starting to wonder if the issue might be around how the aging buckets were setup in fusion. I did not do that setup so I'm wondering if maybe it…

@RVohra I tried another version of what you recommended, and it worked. Your tip was very helpful. Thank you so much!!

@RVohra I created the synthetic task ID, but it cannot join to the revenue table because the synthetic task ID isn't found on the revenue table. It's only present in my custom dimension. Am I misunderstanding something?

@RVohra In your proposed option, am I joining the custom hierarchy dimension to the funding and revenue fact by both project_id and task_id?

This sounds like it would work. I'm going to give that a try and see how it goes.

Thank you! I'm going to give this a try and see how it goes.

The issue isn't with creating the custom hierarchy. I can do that. The issue is that for the converted projects, their funding/revenue rows have task -99999, so in order for me to join the custom hierarchy to the funding/revenue rows, I have to join but both the task ID and the project ID. When I do that, OAC no longer…

Thank you, both, so much!!