Issue with 0FI_AR_3

[Former Member]

We are using 0FI_AR_3 extractor and for some reason it did not pick up records which were entered for a short period of time (about 3 hrs). We have documents which were entered in the monring and the evening for the same day. Did anyone experienced this where the extractor failed to fix documents which were created on the same day. These are similar documents with the same posting key. Please give me a guidence on where to go and see.

[Former Member]

I just wanted to update... I found a failed LUW in the R/3 side. Due to this we missed some data. After that we found another issue with our AR ods.. we pretty much lost the ODSR* data in the change log as a result of a custom psa delete program.. so we are doing reload of the entire ODS.

[Former Member]

Vinay,

Vinay,

Also for reference check the document

Data Extraction (Line Item Level) FI/CO (Financial Accounting and Controlling

under BW infoindex-Extraction in service.sap.com

Hope this helps

-Doodle

[Former Member]

Hi Vinay,

In all likelyhood the settings you have in the delta table for 0FI_AR_3 datasource would be getting delta on once in a day.

To customise this settings for safety interval for FI CO datasources, there is a presentation which gives all the details with regard to the underlying table/parameters and settings on marketplace. Refer to the below link to access the same

Data extraction (Line item level) FICO

https://websmp101.sap-ag.de/~sapidb/011000358700007881242002

(login required)

In case the above link doesn't work go to

service.sap.com/bi

BI Infoindex

Expand the Extraction(SAP System) heading

Data extraction (Line item level) FICO (ppt)

Hope it helps

[Former Member]

It has been a while but there is a system table settings typically brings data in up to current day's 2am or 3am.

If I remember correctly, there was an OSS note on the subject of more frequent deltas if there is really a business need to bring it in more frequently.

[Former Member]

Vinay

Check the time charactrastics and time stamp in the extractor and your data target if it is 0calday it brings only after day.

Thnaks

sat

[Former Member]

Hi Vinay,

Is the extractor based on a calendar day field for delta then it would pick up the record only a day after it has been created/updated.

Bye

Dinesh