We are currently working on developments of sales statistics 0UCSA_C01 cube for a large utility company. As part of building this cube, we are using data source 0UC_SALES_STATS_02 and completed all the requisite developments.
When we run info package to extract data from R/3 to BI - PSA, we are not able to get any records into delta queue in source system and as a result the info package is returning "0" records.
We did the following in source system and BW to extract.
1. Initialized delta
2. Closed reconciliation keys
3. Transfered reconciliation keys to GL
4. Ran mass activity program for specific recon keys using t code EBW_DQ_SS in ECC system
5. Checked RSA7 for delta queue and the queue has no data.
6. Checked application log of the mass activity job and no errors.
Picked 0 records though we have couple of invoices to be extracted using the specific reconciliation keys.
We are on ECC 6.0 and BW 04 S with SP10.
If anyone has any clue on why the delta is not getting built in source system, pls let us know and appreciate your attention to this message.
Thanks - Sriram