ETL9.2: TL_TR_COMMENT Populated By TL_ST_LOADER When No Value Is Included In COMMENT Field On Load File after PUM 16
Last updated on DECEMBER 14, 2017
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, TL Integration
The TCD load process is loading comments into TL_TR_COMMENTS for all hours loaded, even when there are no comments coming in through the TCD. These invalid comments show up as content on the timesheet comments icon.
-Reported time file loaded via ELAPSED_TIME_ADD. COMMENTS field, #24, is blank on load file.
-Row is written to TL_TR_COMMENTS for each EMPLID/DUR/TCD on load file referencing TLSYSTEM as UserID and date/time of load with a blank comments field.
-Online on the Timesheet, the Comment line created by load process is open for entry.
-Comment can be entered and saved; TLSYSTEM and Date/Time of load remain. Actual online UserID and Date/Time of comment entry is not saved.
-If COMMENTS field on file loaded via ELAPED_TIME_ADD is blank, no record should be written to TL_TR_COMMENTS.
-If Comment field is included on file, it should be written to TL_TR_COMMENTS, but online update should not be available.
-Any new comments entered via online page should reflect applicable UserID and Date/Time stamp of entry.
The impact is that managers and timekeepers are not able to differentiate between valid timesheet comments and invalid (empty) comments.
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