We have encountered an error that I have not seen before when we are trying to 'Approve' a timesheet, entered in BP and the approval is happening in PDK.
From the Timesheet Approval - using Administrator rights - we select the desired timesheet, change to APPROVE and click process.
An error is generated
And when you click on OK the error goes away.
When I look at the PA00511 table I see data related to the Customer , Fiscal Year and Period ID along with a series of values - not posting the entire page -
When I do a quick query of the table, I find that there are 12 lines per customer, per fiscal year. And when I read the error above, it is referencing Customer MCWCON001, fiscal year 2015, and Period ID 8
There is only one line that matches this in the table.
Of interest, after clicking ok, the error goes away and the Timesheet is then available in the Project >> Transactions >> Timesheet Entry (or inquiry) screen and is correct in all form. We have printed an edit list of the timesheet and there are no errors reported by the system.
How to do I determine what the 'duplicate key' is? How to I search the table and find errors.
Any suggestions?
*This post is locked for comments