Category 81
Discussion List
-
Sum Parts of a ColumnSummary: We have a table with the %age of absence per absence name however on the pie chart, I need to sum the ones that are at the lower end of the spectrum. Content (r…Dawn Cawston - CPS 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Custom Recruiting Dashboard To Provide Global and Restricted View of InformationSummary: My customer have requested a Recruiting dashboard with a summary page with target stats on the recruiting process (time taken to move from one phase to another,…Thaddeus Inekuku 22 views 2 comments 0 points Most recent by Thaddeus Inekuku Reporting and Analytics for HCM -
Create a report to show both accrual values for an employee and absence value for an employeeSummary: I want to create a report, that shows how much holiday an employee has left on their balance, and in the same report show how many days of absence an employee h…Nicolas Vahman 13 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
What is the Subject Area for the new MCR fields?Summary: Trying to locate the Role_identifer and the Teacher Reference Number. They are both showing in the employment screen but cannot find them in the assignment subj… -
HCM Cloud question - Consolidation of BIP Report Stage from different flow submissionsSummary: HCM Cloud question - Consolidation of BIP Report Stage from different flow submissions Content (required): Hi Team, Greetings! We have a question in terms of so… -
How do I translate a PDF layout template?Summary: I have a very large PDF which is to be eSigned using journeys. I need to keep the PDF format because the RTF version of it ends up being over 100MB and unsuppor…
-
Ability for an employee to run a report from talent profile page with Badge outputSummary: Ability for an employee to run a report from talent profile page with Badge output Content (required): We are in the process of implementing learning module and… -
How to identify the tables updated by transaction in Fusion HCM?Summary: Hi Team, Is there a way we can identify the backend tables affected by a transaction done in application. For example Hiring an employee, in this case how to id…
-
Can we report on screening questions responses?Summary: Is there a possibility to report on screening questions in OR? I am not able to find them in the subject area. i.e. the yes or no responses Content (required): …Mitch_123456 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Prompts-How to restrict the values of other fields based on the values selected in other fieldsSummary: Hello, is it feasible with OTBI prompts to restrict the values of other fields based on the values selected in other fields? Example: AMNS India BU = Department…Hazel De Castro 26 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
HCM User Interface to OTBI Subject Area MappingSummary: Hi all, I am always grateful to the invaluable assistance, insight and support of the customer connect community. I have no idea if this will be of use and this…User_2025-02-11-05-19-35-410 31 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can I locate the new MCR fields for the Responsive UI?Summary: I am looking for the new fields Role_Identifier and Teacher Reference to add to the Responsive UI, but am not sure how to find them Content (required): Are the …Mark Stoker 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Use of MAX function to get current Tax CodeSummary: I need to tweak a repot which shows all the tax codes under one employee with dates against them, however I just need the current tax code that is applied. Cont…
-
Termination Date less than and greater than 3 months of current dateSummary: I'm trying to work out how to write a formula for a Leavers report that will bring back everyone who has left the department in the last 3 months and projected …
-
OTBI Agent ScheduleSummary: We encountered an issue today with a monthly report that is scheduled to run at 7 AM EST ran and delivered the report at 2 AM. Have anyone encountered this issu…
-
which table in fusion hcm tracks changes to user status from Active to inactive and vice-vercaSummary: which table in fusion hcm tracks changes to user status from Active to inactive and vice-verca Content (required): which table in fusion hcm tracks changes to u… -
Need link for questionnaire template and subscriber for LearnSummary: Hello everyone, I need to find questionnaire template and the subscriber it is linked to. I was able to find 4 tables related to questionnaire and subscriber. I…
-
Most recent status of candidates along with reason of rejection if anySummary: In recruiting, when creating a report with most recent phase and state of a candidate job application along with rejection reason if any, the report generates d…
-
Min and Max columns on Assignment Effective Dates are blank in OTBI analysisSummary: 'Latest Assignment Start Date', 'Earliest Assignment End Date' columns showed data while building the report. After adding more columns and filter condition the…Vinay Hardas 255 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Refine ExtractSummary: Hi , I am developing an HCM extract where I need to have 2 parameters in the extract. I have never worked on the refine extract and need input on the same. Than… -
Performance Document Eligibility disappears in the new year/ Where to go for data related questions?Summary: Performance Document Eligibilities are disappearing in previous years. Where can we go to find reasons why the data is disappearing from reports? Content (requi… -
Getting Invalid URL Error while adding the BI report URL as embeded content in the dashboardSummary: I am trying to add the existing BI report to in the dashboard.Though i ma providing the correct BI Report URL while adding embedded content i am still getting t…minati_behera-Oracle 11 views 0 comments 0 points Started by minati_behera-Oracle Reporting and Analytics for HCM
-
Need to compare 2 columns in an OTBI pivot tableSummary: I'm wanting to find out if this requirement is possible within OTBI. I have 2 dollar amounts 1 for each date paid. I need to compare the 2 amounts and look for … -
How can I exctract Person Address ID field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Address ID field to overwrite employee home addresses by HDL. Is it possible to find this f…Valerio Curzi 32 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Wrap text issue in RTF templateSummary: Content (required): As per the client requirement, I am creating a BIP report. The output of this report should be available both in excel and PDF formats. So I…Prajna Hegde 1.2K views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM
-
Which is better: "Filters and Variables" vs "Results of another analysis"Summary: Are hidden dashboard prompts better than getting the results of another analysis? Content (required): When building dashboards, we occasionally have a need for …
-
OTBI usage dashboardSummary: Identifying OTBI usage for performance monitoring Content (required): Is there a seeded OTBI Usage Dashboard? Have seen below post and wondering if Oracle alrea…ZenG 33 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Reporting Name at Manage Department PageSummary: We are looking for Query to fetch Reporting Name at Manage Department Page,as marked in screesnhot below Content (required): Version (include the version you ar…Priyanka More-Oracle 165 views 2 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Any method to search for a keyword usage in the OTBI Reports or HCM ExtractsSummary: Any method to search for a keyword usage in the OTBI Reports or HCM Extracts Content (required): Hi All, We have the requirement to identify the reports and int…Parag Hiremath 35 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition…