0FI_AR_4 Initilaization issues

[Former Member]

Hi All,

I was going thru messages on and found quite a few messages on this

the below was the the closest to our issue. We have around 5 million records to be pulled.

Also iIdid read that we have to load 0FI_GL_4 before we load 0FI_AR_4. We do not have FI GL implemented in BW nor in R/3.

We are on R/3 4.7 Version & BW 7.0, we are in process of upgrade to ECC 6.0 which woudl happen by March 2010.

So how does this condition satisfy of laoding GL before AR.

Regards

Lalan

[dennis_scoville4]

[OSS Note 641977 - Poor performance|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=641977], which was listed in the post that you referenced, should resolve the issue, but when we deployed the indexes in that OSS Note via SE11 in R3/ECC, they weren't being invoked. We had to have our Basis DBA create the indexes at the RDBMS level and then they got invoked perfectly.

What we've found is that any of the SAP recommended indexes related to FI-CO/PA tend to need to be created at the Oracle level instead of at the application level using SE11 in R3/ECC.

[Former Member]

Hi Dennis,

I also checked with our Basis here and we found that only the note 760973 is applicable & its suporting note 770040 for our current version of R/3 which is 4.7 Enterprise.

We are planning to implement it. I would update with the results.

Thanks

Lalan

[dennis_scoville4]

Ok...We were on Enterprise R3 (4.7) when we first implemented the indexes in the OSS Note I referenced. Hope the note that you're going to implement is successful (remember it may need to be created at the RDBMS level instead of application level,. in order for it to be invoked).