My Oracle Support Banner

ETL8.x/9.x Cannot Add Complex Time Periods To Time Reporters Or Workgroups. (Doc ID 620712.1)

Last updated on OCTOBER 16, 2018

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 8.8 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 200756951


***Checked for relevance on 29-Aug-2010***


Symptoms

"We need to create monthly time periods which go from the 16th of one month to the 15th of the next month. With the Monthly Time Periods, giving the dates like this is not an option. I can create these time periods with the Complex Time Period type, but cannot assign Complex Time Periods on the Workgroup or TL_EMPL_DATA. The search prompt view does not allow for the 'CO' Time Period Type. Empl Data view: SELECT DISTINCT A.PERIOD_TYPE
,A.PERIOD_ID
,A.DESCR
,A.DESCRSHORT
,A.START_DAY_OF_WEEK
,A.PERIOD_LENGTH
FROM PS_TL_TIME_PERIODS A
WHERE A.PERIOD_TYPE IN ('FW','FM')
OR (A.PERIOD_TYPE = 'FD'
AND A.OFFSET_DAYS = 1)

Workgroup view:
SELECT DISTINCT A.PERIOD_TYPE
,A.PERIOD_ID
,A.DESCR
,A.DESCRSHORT
,A.START_DAY_OF_WEEK
,A.PERIOD_LENGTH
FROM PS_TL_TIME_PERIODS A
WHERE A.PERIOD_TYPE IN ('FW','FM')
OR (A.PERIOD_TYPE = 'FD'
AND A.OFFSET_DAYS = 1)"

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.