0CO_OM_CCA_9 delta queue is not updated even after two hours

[Former Member]

Dear experts,

I am using the above datasource to pull actual costs per cost center, when a change happens the delta queue is not updated.

Is their a special procedure to be performed or else some bug.

Please advise.

Thanks and regards

Sreedhar

[Former Member · Accepted solution]

There is no delta queue for CCA9 extractors - check the help files!

CCA9 works of a timestamp extractor with a safety limit

Normally the safety limit is 2 hours

So run it now - it will extract from previous timsetamp up to 2 hours ago

The safety procedure is to allow the large distribution and assessment loads to be committed to the database (ie you dont; loose any tranactions that are still processing through vbhdr/sm13 etc..)

You can use CCA9 in overlap mode by setting the mostrecent flag to X in the BWOMSETTINGS table (again read the help files or oss)this changes the behaviour of the safety (ie 2 hours) to work on a timestamp low - 2 hours rather than a timestamp high - 2 hours

Naturally this will involve duplication of some data - hence you have to use an ODS to resolve duplicates

But the benefit is that you getup to the minute extactions

[Former Member]

Hi,

FICO extractors will not have entries in RSA/ but will not get filled ever as its delta is triggered by pull mechanism and not push mechanism for which you find the entries in delta queue like LO extractor.

Just schedule a delta to a BW and then see your result.

you will never see a record in the delta queue here.

Also performance is always an issue with this extractor so try out note 1099307 for performance improvement.

Thanks

Ajeet