Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
The custom report spacing is not aligned in PDF and Word formatSummary: A custom report is built for the contract purpose. With the PDF version, the format and the spacing are accepted by the UAT. When the report is generated in a W… -
Ethnicity DashboardSummary After applying "Two or more races" code, ethnicity count gets incorrectContent Applied "Display Ethnicity" logic code as per the post below to fix "Two or more r…
-
OTBI Report for EthnicitySummary OTBI Report for EthnicityContent Hello, CASE WHEN COUNT("Worker"."Employee Ethnicity Code" BY "Worker"."Person Number")>1 THEN 'Two or More Races' WHEN "Worker".… -
Is there a way to use environment-aware variables for dashboard action links?Summary: Instead of hardcoding urls for dashboard action links, is there an environment-aware variable that can be used? For example, instead of https://sample-dev2.xx.x… -
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…
-
Assignment Manager Prompt - Direct and Indirect ManagersHi all, Does anyone know if its possible to use Assignment Manager as a prompt for a dashboard and also include the full direct and indirect managers for the user? At th…
-
Footer is not displaying when data of custom report is output in WordSummary: Footer is not displaying when custom report is exported to Word. What is causing the footer to disappear when report is exported to Word? I can see the footer w… -
ORA-20001:An internal assertion test couldnt be completed at location pay_balance_pkg.chk_rel_actionSummary: Custom BIP report is developed and It is not working from ESS job. Note: When it directly run from BI Publisher is working. Error: Waiting Time: 2 seconds Trigg… -
Scheduling analysis for last day of monthSummary: Analysis schedules for end of month Content (please ensure you mask any confidential information): Hi everyone, Is there a way to schedule reports (analysis) in…
-
Custom Schedule Reports,BICC extract and Custom HCM Extension also impacted on emps to workers apiSummary: I have concerns regarding emps to workers api change, Below objects also impacted or not Custom scheduled reports? BICC extracts? Custom HCM Extensions? Content…
-
difference between event and real time subject areasSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
address purpose Filed and table locationSummary: Looking to add the address purpose field into a previous BI report Content (required): I have a previous supply report i had built in BI publisher, a recent req… -
OTBI > Ability to AggregateSummary: OTBI > Ability to Aggregate Content (please ensure you mask any confidential information): Hello All, In order to prevent the repetition of the Time Card Commen…
-
Data Model for Report on the Learning Alerts sent with detailsSummary: Content (please ensure you mask any confidential information): Hi there, how can I get a BI report (Data model) that will give me details on these alerts? I hav… -
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat…
-
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…
-
Facing issue in RTF template(This exists with maximum width.)Summary: Trying to add two new extra fields in the existing RTF template is giving an error. (Error: This exceeds the maximum width.) Content (please ensure you mask any…
-
Write a BIP report query in which termination records should be picked only once in output fileSummary: My requirement is: I have to write a query in BIP report to fetch the current and future hire employees, and termination records should be picked only once. The…
-
Report footer not showing completely in report outputSummary: Report footer not showing completely in report output. My client wants to display this footer on all the reports. When I run the report then everything in the f…
-
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. … -
Learning Access Group Organization Chart Selection Method Details -BIP Table mappingSummary: We have a requirement to develop BIP report for all learning items where we need to fetch the name of selection method for Organization Chart Criteria. We have …
-
How to add Calendar chart in OTBI Analysis under Learning Module?Summary: Hi Everyone, I have a requirement to implement a Calendar Dashboard that has an identifier if an activity is scheduled for that date - e.g. turns green if class…
-
Number of attempts by each learner are not showingHello, I need to get the number of attempts that a learner did on a course. Example below: Offering Title: JV Test 01/18_SP Person number: 001670007 1st attempt - 50 2nd…
-
Recruitment questions in all blocksSummary: Hi , I would like to report on all questions in the pre-screening form for a candidate. The questions for the job requisition appear but not the questions in ot…
-
IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and viewsSummary: Need to build Onboarding - Overdue Tasks Report Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…
-
Candidate and Job Application Source-TrackingWe drew the statistics from the recruit to hire dashboard, and need clarification on how these are being collected and what those source mean. We inserted a pre-screenin…
-
how to join pay_tasks_vl table with person number?i wanted to fetch task name from (pay_tasks_vl) for a particular person but not getting how to join this table with person details
-
Using BI Publisher attempting for get Learner - Self Service Setting and if overwrittenSummary: Using BI Publisher tables I am attempting to get default access - learner serf-service setting on a catalog/enrollment and then see if it was overwritten at the… -
Privilege to Perform Location Changes from Manage in SpreadsheetWould there be a way to run a report of all active/inactive locations in Location Details? And would there be a way (with a privilege, AOR, or role) to download the loca…
-
How to display a prompt for Job Code on an OTBI Analysis?Summary: I'm trying to create a guided journey using an OTBI developed. However, I need the report to be prompted with the job code in the assignment area. I can't seem …