ETL9.0/9.1: TL_ST_LOADER Fails with "Unique Constraint" Error.
Last updated on DECEMBER 14, 2017
Applies to:PeopleSoft Enterprise HRMS Time and Labor - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2014***
TCD integration, the punches are coming from TCD Interface, one of the TL_ST_LOADER process abends causing all the following processes to also abend with the following error message:
ORA-00001: unique constraint (SYSADM.PS_TL_MTCHD_1) violated
The issue can be reproduced at will with the following steps:
1. Punches sent through TCD Interface
2. The ST_INSTANCES triggers ST_LOADER process
3. One process picks some bad data and abended with a unique constraint error message, then the following process is trying to pick the same data as it is not processed, hence all processed continue to fail with same error message.
4. Around 300 + processes abended with above error message.
Due to this issue, employees payroll is delayed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms