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
not able to fetch latest date even after using MAX function
Hi team
i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function it is giving me 2021 data as a latest.
SELECT DISTINCT PPP.PRE_PAYMENT_ID PRE_PAYMENT_ID,
PPP.PAYROLL_REL_ACTION_ID PAYROLL_REL_ACTION_ID,
OPMTL.ORG_PAYMENT_METHOD_NAME ORG_PAYMENT_METHOD_NAME,
TO_CHAR (OPMTL.Last_Update_Date,'DD/MM/YYYY') AS Last_Update_Date,
--OPMTL.Last_Update_Date,
PPM.PRIORITY PAYMENT_METHOD_PRIORITY,
PPTLEGTL.PAYMENT_TYPE_NAME PAYMENT_TYPE_NAME,
PPT.PAYMENT_TYPE_ID PAYMENT_TYPE_ID,
0