Data Loading issue
When load for Hr Payroll is triggered it fails.
Error occured in the data selection.
Error message "Personnel no. 00008110 , payroll result 00161 : Incomplete administrative data"
Checked at source side all the details of the above personnel number. but there is no such payroll result 00161.
Technical name of the data source is : 0HR_PY_PP_1
Kindly help to get this issue resolved.
points will be assigned.
Thanks & regards,
Shilpa Vinayak replied
If the extractor checker is also giving the same message, then you can swith on the trace and find where exactly the error is coming.
Go to rsa3 and choose your extractor, dont execute it.
Trace sql is transaction st05 open it in a different mode, activate trace.
Since trace is activated, all database activity is saved into log, then you should be careful, trace shouldn't be activated much time.
You can fllow the below steps:
1. Open another session and go to transaction ST05.
2. Activate trace with filter.
3. Select SQL trace and enter you id.
4. Run RSA3 for your extractor.
5. Deactivate trace in ST05.
6. Display Trace in ST05 for your id.
This should give you an idea of tables the extractor hits.
Then you can check the tables, to trace the error, hope this helps...