0FI_AR_4 wrong data transfer

[former_member202516]

Hi experts,

I have a very strange situation.... We're loading data for account receivable, into 0FIAP_C03.

On the date 08.02.2014(CPUDT) three records are created in BSAD ERP table with closing date 31.12.2013(AUGDT). Delta extractor has run on 09.02.2013 at 03:00 am.

I've found those records in PSA table, from 09.02.2014, with empty closing date fields (AUGDT) and item status was O for open.

How is this possible? Is it common error during data load or I'm I missing something?

Regards,

Mijodrag

[RamanKorrapati · Accepted solution]

Hi,

Can you try to do extraction for particular accounts at RSA3. see how data look like.

Can you check with FI Team. record was changed on feb 8 2014 and closing date as 31.12.2013. seems like not meaning full date here. we are at 2014 and how closing date will go to old date(31.12.2013).

Thanks

[former_member202516 · Accepted solution]

Hi Ram,

record was created on 08.02.2014 because they have decided to write off the claim towards that buyer with 31.12.2013.

Anyway I tracked down documents which are creating the problem, and they are from 2009. So, can you tell me this.

For this particular extractor we have 3 full load IP and one delta.

• First IP loads data for period 2000-2004,
• Second 2005-2009,
• Third (delta load initialization) 2010-2099

Is it possible that delta extractor collects only those changes relating to documents that are in the same range as period restriction as info package which initializing it. If this is the case, it would explain why this three lines from 2009 were transferred with empty AUGDT field.

Regards,

Mijodrag

[former_member202516 · Accepted solution]

Hi,

And that is exactly the case, delta load considers only changes on records whose parameters are in range of restriction of InfoPackage which initialize delta.

In my particular case initializing InfoPackage had restriction on documents from 2010 to 2099 and since closed items that were making problems were from 2009 delta didn't consider this as change and didn't transfer it to BW.

Hope this helps if you had similar problems.

Regards,

Mijodrag