Hi @OrangeCloud,

1. You should be able to use #NUMBER_OF_THIS_YEAR# and #NUMBER_OF_THIS_MONTH# context substitution variables in parameters. For the full list of available variables, you can go to “Context Substitution Variables” window in IEE.
   
   For the schedule, try following:

   to_timestamp(to_char(TRUNC(Last_day(sysdate))+(1/1440*1410),'DD-MON-YY HH24:MI:SS'),'DD-MON-YY HH24:MI:SS')

    

2. I don’t think this is possible. Only a simple text would work as the subject. 

Hope this helps!

Thanks @Charith Epitawatta  for confirming about Subject Line. I will use “Context Substitution Variables” .

as per F1 documentation END_OF_LAST_MONTH will bring date and time of last month. can we truncate this to use only date in report parameter?

Hi @OrangeCloud,

You won’t be able to truncate context substitution variables like you do with timestamps and dates in Oracle. However, when I called the method Context_Substitution_Var_API.Get_Client_Value__('END_OF_LAST_MONTH') , which fetches the value for END_OF_LAST_MONTH variable, directly from the database, it only showed me the date, without the time. So you should be able to use it without any truncating. 

Hope this helps!

@Charith Epitawatta now the question is how to use Context variables in Scheduling Quick Reports.

I scheduled my report with #NUMBER_OF_LAST_MONTH# and i get following error message in Application messages, Background Job runs successfully but email does not go out and Application Server Task goes into Status ‘Failed’

Insufficient privileges to export the quick report to Excel. 
Caused by: ifs.fnd.base.SystemException: Insufficient privileges to export the quick report to Excel.

I made sure context_Substitution_Var_API is granted to ifssys, but i still can’t use this api as ifssys. looks like i am missing some further permissions , will you be able to help in this regard

FYI: I used EXTRACT(MONTH FROM sysdate) and EXTRACT(YEAR FROM sysdate) in Application Server Task Parameters and that’s working without errors.
Thanks

Hi @OrangeCloud,

This could be due to some missing privileges for IFSSYS user. Please try running following SQL block as Application Owner:

BEGIN
    Installation_SYS.Grant_Ifssys(TRUE);
END;

Hope this helps!

@Charith Epitawatta thanks for replying
I am getting a different error now in the attached Excel report in my email.
 

I made sure both my report parameters are numbers (year and month) and Context_Substitution_Var_API.Get_Server_Value__('NUMBER_OF_THIS_YEAR') also returns ‘number’ for #NUMBER_OF_THIS_YEAR# and #NUMBER_OF_LAST_MONTH#

when i run quick report from IFS with same parameters it run successfully, but when i pass same parameters from Application server task , i get above error in attached excel. any hints how to resolve this.

2- I tried extract, to_char and to_number(to_char) method in parameter, no success. in these methods no email generates and my AST failed.

I can modify the report and use dates within QR but i would like to understand this feature to apply in future without modifying reports.
thanks