Negative values in planned time in 0HR_PT_1

[Former Member]

Hello,

I have a problem with the infopackage 0HR_PT_1. Most of the time, it's works but sometimes it load negative values in planned time. I check with HR team and there is no special event when it produce and to have negative planned time should not be possible.

There is no apparent logic in data. Costcenters, functionnal localations, etc does not matter. There is no change in the employee's states. An employee can keep is position and have a negative or a positive value. There is no apparent distinction between a row with a positive value and another with a negative value.

Values are the inverse of the real planned time. For exemple if a person is planned for 8 hour for a day, he have -8 in planned time. Normaly he have already a value of 8 in the cube loaded by another request. So, if we check is the cube, he have 0 hours for this day.

The system do this for a large part of persons. about 80%. Sometimes, he do this to times. If I check for the planned time for february 2014 (the next month in the future) I have -70000 hours.

The requests with negative values seems to be normal.

I deleted all data and reloaded. All data seems to be fine after that and the is no negative values at all.

Do you have an idea?

Thanks!

[RamanKorrapati]

Hi,

We can't guess what will be the issue. With the help of -ve value records you need to trace from info cube --> data source level,RSA3 and later source tables.

Now there is no chance find the cause. rather than that can you ask your team jan1 2014,on wards any special  cases for this cube to  load data to nullify the records at bw side. that might be possible.

are you in 3.x data flow, if yes then we can think about reverse posting may happens.

Thanks

[Former Member]

It's difficult to give a result of RSA3 because I can't reproduce the bug in QA envrionment and I don't have the correct rights in production. Anyway, I think I will not be able to reproduce the bug because when I reload the data for the same period, there is a no negative values.

I checked which data is search in the tables. I think than the data is calculated with PA0007, which is the normal time. To know how much time is planned for an employees en a period, it check what is his normal time and give this value.

If I understand as weel, the calculation is made near this line :

[KodandaPani_KV]

Hi Corbel,

Have you checked key figure value (planned time) as inversion?

please check the RSA3 then check the planned time key figure have any negative values?

cross check the some records.

Thanks,

Phani.

[Former Member]

No, the inversion value is not checked. Most of time, values are positive and, with no change, I have negative values. It produce it some times  with no apparent change and data after are normal again.