SQL
Discussion List
-
Release 12 HCM OTBI Subject Area descriptionsSummary List of Release 12 HCM OTBI Subject AreasContent This spreadsheet provides the list of HCM OTBI R12 subject areas with descriptions, business questions answered …Raghavendra Raghunath-Oracle 943 views 11 comments 10 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Requisition Template ReportSummary: Hello - We are looking to create a report which shows all jobs and the requisition template they are associated to based on the Job Details section. We are not …Shanna Oppenheim 111 views 19 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to retrieve 'Exempt from Long Term Care' associated with Washington tax card from backend table?Summary: I am trying to locate 'Exempt from Long Term Care' linked to the Washington Regional Tax Card in the backend table, but I cannot find the base name in the backe…Swapna Udaiyar 61 views 7 comments 0 points Most recent by Gabriela Ichim-Oracle Reporting and Analytics for HCM -
How to default the Location of Logged In User in Dashboard PromptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 21 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
SQL to get the list of permission assigned to Dashboard SectionSummary: SQL to get the list of permission assigned to Dashboard Section Content (please ensure you mask any confidential information): Version (include the version you …ISHWTW 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
SQL Query for Learning Plans and ProgramsSummary: Hello I need a query that gives the following attributes in the Learning module: Program Name Plan Name Plan Profile Name Plan Profile Creation Date Content (pl… -
Report showing all ElementsSummary Need a report to show all element entries that have been created (Recurring and Non-Recurring)Content HI All, I hope this is a simple ask but I can't seem to fin…User_2025-02-04-08-51-08-912 1.1K views 9 comments 1 point Most recent by Muzaffaruddin Reporting and Analytics for HCM -
SQL to Show Which Pay Frequency is Associated to Which Legal EntitySummary: I am tasked with producing a mapping document of which Pay Frequencies are associated to each legal entity. I can find the Legal entities in "HR_LEGAL_ENTITIES"…Mickey James 42 views 2 comments 0 points Most recent by Mickey James Reporting and Analytics for HCM
-
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat… -
Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Summary Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Content Hi AllWe have a requirement to build Employment letter, letter is in …Naveen Jayaraman-48236 15 views 8 comments 0 points Most recent by Bhardwaj Yash Reporting and Analytics for HCM -
Need table name for Legal Employer level work schedulesSummary: Need table name for Legal Employer level work schedules: Example: We can see the default level schedules at Planned Schedules in Time Management. Content (pleas…GajavalliKoteswararao 12 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
element entry secured views queryIs there a query that contains a table to be used to get only the secured list element entries based on the element security profile. Similar to the table per_person_sec…bervin13 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to change the Query Time Out value in BI Published reportHi, How do we change the "Query Time Out" value in BI Published report It is available in Properties of the report data model , however maximum limit is 180000 and if i …Preeti Khondre 53 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 61 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu…Navadeep.Chowdavarapu 53 views 2 comments 0 points Most recent by AnujGupta_Tom BI Publisher Learning Center
-
Need table name for Business Object Type and its associated actionsSummary: Need table name for Business Object Type and its associated actions, as we are working on deep link for Job Requisitions page. So we are searching for actions u…GajavalliKoteswararao 12 views 0 comments 0 points Started by GajavalliKoteswararao Reporting and Analytics for HCM
-
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
In Salary report midpoint and comp ratio but report showing wrong when Grade code changedSummary: Hi Team, have direct column in salary report, midpoint and comp ratio but report showing wrong when Grade code changed . please any on help me on ? PFA. Thanks,…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary sql statement to get the performance document current taskContent Can anyone help me on how to fetch the current task for the employee performance document , the…MahmoudAllam 3.1K views 9 comments 0 points Most recent by User022-Oracle Reporting and Analytics for HCM
-
Query to get Questionnaire answers given by user and right oneContent Hello experts. I need a report for learning assessments. This report is to get the learning item - task assesmment - questionnaire - answer - right answer (based…Pedro Teixeira 1.7K views 7 comments 0 points Most recent by User022-Oracle Reporting and Analytics for HCM -
what is difference between CMP_ASG_SALARY_V and cmp_salary ?Summary: Hi Team, what is difference between CMP_ASG_SALARY_V and cmp_salary because of still cmp_salary showing corrctly of cs.COMPA_RATIO and cs.RATE_MID_AMOUNT column…AjayKumar Maddipati 42 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')Swati U 249 views 5 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
SQL to get Cost center mapped to countrySummary: Hello Everyone, I just want to ask for SQL on how to get the cost center who are mapped to country. Thanks,Michael_B 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Sql to find t4 information of employee (like tax year and boxes information etc)Summary: Dear exports, Any one have sql/otbi report to pull the information exist in canada t4 slip? Please suggest Content (please ensure you mask any confidential info…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Benefits Report of Terminated EmployeeSummary: Hi All, Does any one have a Benefits report of terminated employees which Shows their enrollments with Dates parameter? Thanks Content (please ensure you mask a…Naveen setti 11 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Is there a way to find out if the users really using the current assigned role that they have?Summary: In the Fussion application, we can pull list of users who has a certain data role. But we wanted to know who among those users in the list that are actually usi…Lorejean Gelacio 31 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report to fetch all position Name changes but the job remains sameSummary: I want to fetch a report for the position name updates when we have same job code Content (please ensure you mask any confidential information): we need to find…Rajesh Suvala85 22 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Error when scheduling Logical SQL ReportContent Hi all, I've scheduled quite a few logical SQL reports, but the two newest ones I've created (Change Value Reports) receive the attached error. Any ideas on what…User_2025-01-31-00-25-12-234 29 views 5 comments 1 point Most recent by Neysan Mohajer Reporting and Analytics for HCM
-
Need dashboard prompt based on field with complex formulaSummary: I have a report on a dashboard that has a field that gives me the highest level of education obtained by first ranking the degrees on the employee's records and…
-
Sql Query to get payroll deduction detailsSummary: I am looking for a query which provides terminated employees last earnings and deduction details from payroll. Content (please ensure you mask any confidential …Rahul K-Oracle 441 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM