You’re offline. This is a read only version of the page.
22,647
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
Andy, as soon as I can get this tested - if still an issue with the client, I will let you and post a reply at that time.
Typically this is an issue with your Periodics. Here is a KB that should take care of the message:
Someone has to have some idea of how to confront this issue? Anyone got any suggested scripts or tools?
Client can work through this issue, but I would like to resolve for them.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (