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

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Received Response
123
Views
1
Comments
in Reporting and Analytics for HCM 1 comment

Summary: Encountering an error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 when trying to pull a value from the element's input value. Data type of the input value is Date.

PEEF2 = PAY_ELEMENT_ENTRIES_F table

  • TO_DATE(SUBSTR(PEEVF2.SCREEN_ENTRY_VALUE,1,10),'YYYY-MM-DD')BETWEEN PEEF2.EFFECTIVE_START_DATE AND PEEF2.EFFECTIVE_END_DATE


Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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