Skip to main content

I am wanting to schedule a quick report to run 4 days after the period end date - how is best to do this please ?

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

@JannetteC  

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


Terms & ConditionsCookie settings