Worklist Items - 0CLM_WL_ITEM fetching incomplete Deltas

[Former Member]

Hi All,

Ref: Worklist Items - 0CLM_WL_ITEM fetching incomplete Deltas

ECC6 and BI7.

I am working with this extractor and it's not extracting all the deltas from the previous day in BW.

Can anyone give me some information as to how this extract works...

Does it only fetch those worklist items which are processed/changed by the specialist??

OR

Does it need to fetch all the worklist items built/created for that day(with new runid) irrespective of whether they were processed or not??

Any inputs would be much appreciated.

Thanks

Rao

[marcelo_trein]

Hi, Rao.

When a processor processes a worklist item, it sets the flag XPROCESS_STARTED in UDM_WL_RUN_ID and only those items which are flagged will be extracted. I think this might be a reason why the extractor is not extracting entries as expected.

I hope this bit of information helps!

Regards,

M Trein

[Former Member]

Hi Trein ,

Thanks for the info. I did go through the extractor code, and it does select all the RUN_IDs= Xprocess_started=TRUE.

Everyday the 0CLM_ECC job creates the new worklist with a worklist item and a new Run ID for that day to process.

In this case if a worklist item was not processed it wont be extracted into BI system.

What about if a new Open item was added to the worklist but was not processed on that day so we wont have any record of the new open items added to the list until they get changed?

In this case the reporting on the BI side would show incomplete details??

Am still confused as to whether the extractor needs to read the whole worklist for yesterday which includes (new worklist items and the changed/processed worklist items)??

Regards

Rao

[Former Member]

Hi All,

The solution I found was to do with the timming of the ECC job - UDM_GEN_WORKLIST.

This job UDM_GEN_WORKLIST needs to run after the BW delta extraction on a daily basis.

Has anyone implemented the Collections module on ECC and BI, if so did you have the same dependency I mentioned above??

Thanks

Rao