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.

For the above requirement, creating temporary table to store the accumulated balance for sequential processing is not feasible in BIP and this remains a constraint to implement the logic.

Please suggest if there is a way to implement knock off logic in BI Publisher.