Event Action

Hi @Ozge 

You can find it in the Event Actions. 

Hello Özge;What is IFS version

Hello, these data are stored as CLOB. You can find events via SQL using the query below. Your relevant event will be written in the EVENT_ID column.you can add a new dbms line for every 4000 characters.

You can use User ID instead of MAIL. or you can give more filters.

select A.*, DBMS_LOB.substr(A.ACTION_PARAMETERS, 4000,1) PART1,
DBMS_LOB.substr(A.ACTION_PARAMETERS, 4000,4001) PART2

  from fnd_event_action_tab A
 WHERE DBMS_LOB.substr(A.ACTION_PARAMETERS, 4000) LIKE '%MAIL%' OR DBMS_LOB.substr(A.ACTION_PARAMETERS, 4000,4001) LIKE '%MAIL%' 

Its most likely to be in the EVENT ACTION = PDF_REPORT_CREATED.

Emails can also be sent via command sys mail. This can be called from “execute online sql” so could be a custom menu, custom event or in the database.

Database packages/ procedures need to be called from IFS so could be from a custom event/ custom menu, scheduled database task etc.

If its in the database then you would be trying to find a custom package and not a table or view (unless there is a logging table). Usually these are named according to some easy way to find the custom packages like ‘COMPANY...’ or there is some CSR for the customisation. Otherwise you can look through DBA objects and sort through the created date as it will stand out by itself as they are not created during update times.

Hi @hhy38 ,

Thank you for your responce.

I have searched with some conditions and than I checked each one in the limited data, however I could not find it. I have just an e-mail and using the e-mail data I try to find it.

Hi @asahin ,

Thank you for your responce.

Client version is 9.0.20.0

In addition to @Alperen SQL, I like this one that lets you look at Event Actions based on some SQL Text that you know must exist in your Action definition. You can try with different alternatives in the ACTION_PARAMETER LIKE part in the WHERE clause and see if you can find what you are looking for:

SELECT EVENT_LU_NAME, EVENT_ID, FND_EVENT_ACTION_TYPE, ACTION_PARAMETERS FROM FND_EVENT_ACTION_TAB WHERE ACTION_ENABLE = 'TRUE' AND UPPER(FND_EVENT_ACTION_TYPE) <> 'MAIL' AND SYSTEM_DEFINED = 'FALSE' AND ACTION_PARAMETERS LIKE '%YOUR_TEXT_GOES_HERE%' ORDER BY EVENT_LU_NAME, EVENT_ID