SQL
Discussion List
-
SQL Needed for DatesSummary Calculating the later of two dates using SQLContent We are creating an OTBI report to figure out when to discard of hard copies of paperwork. To calculate the sh…Rebekah Gilday 51 views 1 comment 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
Time Card Status and Hours for AuditSummary Audit Time Card Status and HoursContent Hi, Can you please help me on time and labor audit details. I have a scenario where, 1. Employee First Entered 24 hours f…Darius Sunder 249 views 2 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
SQL for disciplinary & PIPSummary SQL for disciplinary & PIPContent Hi, I'm building a BIP report, I need to capture details from Disciplinary & PIP under Person Extra Information I would appreci…
-
Need query to get the data loaded through HDL FileSummary Need query to get the data loaded through HDL FileContent Hi Experts, Greetings of the day!! We have loaded the Element entries to employees through HDL via diff…Charan Kollipara 624 views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM
-
Dashboard Prompt values in format YYYY-MM using TO_DATETIMESummary date formatsContent hello, Looking for some suggestion on date format conversions in dashboard prompt, here is my scenario: One of my dasboard has a month prompt…SantoshKumarBhairi 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Retrieve top 2 records per employeeSummary Need to figure out a way to determine the top 2 records for an employeeContent Hi All, I am read through some posts but still haven't found a solution for what I…PamS 39 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Insert the profile image in a BI Publisher report dinamicallyContent Hi, I need to show the employee profile image in a report built using a .XLS template in BI Publisher. The field I'm using is "IMAGE" (BLOB type) from the table …
-
Creating a BIP report based on a Procedure CallSummary Creating a BIP report based on a Procedure CallContent Hi Team, I need to create a BIP report based on a Procedure call. Is there any documentation available aro…MandeepKGupta 340 views 3 comments 1 point Most recent by Abhishek Nigam Reporting and Analytics for HCM
-
Location Transfers during the current yearSummary How to get the location for the first of the year and any changes throughout the yearContent Hi All, I have a requirement to pull in changes to an Employees Work…
-
Oracle BI publisher - Which tool oracle is decommissioning ?Summary Hi Team, Can you please confirm which part of BI publisher is going to decommissioned ?We are planning to move fully in OTBI but need BI as wellContent Hi Team, …User_VEQF1 46 views 6 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Report on Remuneration Managers of Employees using matrix manager from Workforce Management - WorkerContent Hi Experts, I am trying to create an OTBI report listing all employees and their Remuneration Managers using matrix manager from Workforce Management - Worker as…
-
Scheduled Report FailedSummary Scheduled Report FailedContent Hi Experts, Greetings of the day. I have scheduled a custom BI report and it has been failed with the below error after running lo…Charan Kollipara 60 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for HCM
-
Determine Time in Current and Previous positionsSummary Progression report that shows how long an employee has been in the current position and how long in the previousContent Hi All, I am hoping someone has a solutio…
-
OBIEE BIP Report LogSummary Where to find report log which shows SQL that's generated by report while report executionContent Hello Everyone, I'm trying to find log of a BIP report which I …
-
Need a report for AOR with scope of responsibility ?Summary Need a report for AOR with scope of responsibility ?Content Hi Team, Need a report for AOR with scope of responsibility ? I need to create a report for AOR but n…
-
Seeded Lookups with their values in HCMSummary Need a list of lookups with their valuesContent Hello, I need a seeded list of lookups types with their values, I was not able to find it in any subject area so …Akanksha Jain 41 views 3 comments 2 points Most recent by Akanksha Jain Reporting and Analytics for HCM
-
Account Segments Report ExampleSummary Account Segments Report ExampleContent Hello all We need to develop a report about Account Segments. We made it by Query and it is bringing the correct informati…Pedro Teixeira 20 views 2 comments 0 points Most recent by Pedro Teixeira Reporting and Analytics for HCM
-
Conditional Formatting in Pivot TableSummary Colour by Absence Type working in Table but not pivotContent Hi I'm trying to show a calendar for this month and next month. The number of days/hours shows corre…
-
Query Data Model securitySummary Example of query or config to allow data models be displayed to all employees without them seeing whole company data.Content Hello all When a more robust report …Pedro Teixeira 40 views 6 comments 1 point Most recent by Pedro Teixeira Reporting and Analytics for HCM
-
Looking for National Insurance Category LetterSummary I am looking for the NI Category LetterContent Does anyone know where in the tables (OTBI or BIP) I would find the National Insurance Category Letter? Just to cl…
-
BPM tablesSummary BPM tablesContent Team, BPM tables (FND_BPM_TASK_VL and FND_BPM_TASK_ASSIGNEE) have the initiated_by column as null or blank for few transaction? Could you help …acmhari 218 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to show 2 sets of data based on dates selected by the userSummary Report needs to show several fields for different dates(not necessarily the current and previous values)Content Hi All, I have built a query that returns data ba…PamS 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Check-In Performance Template BIP table Joins.Summary Can anyone please explain how goals and its feedback are tied/joined to check-in peformance template for reporting purpose using BI Publisher.Content We have a B…User_0REWN 69 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
PER_JOBS_F.APPROVAL_AUTHORITY Translate ValuesSummary Trying to pull in the Name (translate value) for the Approval Authority code on JobVersion 20B
-
SQL Query to fetch Talent Profile History DataSummary SQL Query to fetch Talent Profile History DataContent Hi Experts, How to fetch Talent Profile History Data. Please provide SQL Query. Regards, Bala Version 20ARaviteja Sompalli 343 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…Akshay Agarwal 32 views 3 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
SQL to pull Previous Line ManagerSummary Sample SQL to pull Line Manager from the Previous Assignment RowContent We have created a data model that pulls most current assignment row where actions = Promo…
-
How to identify resubmitted goals for approval?Content Hi, I am creating a goal status report where I am able to get proper goal status from the table HRG_GOALS with column GOAL_VERSION_TYPE_CODE except for those who…Nivya Mathire 56 views 6 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
User Role Historical DataSummary Getting the Historical data of RoleContent Hi, Is it possible to get the historical data of User Role in HCM? We are not using the End_date on the user role, but…
-
Logical SQL not recognizing Custom Fields in OTBIContent Morning all, I'm amending the Logical SQL for a report, but every time I try to reference our custom fields, the report errors out (see picture). It recognizes O…Evan Jenkins 30 views 4 comments 1 point Most recent by Evan Jenkins Reporting and Analytics for HCM