SQL
Discussion List
-
Employee Headcount by Business Unit BI Publisher reportSummary Employee Headcount by Business Unit BI Publisher reportContent Hi Experts, I'm looking BI Publisher ( not OTBI since Headcount is not properly setup in our organ…User_2025-02-07-19-03-14-525 38 views 6 comments 0 points Most recent by Ninja Reporting and Analytics for HCM -
Generate Workpattern code like NYYYYYNSummary Generate Workpattern code like NYYYYYNContent Hello I am trying to generate an understandable work pattern code like NYYYYYN for reporting. Any quick pointers ho…Murthy Kodavati 21 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for HCM -
BI report to extract Status information for Absence ManagementSummary Any pre build report to extract absence type and status information for Absence Management?Content Hello, If anyone has any pre build report/query to fetch the d… -
OBIEE SQL and Listagg functionSummary Need to display a list of degrees and certifications in a list for a reportContent Hi all, I am trying to produce a list of certifications and degrees for each e…User_2025-02-04-08-51-08-912 56 views 2 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Session Timezone in BI PublisherSummary BI publisher not using the timezone from the Account screenContent I've found that the CURRENT_DATE in BI Publisher isn't applying the timezone entered on the us… -
SQL query help needed - Payroll tablesSummary Reporting on those employees who have had a garnishment added in the selected payrollContent Hi All, I hope someone is able to help me out. I am trying to debug …User_2025-02-04-08-51-08-912 18 views 1 comment 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Query to fetch data model output in hdl formatContent We are trying to automate HDL process using BI publisher report and Extract. Data model query to include output for Worker dat file with two metadata lines (Assi…Kavya Sreenivasulu 746 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
How to read Context Segment DFF and associate it to employee record?Summary How to read Context Segment DFF and associate it to employee record?Content Hello, I have information stored in the assignment attribute 2 of the PER_ASG_DF DFF …Nicola Petri 24 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Time Card approver details for multiple AssignmentSummary Require Approver details for each assignment hours in Tiime CardContent Hi Team, I have a requirement to get the approver details for each assignment hours in th…User_2025-02-04-13-27-19-123 22 views 2 comments 0 points Most recent by User_2025-02-04-13-27-19-123 Reporting and Analytics for HCM
-
How to get Level (distance from CEO) in a BI reportSummary How to get Level (distance from CEO) in a BI report (i.e. CEO direct report is Level 1)Content Hello, do you have a query that extract the level? The level is th…Nicola Petri 27 views 2 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Pull data between 2 dates using Subject AreasSummary Pull data between 2 datesContent Good Evening, Has any one had luck with pulling historical information in between 2 dates? For example, we had someone who was o…User_2025-01-23-21-37-42-476 39 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Learning Assignment Event TypeContent Hello Experts. I need to do an Analysis that gives me if the course assignment is Required or Voluntary. I was Unable to map it into the Workforce Learning - Lea…Pedro Teixeira 57 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is it possible to created Facts/Measure in Logical SQLSummary Is it possible to created Facts/Measure in Logical SQLContent Hi all, I need to pivot and show percentage of a column but seems like it is not possible to create…Raymund Jerome 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Data Model: finding all reports that this is attached toSummary How to know all the reports that use xyz data model?Content Hello, I have a data model in BI Publisher. I assume 3 reports are connected to it. But how can I be …User_2025-01-28-21-53-32-678 29 views 3 comments 2 points Most recent by User_2025-01-28-21-53-32-678 Reporting and Analytics for HCM
-
Edit Grand total in pivot tableContent Hi there, we made a Pivot table in OTBI analysis with pay elements in column. We have been able to add the Grand Total of them but we would like to exclude an el…Chiara Arcidiacono 25 views 7 comments 1 point Most recent by SimonTomey Reporting and Analytics for HCM -
Compensation Components table for BIContent Hello experts, do you know the Oracle tables to extract compensation components values and components name? Thanks in advance for your time! Kind Regards, ValerioValerio Curzi 36 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query to fetch BIP report job historySummary Query to fetch BIP report job historyContent Hi Team, Is there any query from table to fetch the BIP report Job History. Thanks, Sourav
-
Query to exctract Person Email addressesContent Hello experts, do you know the query to simultaneously exctract the following information? EmailAddressId|PersonNumber|EmailType|EmailAddress|DateFrom|DateTo|Pri…Valerio Curzi 25 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BIP | SQL query to get details of the employees belonging to departments below the selected departmContent Requirement: 1) Report should display employees belonging to the departments of the selected organization type. 2) Report should also display employees belonging… -
BI report to extract time informationSummary Any pre build BI report to extract time information available?Content Hello anyone has any prebuild report to read Time information? Thanks, Nicola
-
Is there a way to round-off numbers and truncate dates in simple XML outputs?Content hi. I can't seem to find a way to round-off numbers and truncate dates for simple XML hcm extract outputs. Is it possible?notautomni9 22 views 6 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for HCM -
SQL query to get offering start date and end date in learn module in fusion HCMContent Hi All, I am working in a requirement where I need the following details: Offering Name, Offering start date, Course Name, Person number enrolled in the offering…Mani Venkataraman 1K views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM
-
Dependents not enrolled in Benefits SQL HelpSummary Dependents not enrolled in Benefits SQL HelpContent Hi All, I have a query that I use in a BIP report that is supposed to be determining if a dependent is going …User_2025-02-04-08-51-08-912 107 views 1 comment 0 points Most recent by Nagaraj Hunur-Oracle Reporting and Analytics for HCM
-
Oracle SQL - Display rows as columns - Many to Many RelationshipSummary Oracle SQL - Display rows as columns - Many to Many RelationshipContent Good day! I need some guidance if I want to do is actually possible in Oracle SQL. I have…Raymund Jerome 36 views 2 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Need SQL Query/ table names to get Source System ID for person's areas of responsibilitySummary Need SQL Query/ table names to get Source System ID for person's areas of responsibilityContent Hi All, What I need is to get Source System ID for person's areas…Dhanuka Chamal 3K views 6 comments 2 points Most recent by Dhanuka Chamal Reporting and Analytics for HCM -
how to extract sql query in data modelSummary how to extract sql query in data modelContent Hi, I wonder if there is any way to extract SQL Query in Data Model using table/web service/etc. Regards, Suyoung V…Suyoung 37 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
In which table is the issued by field for license and certificate for talent profileSummary issued by field for license and certificateContent In which table I can see the full entry for issued by field for license and certificate ? I can only see the a…
-
how to default the date parameter in BIP report with sysdate-1 hourSummary how to default the date parameter in BIP report with sysdate-1 hourContent Hi All, Could any one help me in defaulting the date parameter in BIP report with an h…User_2025-02-06-09-41-56-955 380 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
SQL for w4 tax Calculation card -2020Summary SQL for w4 tax Calculation card -2020Content Hi Team, We need a SQL to fetch the all fields in w4 tax calculation card 2020 -Federal form. Can you please share i…User_4VVG2 418 views 3 comments 0 points Most recent by Parupally Srikanth Reporting and Analytics for HCM
-
How to find failed transaction on a person numberTSummary Transaction console failed transaction columnContent Which column will store the failed transaction status. How to find failed transaction on a person numberKammarapalli Venkatesh-Oracle 20 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM