Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle Fusion financials - Unearned amount aging

Closed
11
Views
2
Comments
PB2022
PB2022 Rank 2 - Community Beginner
edited Apr 4, 2025 8:43AM in Oracle Analytics Publisher

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

This discussion has been closed.