Clarity

  • 1.  How do you audit the resource class field in the financial section of the

    Posted Mar 16, 2010 09:17 AM
    How do you audit the resource class field in the financial section of the resource profile? We are able to audit the main attritbutes within resource record however we are not sure how to enable this for resource_class.  Within the financial section there is fiancial location, department, resource class and transation class. How are these attibutes audited?


  • 2.  Re: How do you audit the resource class field in the financial section of

    Posted Mar 16, 2010 09:33 AM
    Hi,  The answer is no until 12.0.5.If iam wrong i would be very happy that i too looking for one.  we are working for our upgrade from 7.5.2 to v12.0.5 .we have an test env for v12.0.5 and found there alsono audit facility for resource financials.  Iam repeating it again -->The un authorized way is the DB trigger which is not supported by CA.so it is better to get an approval by providing valid reasons.(Business Requirements,Justifications etc).  cheers,sundar  


  • 3.  Re: How do you audit the resource class field in the financial section of

    Posted Mar 16, 2010 09:45 AM
    Hi Sundar,  Do you know what table the resource fianancials is stored?  Thanks for your reply.


  • 4.  Re: How do you audit the resource class field in the financial section of
    Best Answer

    Posted Mar 16, 2010 10:34 AM
    Hi,  It is stored in pac_mnt_resources table.  PAC_MNT_RESOURCES - This table stores the financial properties of resources.    DEPARTCODE   -The department code. This is the home department.  
    TRANSCLASS
     The transaction Class which assigned to the resource .(Always it is missed in this table under the Tech document)
     
    LOCATIONID
     The location code. It is the home location.

     RESOURCE_CLASS
     The resource class assigned to the resource. This refers to PAC_FOS_RESOURCE_CLASS.RESOURCE_CLASS.  You need to create a temp table with the below columns.Resource Id,User who had updated,Timestamp,Column Name,Modified To (Column Value).  create an db trigger which will fire whenever any one of the 4 columns (DEPARTCODE,LOCATIONID, RESOURCE_CLASS, TRANSCLASS )is modified and then the audit info will bestored in the above created temp table.you can generate it as an adhoc Report from database.Pls check withe DBA whether the trigger is working fine and not causing any performance issues.  Important --> Again before using better to get an approval by providing valid resaons.(Business Requirements,Justifications etc).  cheers,sundar