SQL
Discussion List
-
SQL query to get the child department of a parent department from the department hierarchy in BIPI have written below query where I have hardcoded Organization id for which I want to fetch the child departments from department hierarchy in BIP report but the query i…Anjali_Kumari4121 121 views 3 comments 0 points Most recent by B Casla Reporting and Analytics for HCM -
How to get the details like employee user name, person number and employee statusHi Team, We have requirement to see employee user name, person number and employee status in a report. Can anyone help me on this. Regards, RaviRavi-Palacharla-Oracle 387 views 4 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
SUBSTRING function to separate multiple Valid GradesSummary We are trying to separate each valid grade into a separate columnContent When pulling job codes and valid grades, all valid grades are in one cell. We would like… -
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re… -
Query/BI Report - Pay Elements Paid Past Term DateHi I am looking for a query/BI report that will show me pay elements that have been processed and paid past the employee's termination date. I tried searching the commun… -
Query to extract all the updates made on employees assignmentsSummary: Content (required): Hello experts, when accessing the employee assignment page, it is possible to see users making last updates. Is there a query to extract all…Valerio Curzi 991 views 6 comments 0 points Most recent by VivekKumarAgarwal_CZTR1 Reporting and Analytics for HCM -
Defaulting the date parameter value based on their native languageHi Team, We are facing some issue in the existing report. Below is the details of the issue. 1. In one of our report, we are defaulting the date parameter value as Last …
-
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 51 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
unable to find the table which stores the approver details for fusion bpm nor rest api, please helpSummary: Hi Experts We are unable to find REST API or fusion table to extract the approval rules and the approver details. Below is the more details Would like to extrac…zakir112443 71 views 1 comment 0 points Most recent by Pradeep Kumar Reddy V Reporting and Analytics for HCM
-
Include min function in value setSummary: Content (please ensure you mask any confidential information): Hello experts, I should manage the attached query in a value set. However in the VALUE COLUMN NAM…Valerio Curzi 42 views 11 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 221 views 16 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Can we access the file contents of UCM file in BIP Report?Content I have a requirement to read the contents of the file placed on UCM in BI Report and am struggling to find the right table for this purpose. In EBS there was a t…Sricharan Monigari 656 views 7 comments 1 point Most recent by Juhi Singh Reporting and Analytics for HCM -
Table to get Assignment change historySummary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer). From which tables we can…Venkatesan 1.9K views 12 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM Extract: Filtering XML Records based on Attribute ValueWe have an HCM Extract with multiple attributes, including BalanceValue, which is populated by a Fast Formula. We need to generate XML records only where BalanceValue is…
-
Need Table Storing Bank's "Active" Flag from Personal payment Methods ScreenHello, I'm trying to locate the backend table that stores the "Active" flag status displayed on the Personal Payment Methods > Bank Information screen in Oracle HCM (Sel…Jahnvee Sharma 31 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
In which table does the Candidate Job Application Fields are storedSummary: Hi Everyone I have loaded the Candidate Job Application into the system using HDL. So I'm trying to fetch those loaded fields using SQL for verification. Conten…Sujeeth Chinta 746 views 4 comments 0 points Most recent by Emerson Oliveira Reporting and Analytics for HCM -
HCM Extract and BI Publisher - GC overhead limit exceededTeam, We have a HCM Extract which is invoking the BI Publisher to generate PDF output. But we are getting an error and HCM Extract is not generating any PDF output. Erro…
-
Email Address FormulaHi Everyone, I am building a report for one of our HR partners. She is using the report as a file loader to put employee data in an external employee recognition platfor…
-
Is it possible to add a time zone prefix to an OTBI report?Summary: If I want my OTBI report's data to only display one specific time zone no matter the user's preferences, how would I do that for just one report? Could the pref…CCannadayCTR 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Current approval status table name for development goalsUnable to get approval status for development goal: Need a table name and SQL query for development goa approval status to check whether the goal is approved? rejected o… -
Trying to find a Link between Career Site and RequisitionSummary: We are trying to derive the career sites where a specific job requisition is published. Can you point us to a REST API which can provide this information ( alre…
-
Resource mapping Report: feasibility to append the Job Requisition URL with external Site detailsIs there any feasibility to append the Job Requisition URL with the external site name details for tracking the candidate flow from the source website.(E.G; LinkedIn, In…Suneetha Narisipuram 21 views 2 comments 0 points Most recent by Pandey Roma Reporting and Analytics for HCM
-
Payroll register dynamic BI reportI have a requirement to get the below records in payroll register report(dynamically). Person Number|| 1|earning element run result values| deduction…
-
SQL Query to get calendar attached to employee .Summary: Dear Team: We need to get the calendar details for an employee. Navigation is Login as an employee→Time and absences→Calendar Content (please ensure you mask an…
-
Element entries related to the current assignmentContent Hi Team, We are generating an offer letter for the candidate once they become a pending worker. For that we are getting the data from the element entries table. …Shikha Agarwal 753 views 4 comments 1 point Most recent by Ashraya S.N Reporting and Analytics for HCM -
HCM Table to connect payroll run result values to an employee assignmentSummary Need help with finding a table or column which can tell payroll run result values ran for an assignment_idContent Hello Everyone, I am in middle of editing an SQ…GauravGupta39 1.4K views 3 comments 0 points Most recent by Ashraya S.N Reporting and Analytics for HCM
-
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
Query to fetch structural details of the admin pages and the EL Components used within themSummary: Is there any way or Query to fetch structural details of the admin pages and the EL Components used within them Content (please ensure you mask any confidential…Swati Rana2805 11 views 2 comments 0 points Most recent by Swati Rana2805 Reporting and Analytics for HCM
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 268 views 4 comments 2 points Most recent by Atta Oduro Reporting and Analytics for HCM