Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
i have changed to 10 ocpus and still can not see the options :(
-
You could try below. SELECT hauft.organization_id department_id ,hauft.name department_name ,nvl (haouf.attribute2 ,haouf.attribute3) cost_center FROM hr_org_unit_classifications_f houcf ,hr_all_organization_units_f haouf ,hr_organization_units_f_tl hauft WHERE haouf.organization_id = houcf.organization_id AND…
-
Please check PER_MANAGER_HRCHY_DN is refreshed with latest data by submitting Refresh Manager Hierarchy process
-
SELECT * FROM (SELECT DISTINCT PU.PERSON_ID, PU.USER_ID, PU.USERNAME, TO_CHAR (PU.START_DATE, 'DD-MM-YYYY') USER_START_DATE, TO_CHAR (PU.END_DATE, 'DD-MM-YYYY') USER_END_DATE, DECODE (PU.ACTIVE_FLAG, 'N', 'Inactive', 'Y', 'Active') IS_USER_ACCOUNT_ACTIVE, DECODE (PU.SUSPENDED, 'N', 'No', 'Y', 'Yes')…
-
SELECT * FROM (SELECT DISTINCT PU.PERSON_ID, PU.USER_ID, PU.USERNAME, TO_CHAR (PU.START_DATE, 'DD-MM-YYYY') USER_START_DATE, TO_CHAR (PU.END_DATE, 'DD-MM-YYYY') USER_END_DATE, DECODE (PU.ACTIVE_FLAG, 'N', 'Inactive', 'Y', 'Active') IS_USER_ACCOUNT_ACTIVE, DECODE (PU.SUSPENDED, 'N', 'No', 'Y', 'Yes')…
-
Below query should get you started SELECT * FROM (SELECT DISTINCT PU.PERSON_ID, PU.USER_ID, PU.USERNAME, TO_CHAR (PU.START_DATE, 'DD-MM-YYYY') USER_START_DATE, TO_CHAR (PU.END_DATE, 'DD-MM-YYYY') USER_END_DATE, DECODE (PU.ACTIVE_FLAG, 'N', 'Inactive', 'Y', 'Active') IS_USER_ACCOUNT_ACTIVE, DECODE (PU.SUSPENDED, 'N', 'No',…
-
Below query should get you started SELECT * FROM (SELECT DISTINCT PU.PERSON_ID, PU.USER_ID, PU.USERNAME, TO_CHAR (PU.START_DATE, 'DD-MM-YYYY') USER_START_DATE, TO_CHAR (PU.END_DATE, 'DD-MM-YYYY') USER_END_DATE, DECODE (PU.ACTIVE_FLAG, 'N', 'Inactive', 'Y', 'Active') IS_USER_ACCOUNT_ACTIVE, DECODE (PU.SUSPENDED, 'N', 'No',…
-
Below query should get you started SELECT * FROM (SELECT DISTINCT PU.PERSON_ID, PU.USER_ID, PU.USERNAME, TO_CHAR (PU.START_DATE, 'DD-MM-YYYY') USER_START_DATE, TO_CHAR (PU.END_DATE, 'DD-MM-YYYY') USER_END_DATE, DECODE (PU.ACTIVE_FLAG, 'N', 'Inactive', 'Y', 'Active') IS_USER_ACCOUNT_ACTIVE, DECODE (PU.SUSPENDED, 'N', 'No',…
-
Below query should get you started SELECT * FROM (SELECT DISTINCT PU.PERSON_ID, PU.USER_ID, PU.USERNAME, TO_CHAR (PU.START_DATE, 'DD-MM-YYYY') USER_START_DATE, TO_CHAR (PU.END_DATE, 'DD-MM-YYYY') USER_END_DATE, DECODE (PU.ACTIVE_FLAG, 'N', 'Inactive', 'Y', 'Active') IS_USER_ACCOUNT_ACTIVE, DECODE (PU.SUSPENDED, 'N', 'No',…
-
PER_USER_ROLES PUR, PER_ROLES_DN PRD, PER_ROLES_DN_TL PRDT, ASE_ROLE_VL ARV