Category 81
Discussion List
-
How to search for text string across all BI componentsSummary: Content (required): I need to find all BI data models and report templates referring to specific attributes. Has anyone tried to do this, or have an idea how we…Scott Paulin 45 views 11 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM -
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 25 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 28 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 20 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…Parag Hiremath 6 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
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… -
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 16 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 36 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 27 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 274 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 16 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 37 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.3K 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 37 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 189 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 37 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…