Table PAC_MNT_RESOURCES

Where I can see the last update information on table ?

• last_updated_date
• last_updated_by

The field are in the table, not just in the Tech Ref (v12.)

last_updated_date

last_updated_by

What is the problem?

Re Clarity 12.1.3.1361

I cannot see those fields

Any idea/solution?

Where can you not see the fields ?

In the database ?

Have you run the below statement ?

select

last_updated_by,

last_updated_date

from pac_mnt_resources

NJ

Ok, saw this post and realized that maybe it's not there -

https://communities.ca.com/thread/241692776

I guess, a trigger is the only way to achieve this. You can get the data filled in the cmn_audits table.

Please note:- although the data would not be available in the UI, it can be extracted from the db.

You can vote on this idea -

Make RESOURCE FINANCIAL INFORMATION available in Studio

Make RESOURCE FINANCIAL INFORMATION available in Studio

NJ

And this one! Resource Last Updated By Updates when Financials are Updated

Since no any update in table SRM_RESOURCES or CMN_SEC_USERS

the last_updated_date and last_updated_by from those table will be incorrect

Hi.

       You can write the process based on resource object (some logic need to include) which will capture auditing for resource financials with out writing triggers.

Thanks

Senthil

I think so for process

But no 'Resource' object for selection

Resource object is not event enabled. but some tricky logic has to include.

Could you provide more information please