cancel
Showing results for 
Search instead for 
Did you mean: 

0FI_GL_4 Delta Load is not working since no entries in BWOM2_TIMEST

0 Kudos

Hi Team,

0FI_GL_4 delta is not working end with error in rsa3. We have done the debug and found that there is no entries in BWOM2_TIMEST table.

Could you please help me to fix this issue?

Regards,

Siva M

Accepted Solutions (1)

Accepted Solutions (1)

Hi All,

Executed the Delta Initialization from the target and entries are added in BWOM2_TIMEST table.

It works now.


Regards,

Siva M

Answers (1)

Answers (1)

bhavinvyas
Active Contributor

Hi Siva,

Delta for 0FI_GL_4 data source usually fetch data once in a day based on the setting in BWOM_SETTINGS table.

If you want to load data multiple time in a day, you may need to settings for minute based delta trigger in BWOM_SETTINGS table.

This scenario has been very well explained in following blog,

https://blogs.sap.com/2013/04/02/bwomsettings-for-fi-loads-in-sap-bi/

Hope it helps!

Thanks,

Bhavin Vyas


0 Kudos

Hi Bhavin,

I have maintained all the setting in the BWOM_SETTINGS table. But while am doing rsa3 extraction for delta its trying to find some entries in BWOM2_TIMEST.

Do I need to manually add entries in BWOM2_TIMEST table?

Is there any other option to bring back entries in BWOM2_TIMEST?


Regards,

Siva M

bhavinvyas
Active Contributor
0 Kudos

Hi Siva,

Time stamp information would store on ROOSGENDLM table for Data Sources with Delta based on "Timestamp".

Data sources with Delta based on "Numeric Pointer" will use BWOM_SETTINGS table parameters to fetch delta data and store the data sources delta information in BWOM2_TIMEST table.

See this for the detailed explanation about BWOM2_TIMEST,

https://archive.sap.com/discussions/thread/3569778

Thanks,

Bhavin Vyas