0CO_OM_CCA_9 delta queue is not updated even after two hours
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.
Thanks and regards
Simon Turnbull replied
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