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

SQL Query based on date input value error

Summary:

SQL Query based on date input value error

Content (please ensure you mask any confidential information):

We are trying to run the below query to be used in a value set, however it raises error when running it in the BI data model:

SELECT PEEVF.SCREEN_ENTRY_VALUE, SUBSTR(PEEVF.SCREEN_ENTRY_VALUE, 0, 4) Year, SUBSTR(PEEVF.SCREEN_ENTRY_VALUE, 6, 2) Month, SUBSTR(PEEVF.SCREEN_ENTRY_VALUE, 9, 2) Day

   FROM   PAY_ELEMENT_ENTRIES_F PEEF,

         PAY_ELEMENT_TYPES_TL PETL,

         PER_ALL_PEOPLE_F PAPF,

         PAY_INPUT_VALUES_F PIVF,

         PAY_ELEMENT_ENTRY_VALUES_F PEEVF

   WHERE PEEF.ELEMENT_TYPE_ID = PETL.ELEMENT_TYPE_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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