How to remove accruals as of a particular date
We have a requirement where accrual balance should be set to zero if the Calculate Accruals and Balances process is run after 31st of Jan every year. Hence I have used the below piece of code.
ld_effective_date= GET_CONTEXT(EFFECTIVE_DATE,'4712/12/31 00:00:00'(date))
l_effective_cutoff_date = trunc(to_date('31/01/'||to_char(ld_effective_date,'YYYY'),'DD/MM/YYYY'))
if(ld_effective_date > l_effective_cutoff_date)
accrual = 0
This code is generating the expected value (accrual = 0) in the log file. But in the front end, it's showing the actual balance as of that date.