cancel
Showing results for 
Search instead for 
Did you mean: 

Null value for AUDITID in idmv_ovalue_basic_all

Former Member
0 Kudos

Dear Guru!

Please help me to understand what I did wrong.

I have IDM 7.2 SP9, Oracle11, Windows 2012 .

My goal is to find what attributes of MX_PERSON where changed after import data from SAP HCM into IDM and what previous values user had .

I run the query

select mskey, attrname, avalue, modifytime, auditid from idmv_ovalue_basic_all where mskey=59191 order by modifytime

and see that some attributes have null value for auditid column:

So I can't say that all of these attributes where changed because of HCM import job (Write HCM Employee To SAP Master).

Please help me to understand where the problem and how can I find who changed the value for parameters with AUDITID=null.

Best regards,

Natalia.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You should include these columns as well;

ChangeType (see mxi_changetype)

ValOwner (repository)

UserID ("jobid=<>", usermskey, GUI (mmc), DG (dyngrp), reconcile)

IdAudit  (This is the event task (add and del member for assignments)

ParentAuditId (AuditID of parent which last updated the attribute, not consistent)

ChangedBy (Holds the MSKEY of the user which last changed the attribute)

ExpiryTime

to make sure you get a fuller picture of the audit record.

Your selection does not cover all events and descriptions

br,

Chris

Former Member
0 Kudos

Per,

thank you for answer!

Could you please look at result of request with required fields:

Best regards,

Natalia.

Former Member
0 Kudos

Hello Natalia,

Did you get your Issue fixed. Even I see null for AUDITID and -3 in column CHANGEDBY

Thanks in advance

Ranjan

Former Member
0 Kudos

Ranjan,

Yes, repeat installation from scratch + install the latest Service Packages.

Sorry for such solution

Best regard,

Natalia.

Answers (0)