custom expression to use when scheduling an App Task

Hi @anntarr,

You are supposed to use Oracle expressions that return a date/time value as the expression. SQL statements are not allowed as a custom expression. However a function call which returns a date value can be used.

Eg:

Instead of using...

select DATE_FROM 
from IFSAPP.ACCOUNTING_PERIOD t
where t.COMPANY = '10' AND t.ACCOUNTING_YEAR = '2016'
AND ACCOUNTING_PERIOD = 1;

...the function call given below can be used:

ACCOUNTING_PERIOD_API.Get_Date_From(10,2016,1);

So I think you can create a Util package in the database and write a function to return the date as you need and then use that function as the expression. 

Following post has an example expression using Oracle expressions:

Hope this helps!