Share
ReportI am approving timecard and got the following message for a Timecard
Unable to post PJLABDIS, possible dup key.
Any solution for this.
*This post is locked for comments
You’re offline. This is a read only version of the page.
I am approving timecard and got the following message for a Timecard
Unable to post PJLABDIS, possible dup key.
Any solution for this.
*This post is locked for comments
KB 847959 may provide some help with the error.
Unable to post to PJLABDIS, possible dup key. Timecard #999999, Line #999999, Hours Type XXX. in TM.
Resolution - Check to ensure that the Timecard approval posting did not update PJTRAN.
CORRECTION STEPS
1. Open Transaction Detail Inquiry (PA.TDI) in Project Controller
2. Select the PROJECT, TASK and ACCOUNT CATEGORY used on the Timcard Transaction.
3. Input the Period of the Timecard fiscal period to post.
4. Look for the transaction by Employee and Date.
5. If the transactions are present in Transaction Detail Inquiry screen the Timecard posted through the system.
6. The Timecard status will need to be updated to remove the Timecard from the approval screen (TM.TRA)
The Timecard released properly to the Project Controller and Labor distribution tables however the PJLABHDR.LE_STATUS field is set to A = Approved, C = Completed, or R = Rejected.
CORRECTION STEPS:
1. Make a BACKUP of the database that can be restored in case an undesired data loss occurs.
2. Open Query Analyzer and connect to the appropriate application database.
3. Run the following statement to update the PJLABHDR table for the timecard document
UPDATE PJLABHDR SET LE_STATUS = 'P' WHERE DocNbr = 'XXXXXX'
(where XXXXXX = the appropriate Document Number).
If the Timecard did not update the Project Controller Module (PJTRAN table)
CORRECTION STEPS:
1. Make a BACKUP of the database that can be restored in case an undesired data loss occurs.
2. Reject the timecard using Time Review and Approval (TM.TRA).
3. Delete the Timecard that was rejected in step1 in Timecard Entry (TM.TCE).
4. Open Query Analyzer and connect to the appropriate application database.
5. Run the following SQL statement to delete the Timecard from the PJLABDIS table:
DELETE PJLABDIS WHERE DocNbr = 'XXXXXX'
(where XXXXXX = the appropriate Document Number).
6. Recreate the Timecard in Timecard Entry (TM.TCE).
Stuck with the same error. Any Help will be appreciated.
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
All responses (
Answers (
