SQL
Discussion List
-
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t… -
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 845 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 33 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 53 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 31 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 214 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 617 views 7 comments 1 point Most recent by Juhi Singh Reporting and Analytics for HCM -
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a…Valerio Curzi 1.4K views 10 comments 0 points Most recent by Robinson Ng 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.7K views 12 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 20 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 624 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…
-
Tables lock or obsolete statisticsSummary: Hello experts! It's possibile to verify if it's present a lock on a table o the statistics are obsolete? We have a BI query of a scheduled job that times out ra…Gian Luca Triglia 4 views 1 comment 0 points Most recent by Alexandru-Catalin Serban-Oracle Fusion Applications Administration
-
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 13 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 713 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.3K 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 12 views 2 comments 0 points Most recent by Swati Rana2805 Reporting and Analytics for HCM
-
How to find out who/when edited BPM Worklist about Access ActionsSummary: What are the tables/views enable us to find out some audit info that who and when have edited the BPM worklist, e.g. ApprovePerformanceGoal, about the Access > …Hellen Zhao-5941 2 views 0 comments 1 point Started by Hellen Zhao-5941 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 227 views 4 comments 2 points Most recent by Atta Oduro Reporting and Analytics for HCM