Skip to Content
avatar image
Former Member

0FI_GL_10 and BWOM2_TIMEST

Hello,

I did init delta with data transfer for 0fi_gl_10 and loaded successive deltas successfully. The deltas are bringing records but when i checked table BWOM2_TIMEST which maintains time stamp for 0fi_gl_10, i do not find any entry.


How ever when i clicked the generic pointer in RSA& for data source 0fi_gl_10 i can see the last successful load time stamp as below. Why cant is ee the timestamp in BWOM2_TIMEST table ? How can i resolve this and what is the error.? Thank you.

pastedImage_4.png (19.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

8 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 03, 2014 at 02:28 PM

    Hi,

    Basically all FI-CO data sources we can split into two categories. They are

    1) Data sources with Delta based on "Numeric Pointer"

    2) Data Sources with Delta based on "Timestamp".

    We can check data source properties in RSA2 t-code.

    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.

    So its stndard setting there is no error. So dont worry.

    Thanks

    CM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2014 at 02:42 AM

    Hi ,

    I assume that you have done a Re-Initialization process which was successful , am i right . So now you have your full loads and deltas running fine everyday ?

    Provided your INIT process and deltas are running fine , dont worry much about the Time stamp Table "BWOM2_TIMES".

    If This table , has the Init Timestamp details and your deltas are running successfully and the data is available in Cube /DSO then nothing to be worried .

    If suppose your loads are not successful or deltas are not coming through in BW then in that case your INITIALZATION procedure wasn't successful . You need to Re-INIT again .

    Let me know your findings ?

    Thanks

    Zeenath

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Zeenath,

      Thank you for your valuable comments. Yes i have initialized and re-initialized the datsources and delta is running fine.

      I am not facing problem as such right now. The concern is(correct me if am wrong) The financials data sources like 0fi_gl_10, 0fi_ar_4, 0fi_ap_4 take the timestamp from BWOM2_TIMEST during intialization and delta for synchronization of data from all the three datasources.

      so if i initialized the datasource 0fi_gl_10 and then when i initialize 0fi_ar_4, then 0fi_ar_4 takes the timestamp from table BWOM2_TIMEST for being in synchronization with 0fi_gl_10. In my case there are no entries in BWOM2_TIMEST.

      When no entries in BWOM2_TIMEST then how will 0fi_ar_4 get initialized and the delta will function.BWOM2_TIMEST.

      I have DELTAID maintained in ROOSGENDLM for datasource 0fi_gl_10. I am confused please help.

  • avatar image
    Former Member
    Jul 03, 2014 at 10:36 AM

    Former Member can you please help me with this.

    Thank you.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2014 at 10:26 AM

    Thanks,

    The delta in ROOSGENDLM at ecc and RSSDLINIT in BW match.

    @raman, @suresh and @chandramouli: Thanks a lot for clearing my doubts.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 08, 2014 at 01:30 PM

    Mohammed,

    There is no restriction. It depends on the users how frequently they want to see the new/refreshed data.

    We are running twice a day and during the month end closures we run adhoc delta loads manually whenever user wants the data to be refreshed.

    Hope this helps..

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      I agree with Suresh , It depends on user needs . We used to load daily but during month ends we run twice and adhoc basis .

      Regards

  • Jun 20, 2014 at 12:08 AM

    Can you please check table ROOSGENDLM for your datasource.

    Regards,

    Ganesh Bothe

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 07, 2014 at 10:14 AM

    Former Member,

    As you have used 0fi_gl_10 datasource. Can you let me know how many times a day i can run the delta for this datasource. Is there limitation on running no. of deltas for this datasource.

    Thanks a lot.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2014 at 07:12 AM

    @Suresh Ramajeyam

    can you please let me know if there is restriction to no. of delta loads we can make for 0fi_gl_10 in a day.

    Thanks a lot.

    Add comment
    10|10000 characters needed characters exceeded