Get Started with Redwood: Oracle Cloud SCM and Purchasing
Category 81
Discussion List
-
Candidate Pool Ownership TypeSummary: Content (required): Hello Guys, We would extract the Candidate Pool Ownership Type information from BI, but we don't find the correct table and field, someone c…Giuseppe Iacono 28 views 4 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Succession Plan BIP Report based on Job RoleSummary: Hello Experts, I have to create a Succession Plan BIP Report based on Job Role. Please help with a sample SQL/Report if you have worked on a similar requirement…Abhishek Premchandra-Oracle 75 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to use Hyperlink in RTF templates?Summary: Hello Experts, Is it possible to use Hyperlink in RTF templates? Like, in the report output, the Person Number attribute will have a hyperlink, once the user cl…Abhishek Premchandra-Oracle 566 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to split by page break with the date rangeSummary: Can we apply split by page break with in the date range? For example if we pass date parameters with in the 3 weeks date range, then report should pull 1st week…User_YPR68 23 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Session/repository variables available in OTBISummary: Hi there, Is it possible to find out what session/repository variables are available in OTBI? Thanks for your help in advance. VijayVijay Gorania 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM > Others tab > My Dashboard > End User Dashboard Does Not OpenSummary: HCM > Others tab > My Dashboard > End User Dashboard Does Not Open Content (required): Hello All, I will appreciate your support on the issue below: When the HR…
-
Is there a compensation event real time subject area similar to worker assignment event real time?Summary: Is there a compensation event real time subject area similar to worker assignment event real time? Content (required): We created a report using the worker assi…TerryM01 33 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Seeking confirmation of what is stored in 'question response answer text'.Summary: We currently use OBIEE and will migrate to OTBI later this year. I do not have access to OTBI to try this for myself :) . As part of the migration I am trying t… -
Application channelSummary: Mobile vs Desktop - Is there a way to report on how candidates are applying, whether it be on a mobile device or from a desktop/laptop? Content (required): We a…Mitch_123456 23 views 1 comment 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
How to split excel template into multiple sheets for each employeeSummary: We need to split the excel template into multiple tabs for each employee. For Example if any excel template has 3 employees in the output, then we need to split…User_YPR68 1K views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
in RTF how to use a parent attribute for comparison inside a child repeating group while summingSummary: In a rtf template we are trying to compare the value of child attribute to a parent attribute if the value matches then the sum of an child repeating attribute …Gadigeppa Boragalli 421 views 0 comments 0 points Started by Gadigeppa Boragalli Reporting and Analytics for HCM
-
Change LOV in Comp dashboardSummary: I am looking to add a LOV in the dropdown box for Out of the box dashboards available for managers under workforce compensation Content (required): Need to add …Manoj B. Cheruvathoor 31 views 2 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM
-
How to show a report in the user interface?Summary: How can I show a specific report/analysis directly to end users in different screens? Content (required): Basically I want to know how to show data to end users…Matti Bugge 22 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
we work in Hebrew environment but language changes to EnglishSummary: Our site work in Hebrew in most cases, when entering into reports and analytics many times the UI language changes to English Content (required): how to avoid t…Yechiel 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What filter can I use to only list the Last Assignment details for employees and not duplicate rows.Summary: Hello Community - I need assistance listing employees "Last Assignment" or "Latest Assignment" details. If someone was Rehired, or Terminated more than 1 time, …User_2025-03-07-05-24-33-733 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Any way to find that scheduled BI report is running or got struckSummary:Any way to find that scheduled BI report is running or got struck Content (required): Hi All, We have scheduled a Custom BI Report to pull some payroll related d…Charan Kollipara 21 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
How to split in two different columns an information through OTBISummary: Need to create an additional column for "Email type" Content (required): Need to have two different column for work email + personal email and not different row…Virginia M. Calvi 158 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to change path color for a node path in Hierarchy TreeSummary: Change color of the node path in Hierarchy Tree. Content (required): Hi All, We are creating a manager hierarchy tree report, our client wants to change the col…User_GFPRZ 34 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Tile counting assignments based on the sum of a flex field by assignment.Summary: Since upgrading to 22A we're having trouble with a performance tile used to count assignments based on the sum of a flex field we've designed and I'm looking fo…Rob F 22 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Remove filter values from Export to Excel from DashboardSummary: Content (required): I would like to remove the filter from a dashboard when exporting to Excel. As seen below there is a screenshot of the Excel export I made. …Nicolas Vahman 14 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
OTBI - Is it possible to retrieve working days per employee?Summary: Hi, We are using absence mgmt module (no time and labor) and one of the reports requires us to display how many days a month is an employee supposed to work (ba…HulyaAkan76 125 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
I have create a analysis on seniority subject area but few employees who have seniority are missingSummary: I have create a analysis on seniority subject area but few employees who have seniority are missing Content (required): how it can happen and where to start che…Yechiel 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
List of All reports in BI PublisherHi Experts, Do we have any table or web service that can list out all reports present in a BI Publisher instance? So far we have used: XXXXX.oraclecloud.com:443/xmlpserv…Aloka Bhattacharya 454 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Significance of SOURCE_ACTION_ID in pay_payroll_rel_actions tableSummary: Hi, At the time of using table pay_payroll_rel_actions , we generally put this condition in where clause: SOURCE_ACTION_ID is not null. I observed that in table… -
Effective DatingSummary: I'm using Compensation - Salary History Details RT subject area to get someone's salary as at 29-10-21 (so in that subject area I use the Salary Change DateUser_A80ZS 32 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Burst notifications are sent to inactive managersSummary: We have notifications to inform the current manager about the contract expiry dates of their employees. The OTBI was done using the Worker Assignment Real Time …Ridma Karunanathan 23 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY are unable to see their own development goals.Summary: Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY inherited by either ORA_PER_LINE_MANAGER_ABSTRACT role or ORA_PER_HUMAN_RESOURCE_ANALYST_JOB role are unable…Maciej Kozakiewicz 11 views 2 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM
-
Additional comments and Reason for joining can't fetch the OTBI reportSummary: Question test to response answer in Pivot Table format Content (required): Formula for Question test CASE WHEN "Checklist Questionnaire"."Question Text" = 'What…AjayKumar Maddipati 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Where to find in OTBI Calculation Card Start and End Date?Summary: Where can I find in OTBI Calculation Card Start and End Date? Content (required): Please see image below. I am using the "Payroll - Calculation Cards Real Time"…tiffnyc 33 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
I need to create a group or a bin based on 2 different columns. Is that possible?Summary: Group or bin based on 2 fields Content (required): I am working on turnover report and need to create groups or bins from a hierarchy tree value and a company b…Donna Valentine 44 views 3 comments 0 points Most recent by Donna Valentine Reporting and Analytics for HCM