Missing records in 0FIGL_O10(DSO)

[Former Member]

Hi..

I have loaded data for DSO (0FIGL_O10) from DataSource (0FI_GL_10)....all are standard from BI Cont.

In PSA level i am able to see the records for specific combination like GL Account, Company Code, Fiscal Year/Period.

there is 10 records for that particular combination(For Ex.)

Now, for that same particular combination (in DSO Active Table) some records are missing.

How i can solve this issue?

How i can get correct Data in BI(DSO)?

Is there any problem with DataSource (0FI_GL_10)

Can any have faced same issue, Please help me out.

I have read threads on SCN but Still have some confusion.

also Checked OSS Notes:

1002272

1153944

Thanks & Regards,

[Former Member]

I guess we should not check no. of records in PSA = No. od records in A table.

The no. of records in DSO will largly depend on Key of DSO and your business logic. What you should rather check is the overall KF value say Amount. It is very much possible that when actuall transferring 10 records from PSA, only 1 or 2 (upto 10) can be added to your DSO.

Rgds..

Shambhu

[Former Member]

Hi Ganesh

Dont check by number of records. Some times 100 records would get aggregated into one record.

Please check by aggregating a KEY FIGURE value.

first check value in PSA. Next check Value in DSO. If they are not matching, then

Something is happening to data in between i.e

1. DTP

2. Start Routine

3. Field Routine

4. END Routine

5. Selective Deleting

Check those 5 things.

I think your issue should be resolved.

[karthik_vasudevan]

Hi Avinash

We also had the same issue with this DSO and the issue was with key fields of the DSO.

When you check data, check in reverse. Meaning based on the key fields check the data in DSO first and then use the same key fields as reference and check the data in PSA. It would match.

The reason is that 0FIGL_O10 will have the maximum number of key fields allotted to a DSO (16).

We resolved the issue by creating a customized DSO based on the key fields that we require in our project.

Regards

Karthik

[Former Member]

Hi,

Please do debug on the Start routine using DTP, to analyze the data is coming into SOURCE_PACKAGE, if not then there is not issue need to check....

If you have data in SOURCE_PACKAGE then it would be Key Fields issue ...

Please let us know if you still having issue ....

Thanks

Ganesh Reddy.

[Former Member]

Hi....

I have checked all above mentioned. I couldn't get any result.

As i m seeing the change log table in DSO(0FIGL_O10)

Recode mode      Field1      Field2

    N                    500          900

    X                    500-         900-

(this only for Example purpose..)

I think..due to above reason(Record mode concept), i m not getting that particular record in my DSO Active table.(and also explain me the reason behind it.)

Is it correct?

If not then what is next process should i do?

[former_member186399]

Dear Avinash,

If the PSA is bringing in the correct data, DSO should also get updated correctly unless there is a key issue or you have filters in the DTP.

What you can do is move the ods data to the reporting cube and then check whether you have the GL wise balance issues.

Regards

Gajesh

[Former Member]

Hi Raman

Thanks for your fast response.

a. Have or any one done selective deletion on your dso?

No

b. records which you checked, when its created and loaded init dso?

it was created 4 month ago and loading of data started 20days ago and delta was running.

i have reloaded data and checked data again but still i have same problem.

[RamanKorrapati]

Can you activate your DSO and reload the data and see.

Try to use RSRV on DSO Active table and see. whether it shows any error message or not.

[RamanKorrapati]

Hi,

Have or any one done selective deletion on your dso? are your sure about selective deletion?

records which you checked, when its created and loaded init dso?

is those records are loaded to dso recently?

if possible can you try to reload those records only by using dtp filters.

Thanks