Friday, January 6, 2012

Delta extraction for 0FI_GL_04 for every 30 minutes

Note: The below scenario is applicable only for the datasources 0FI_GL_4 (General ledger: Line Items),0FI_AP_4 (Accounts payable: Line Items), 0FI_AR_4 (Accounts receivable: Line Items)

Scenario
In BW, the delta extraction for 0FI_GL_4 from the source system can be loaded as per the processchain or infopackage schedule but where as, from source system will be able to fetch the delta records as per the timestamp defined, or depending on system predefined delta pointer. So even if the data is pulled multiple times Ex:- for every 30 minutes in the same day in the BW system, the deltas will fetch zero records, if the delta pointer is limited to certain period for Ex:- only once a day in the source system.

Check the below link:
Financial Accounting: Procedure for Line Item Extraction

Constraints
Per day, no more than one delta dataset can be transferred for InforSource 0FI_GL_4. The extracted data therefore has the status of the previous day. For further data requests on the same day, the InfoSource does not provide any data.
In delta mode, data requests with InfoSource 0FI_AR_4 and InfoSource 0FI_AP_4 do not provide any data if no new extraction has taken place with InfoSource 0FI_GL_4 since the last data transfer. This ensures that the data in BW for Accounts Receivable and Accounts Payable Accounting is exactly as up to date as the data for General Ledger Accounting.
Because in the source system delta extraction is based on CPU Time, the deltas are fetched once per day.
So if the source system delta extraction is to be achieved for the timely base, the same data can be pulled into BW easily by a process chain.
However, you can change this standard delivery. For more information, see note 485958.

Solution
It can be achieved by changing the settings at back end in the source system.
As the requirement is to get the deltas for every 30 minutes (1800 Secs), it needs to be update in the table BWOM_SETTING. We need to create an entry or change the existing entry for the field/Param_Name BWFINSAF with value 1800 (secs).

No comments:

Post a Comment