Custom Event related to a custom field

Hi @ludovic.rougean 
As I understand you need to get the user who modified the record.
If so, could you please try fnd_session_api.get_fnd_user() to get the modified user.

Please refer the below community thread as well.
How to get current user in IFS to a custom field? | IFS Community

current user Ifs | IFS Community

Hi Kelum,

First of all, thanks for the tip as I will need this information as well, however my issue on a more global approach was to know how we get data from the _TAB table when the event is linked to the _CFT table.

Both tables are linked through ROWKEY ID. But ROWKEY is not a parameter we can use in a Get method. For exemple the GET_Name method required the Person_ID which is not available in the _CFT table. So i guess there is a trick somewhere. 

Hi, you may have to white a cursor get the required data by passing the PERS_CFT table ROWKEY. Basically the custom table rowkey = standard view objkey. Find below example how you can use,

SELECT person_id
FROM PERS
WHERE OBJKEY = '&NEW:ROWKEY';

Furthermore, if you required to get the user who did the changes you can use below method,

Fnd_Session_API.Get_Fnd_User;

Hope this gives you an idea of what you required.

Thanks, Br,
Shehan

Good morning and thanks again, that seemed to be a very idea !

However I get the following error message.

It seems that select statement is not accepted inside method and honestly i never saw any pre-existing exemples.