Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
BI SQL FILTERWhen I search for a code in a filter, it correctly returns two values—as shown in the query below—but when I select both, only one code appears in the list of selected v… -
Zip File for 'Identifying Authorized Hosted Named Users' no longer available?Summary: Hi, I used to be the primary person managing Oracle Licenses and would utilize the 'Identifying Authorized Hosted Named Users' reports which provided the follow… -
Export to excel for an OTBI analysis in Guided JourneysSummary: We have deployed an OTBI analysis in Guided Journeys that would be most useful if the user could export it to excel. Is there a way to incorporate this feature … -
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl… -
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
Display a Document of Records Image in a BIP ReportSummary: Hi All We have a requirement to display photos stored in Documents of Record within a BI Publisher (BIP) report. Has anyone implemented this before or can provi…
-
Subject area for last log-in by user reportSummary Is there a subject area where I can pull the last time a user logged in?Content There's been a request by a department in my organization to see what employees h…
-
DOCX Output Does Not Preserve Image Alternative Text from RTF TemplateWe are using Oracle Fusion HCM BI Publisher with an RTF layout template. Images in the source RTF contain valid alternative text. The alternative text is present when th…
-
Which HCM Extract DBI to use to fetch full state name (region2) from person address?Summary: Extract_address_region2 and address_region are giving only short forms of state. Is there any other way? Content (please ensure you mask any confidential inform…
-
In BIP, when clicking on the download button in PDF output, an HTML file is downloadedSummary: The issue is when clicking on the download button in PDF output, an HTML file is downloaded instead of a PDF. Would there be any setting to set in the BIP repor… -
HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO does not show some person recordsSummary: HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO and HcmTopModelAnalyticsGlobalAM.PersonAM.PersonDetailsPVO does not show some records though they are avai…
-
Role/privilege is required to retrieve Position Code from OTBI "Position Real Time" in BI Publisher?Summary: Hello Experts, I am trying to retrieve Position information from OTBI subject area Workforce Management - Position Real Time through a BI Publisher Data Model. …
-
Legislation of Absence Type not visible in dropdown in Time Entry Layout Components taskSummary: How to identify which legislation does the absence type belongs to in the time entry layout components task while selecting absence management type? Content (pl…
-
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve… -
Oracle Fusion HCM Fast Formula Compilation Issue – PLSQL_CREATED = N and Missing Database ObjectsSummary: Hi All, We are currently facing a compilation issue with one of our custom Fast Formulas in Oracle Fusion HCM. I would appreciate any guidance from the communit…
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…
-
Looking for SQL to Retrieve BI Report Job History and Deleted Job History in Oracle FusionHi everyone, I have a requirement to retrieve BI Report job history using SQL in Oracle Fusion. I also need to identify or retrieve deleted/removed BI report job history… -
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i… -
What is the field name of checklist status?Summary: Content (please ensure you mask any confidential information): Unfortunately it is not per_allocated_checklists_vl.CHECKLIST_STATUS, any other idea? Version (in… -
Not able to return Questionnaire information from Performance Subject AreaSummary: I have created a new performance document but am unable to have any data returned from the workforce performance - performance rating real time subject area. Co… -
BI Publisher Report - Disable Schedule Report option for ESS/Employee roleSummary Ways to disable Schedul Report option for the users with only ESS/EmployeeContent Hi, We have developed a custom BI Publisher Report, the access to which, will b…
-
OTBI Subject area accessSummary How to limit the subject area accessContent Hi , How do i hide or delete the subject areas that i dont want the Line Managers to see in the Reports and Analytics… -
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten… -
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with …
-
OTBI Report on Performance Goal Tasks within a Goal PlanWe need an OTBI report for Employee Performance Goals and Goal Tasks. It must include the Goal Plan Name so we can tell which Goal Plan the goal was created in (we assig…
-
OTBI Data Security Not Aligning with HCM UI Security ProfileDear Team, We have a business user who has been assigned a security profile that restricts access to view only employees within a specific AOR or Legal Entity. This secu… -
Dashboards that shares the health status of integration batches, scheduled loopbacks, notificationsSummary: Dashboards that shares the health status of integration batches, scheduled loopbacks, notifications Content (please ensure you mask any confidential information… -
Assignment Manager (Unsecured) significantly slower in Workforce Performance Subject AreasSummary: Material / significant slowness that appear to be driven by [Assignment Manager (Unsecured)] folder within Workforce Performance Subject Areas, relative to othe…
-
Oracle HCM Reporting - Disable or Hide Parameter Based on Selection of Another ParameterSummary: We have two report parameters, Payroll Name and Consolidation Set, and need to make them mutually exclusive. When a value is selected for Payroll Name, the Cons…
-
Can't get Scheduled Hours of employee that shows on OTL Time Card into OTBI ReportSummary I need to get field Scheduled Hours per week that shows on employee time cardContent Hello , I assigned a work schedule to worker and I need to get value of Sche…