SQL
Discussion List
-
Adding run_result_values for multiple element_names in OTBI analysisSummary Need help in OTBI analysis with adding the run_result_values for different element_namesContent Hello Everyone, I am new to OTBI analysis and I need help with co…GauravGupta39 15 views 3 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM -
Post 21B release HRC_TXN_DATA.Data cache column doesn't show XMLSummary Approved/Rejected Global transfer transaction XML data is not coming up in HRC_TXN_DATA data cache column.Content Hi All, We are aware of HRC_TXN_DATA data cache…Hari Arumugam 40 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
SQL to Pull Most Current Ethnicity recordSummary Looking for BIP Data Model that will select the most current EthnicityContent Hi, I am creating a data model of person information and have been challenged when …Denise Izzi 1.2K views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Retrieving Affected Party column in HRHDContent Sharing the data model for reference and for others to benefit. This column was unavailable in OTBI at the time the report was built.User_2025-02-10-08-27-16-805 32 views 6 comments 1 point Most recent by Noopur Sapatnekar Reporting and Analytics for HCM -
Calculating Month difference between DatesContent Hi, I have Data looks like bellow . Emp No. Occurrence Partnership Level Partnership Level Date Months Difference 1 1 Level1 1/1/2006 Months (12/1/2007-1/1/2006)…User_2025-02-07-19-03-14-525 38 views 6 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…Devanshi Fulvani 28 views 2 comments 0 points Most recent by Devanshi Fulvani Reporting and Analytics for HCM
-
Candidate and questionnaire JOIN BIP reportContent Hi,How to join the questionnaire and answers to a specific candidate in BIP.does anyone have a working SQL that can share ? Thank YouAwadhendra Tripathi 35 views 1 comment 0 points Most recent by Juan Rendon Reporting and Analytics for HCM
-
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…GauravGupta39 51 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
questionnaire joins to the candidate in BIPSummary how to join the questionnaire and answers to a specific candidate in BIPContent Hi, I am developing a report in BIP which displays the questions from the questio…Iann hick 43 views 5 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
RTF TemplateContent Scenario: I have created two data sets in my data model: G1 and G2 G2(Parent) G1(Child) Parent will always have one row and its corresponding child can have a ro… -
Create Custom Subject AreaContent Hello experts We need to do a dashboard with an easier layout to deal with. and better UX then Publisher native Is it possible to use a query and create the subj…Pedro Teixeira 25 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 47 views 2 comments 1 point Most recent by Rajesh Ravikumar Reporting and Analytics for HCM
-
Oracle Documents of Records linkContent Hi Guys, Is there a OBIEE BIP SQL CODE code that can turn the column value into a clickable link, please see image for reference. Here's my current sql code. tha…User_2025-02-05-11-53-59-507 32 views 2 comments 1 point Most recent by Seiichiro Yasui Reporting and Analytics for HCM
-
Base Salary and Payroll elements tablesContent Hello experts, I need to extract by SQL compensation data for a specific employee. Do you know in which table I can find the following information: -Base Salary …Valerio Curzi 44 views 5 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Need query to pull finalised or processed pay period namesSummary Need query to pull finalised or processed pay period namesContent Need query to pull only finalised or processed pay period details?ViswanathaReddyKetireddy 30 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla…User_2025-02-04-13-27-19-123 119 views 4 comments 0 points Most recent by User_2025-02-04-13-27-19-123 Reporting and Analytics for HCM
-
HCM Audit tablesSummary Need to find a table where audit information will be stored.Content Hi All, I need to find the tables where audit data is stored. Columns such as Data, User, Eve…User_2025-02-10-16-28-01-402 1.5K views 2 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
Database Table and Database Column for Target Bank presentation tableSummary Need the parameters to build a BIP report for outputContent I am building a report that displays as a form completed for each new starter however it will not out…Dawn Cawston - CPS 30 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Query to pull earnings balance for each assignmentContent Need help on pulling earnings balance for each assignment or identifying which assignment has earnings.Renzel Keith Coquia-204674 54 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Disclosure for DiversitySummary Diversity TrendContent Hi Experts, We are trying to track diversity eg. Gender , ethnicity, Sexual Orientation, Disability etc over time Has anyone attempted thi… -
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 54 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 732 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