Expenses to be Authorized email notification

Hi, 

I think we can define the custom attributes in Event and call the function to get email id

PERS_COMMS_API.Get_Default_E_Mail(Company_Pers_Assign_API.Get_Direct_Sup_Person_List(:new.company_id,  :new.emp_no,sysdate, NULL, 'TRUE', NULL, NULL, 'TRUE'))

and use the same attribute in To Address field. . 

Hi 

Thanks for your response.

I tried the above but still seem to be getting the error “Mail address To field is not specified”

attached a few screenshots of my setup

can you see anything I'm missing

thanks 

Nick 

Hi Nick, 

You have done All right, just that you need to Select New value (Check box) of Company ID and Employee ID in the Event attributes. 

Thanks 

L P Reddy 

Hi L P Reddy 

That worked a treat.

Thankyou very much for your help.

Nick 

@LPREDDY,

having the same issue, need to send a notification mail to the supervisor of the employee.

when I tried your solution in the attached screen shot. I got the below error (refer to attachment)…

any idea what am I doing wrong 

Much appreciate your help 

Hi,

Sorry for Late reply. You can create an event on the Expense Header (any transactions require Manager approval like, Project time, Work Order transactions, Employee attendance, etc.)  not on company_pers_assign. 

Thanks 

L P Reddy