0FI_AR_4 Delta Not Working: BWOM2_TIMEST table corrupted

[Former Member]

Dear SAP Gurus,

We are facing issues with 0FI_AR_4 data source. Delta is no working.Actually we are extracting the data from ECC to BW and GBIP Platform(Other External Target System via Informatica). We have observed the time stamp table BWOM2_TIMEST is corrupted on 14th july 2016. Double initialization has been done from Informatica. Delta which was working fine in BW started failing from 14th . It brings 0 records to BW.

Can you please check and provide us the solution for the below issue.

[vinius_trintin]

I had the same issue.

I fixed deleting one of the duplicated records and doing the init again

[former_member226999]

Check the initialisation on BW side to see if it is correct? Does it agree with Informatica?

This issue seems to be on the Informatica side. Informatica experts will be able to advice.

[Former Member]

Hi Francis,

Thanks for your reply. I will check with Informatica expert on that.

Regarding the BW issue can you please advice us . In BW also initialization is not working for 0FI_AR_4.

Best Regards,

Arun.K

[former_member226999]

Hi Arun,

You can try deleting the existing initialisation and try to re-initialise without data transfer. And then you can repair load of the lost data via Full repair load mechanism with selection condition for the required dates (provided Informatica has the required data).

[Former Member]

Hi Fransis,

I already tried that. But delta records are not coming. i.e., in RSA7 delta queue it is 0 for more than 3 days. Actually it should bring the deltas right?

Best Regards,

Arun.K

[former_member226999]

Check table TPS31 in source system for value PROCS 00005011. If there is an entry then the FI delta data table BWFI_AEDAT will have delta values. If it is blank then your delta has got corrupted hence not being build up.

Before a new data request can be made in the update mode Initialization of the delta method, the entry must be added again to table TPS31 using SM30 Table maintenance transaction.

or using customisation transaction FIBF (standard menu changes) -> then select Settings -> Process Modules -> ...of an SAP application.

Now add the entry

00005011, , ,BWFIP_WRITE_AEDAT_POINTER