I am wanting to schedule a quick report to run 4 days after the period end date - how is best to do this please ?
Best answer by Tracy Norwillo
View original
I have found that I can do this using the following syntax which returns a date, i also want to add the time 0600 hours is that possible ?
ifsapp.accounting_period_api.Get_Until_Date_For_Year_Period('102',ifsapp.accounting_period_api.Get_Acc_Year_Period('102'
,Add_Months(to_date('10/'||(extract(month from sysdate))||'/'||(extract(year from sysdate)),'dd/mm/yyyy'),-1))) + 4
This seems to work for me in Apps 10 assuming you’re scheduling a database task and using a custom schedule:
accounting_period_api.get_until_date_for_year_period('102',accounting_period_api.get_curr_acc_year_period('102')) + 4.25
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.