Clearing Delta Q of 0FI_GL_4 extractor

[Former Member]

Hi,

We are upgrading the PI add-on in R/3 source system from 2003_1_46C to 2004_1_46C. Before this upgrade I need to clear the delta queues in the R/3 system. 0FI_GL_4 is one of the datasources used.

How can I make sure the all the data in the delta Q of 0FI_GL_4 has been cleared, as there is a Safety Interval associated with this extractor?

The BWOM_SETTINGS table has the following values in its records:

BWFILOWLIM : 19910101

BWFIOVERLA :

BWFISAFETY : 1

BWFITIMBOR : 020000

DELTIMEST : 60

OBJSELSICO : X

ORGSYSONLY :

We’ll make sure that during this period all R/3 users are locked out, so there will be no new records generated in the system.

Will it be enough if I run the data load from BW a couple of times for this extractor (during normal working hours) and make sure there are no records shown for the extractor in RSA7 in R/3? Will this ensure there is

no records left in the Delta Q?

Or do I need to change any of the above settings in BWOM_SETTINGS table (or change values in any other place)?

Thanks in advance for your inputs.

Kind Regards,

Melwyn Joseph

Message was edited by: Melwyn Joseph

[edwin_harpino · Accepted solution]

hi Melwyn,

when do r/3 pi upgrading, normaly we run the delta data load from bw at least 2 times before the upgrade time and queue in rsa7 should be clear. (since the queue cleared after the next successfull delta extract to maintain consistency by repeat if data load fail)

hope this helps

[Former Member · Accepted solution]

Hi AHP,

Thanks for the quick reply.

Just to confirm - you are saying that I just need to run the normal delta loads for the GL extractor couple of times & make sure that RSA7 does not show any records for that extractor.

And that I need not make any changes in the R/3 system.

The loads will ensure that there are no records in the Delta Q, provided there is no user activity in the R/3 after the loads.

Correct me if I'm wrong.

regards,

Melwyn

Message was edited by: Melwyn Joseph

[edwin_harpino · Accepted solution]

hi,

yes, you are right.

[Former Member]

This helps in understanding the FI extractors :

http://help.sap.com/saphelp_nw04/helpdata/en/af/16533bbb15b762e10000000a114084/frameset.htm