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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How to default value for for PER_SYS_DATE_TIME

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!