Question:
We have a generic delta set up for the GLPCA table, based on the date field CPUDT. Once this delta is run during a day, you cannot run it again that day...is there something to reset so that you can run again the same day? The Safety Interval Upper and Lower limits are set to 1 and blank, respectively.
Thanks,
David
Answer:
Have you tried considering using a function module for the extraction and using date and time to control your deltas ??
Answer:
Hi,
you will have to make sure that your extraction runs after 0:00 a.m. so no new records can appear on the database after extraction.
Bye.
MG
Answer:
Hi David,
If you are using the latest Plug -In in SAP R/3,there is a new business content datasource called '0EC_PCA_3' which extracts data from table GLPCA. This extractor is delta capable and you can extract data more than once in a day.
If you have a generic datasource for table GLPCA,it may not be required since you can use this datasource.
I hope this helps.
Thanks,
Sri
Answer:
We are moving toward using the new extractor, '0EC_PCA_3', but that will be awhile yet, so we need to figure out how to re-run our generic delta in the same day. This is necessary when the original run does not complete correctly (due to an Oracle 1555 error on R3), and needs to be run again.
Thanks,
David
Answer:
you will keep getting ora 1555 (snapshot too old)
as records are being written to the table within the same time frame of your extract.
Thats something you cannot avoid unless you have date and time.
Your only quick fix is to run the extract once a day- after 0:00 and for the previous day