You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

How to default value for for PER_SYS_DATE_TIME

Received Response
34
Views
5
Comments

Summary:

Hi Folks, i am getting issue while using the system date. Please share any reference code to use it.

I am getting error as line 26, conflicting type usage.

for below line

DEFAULT FOR PER_SYS_DATE_TIME IS '4712/12/31 00:00:00'(date)

Please suggest

I have used the below code:

Content (please ensure you mask any confidential information):

DEFAULT FOR IV_CALEDARSTARTDATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR IV_CALEDARENDDATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR IV_EVENT_DATES IS EMPTY_DATE_NUMBER
DEFAULT FOR IV_ACCRUAL_VALUES IS EMPTY_NUMBER_NUMBER
DEFAULT FOR PER_ASG_FTE_VALUE IS 1
DEFAULT FOR PER_ASG_NORMAL_HOURS IS 0

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!