Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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
Tagged:
0