Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Age Bins
Summary
Invalid Alias FormatContent
Hi,
I've copied a formula that calculates the age of an employee from the following Oracle video:
The only difference in my version is that the date of birth is prefixed by Person not Employee and I have a sub folder called 'Parent Managers'
My organisation= "Worker"."Parent Managers"."Person Date of Birth"
in the video it is = "Worker"."Employee Date of Birth"
Why am I getting the following error message?
Error Message: Invalid Alias Format : Table_name.Column_name required. OK (Ignore Error)
The SQL is below.
Thanks,
Andrew
Version
19DCode Snippet
CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY,CURRENT_DATE,TIMESTAMPADD(SQL_TSI_DAY,CURRENT_DATE,TIMESTAMPDIFF(SQL_TSI_YEAR, "Worker"."Person Date of Birth",CURRENT_DATE),"Worker"."Person Date of Birth")) >=1 THEN TIMESTAMPDIFF(SQL_TSI_YEAR,"Worker"."Person Date of Birth",CURRENT_DATE)-1 ELSE TIMESTAMPDIFF(SQL_TSI_YEAR,"Worker"."Person Date of Birth",CURRENT_DATE)END
0