Showing posts with label PeopleSoft Time and Labor. Show all posts
Showing posts with label PeopleSoft Time and Labor. Show all posts

Saturday, February 2, 2019

PeopleSoft Time Admin Process Error : Dropped 1 Time Reporters found in other concurrent runs

Recently we got this error while running the time admin process TL_TIMEADMIN. The error text read as:

Dropped 1 Time Reporters found in other concurrent runs. (13507,9)

We did the RCA and discovered that the table TL_TR_STATUS contains the data that suggests the employee in question is being processed through another run control id. Following fields in the table contained values:

  1. PROCESS_INSTANCE
  2. RUN_CNTL_ID
  3. OPRID

We had to clear these three fields and also update the Earliest Change Date (EARLIEST_CHDT) back to the last reporting date. But instead of doing it through UPDATE SQL, we first deleted the row and then did an INSERT. 
Example:

DELETE  FROM PS_TL_TR_STATUS WHERE EMPLID = 'KU0045';

INSERT
INTO PS_TL_TR_STATUS
  (
    emplid,
    empl_rcd,
    ta_status,
    earliest_chgdt,
    prcs_thru_dt,
    lastupddttm,
    last_prcs_dttm,
    process_instance,
    oprid,
    run_cntl_id
  )
  VALUES
  (
    'KU0045',
    0,
    'Y',
    TO_DATE('2017-06-24','YYYY-MM-DD'),
    TO_DATE('2017-06-24','YYYY-MM-DD'),
    TO_TIMESTAMP('2017-06-24-12.50.57.000000','YYYY-MM-DD-HH24.MI.SS.FF'),
    TO_TIMESTAMP('2017-06-24-12.50.57.000000','YYYY-MM-DD-HH24.MI.SS.FF'),
    '0',
    ' ',
    ' '
  ) ;

Additionally, we also deleted run control data from below three tables:

DELETE FROM PS_TL_TA_RUNCTL  WHERE OPRID = 'PS';
DELETE FROM PS_TL_RUN_CTRL_GRP  WHERE OPRID = 'PS' AND EMPLID = 'KU0045';

DELETE FROM PS_PRCSRUNCNTL WHERE OPRID = 'PS';

After doing the above three steps we ran the time admin again and it went to success and the error was also gone.