Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Oracle Fusion financials - Unearned amount aging

In Oracle Fusion BIP, for each contract line need to implement event level bifurcation of unearned amount (Revenue amount < invoiced amount) aging calculation in FIFO sequence (here event completion date is considered) based on knock off logic.
We would need event by event comparison between fully invoiced and fully revenue recognized ,wherein the fully recognized revenue amount should be subtracted from fully invoiced amount and accumulate balance in which invoice amount at each event needs to get knocked off before the next in line invoice amount is taken for balance calculation. Once all the available invoice amounts are knocked off the balance needs to get allocated to respective aging bucket.
Answers
-
HI @PB2022
Welcome to Analytics Community.
Your question is more on Fusion end , Below forum can able to help to provide more information reg. your requirement/question
Regards,
Arjun
0 -
Hi @PB2022 ,
Please no double posting:
If you are using FDI, than the new question you posted is better placed than this.
If you are asking about how to technically achieve the logic you defined, you should provide details about your data source structure and the current template you are using.
If you are asking about how to get that logic out of Fusion itself, than what Arjun posted above applies: Fusion Apps questions are handled in a parallel forum dedicated to Fusion products, while here it's about Publisher as a technical solution (because Publisher comes with no data and can work on whatever it is sourced with).
0