Category 81
Discussion List
-
Not able to add dashboards objects and OTBI contents on Dashboard pagesSummary: I am trying to create one dashboards using analysis but when I created one dashboard and trying to add column sections and other dashboards options on dashboard…Kamini Kaushik-Oracle 21 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Output from BI Report is not fully getting passed to HCM Extract in the flowSummary: We are working on the process with the flow including the first step of HCM extract execution which calls BI Report to generate the data in HDL format and then … -
Dashboard- Headcount to be represented as a % - By Length of Service per GradeSummary: I am looking to represent length of service per grade as a bar graph showing % of headcount . I am able to achieve this when using stacked 100% or presenting th…Anita 41 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Employee Phone Numbers Comparision ReportHi Experts We have client requirement for design a report which pulls up Employee details along with their work and home phone numbers. The inputs are Start Date and End… -
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'Summary: When trying to replace HRC_TXN_DATA.DATA_CACHE with HRC_TXN_HEADER.XML_DATA_CACHE; facing error - ORA-06553: PLS-306: wrong number or types of arguments in call…Priyanka More-Oracle 321 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How is the security defined for the analytics "Recruiting Real Time"Summary: I am trying to create a analysis using the subject are - "Recruiting - Recruiting Real Time". The user has administrator access and role to view all job requisi…Shikha Agarwal 31 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Delete Fusion Report Job Which is scheduled in Other AccountSummary: Delete Fusion Report Job Which is scheduled in Other Account Content (required): We have requirement to delete the report job which is scheduled in other user a…Vasanthakumar Ravi 41 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Can you tie Worker Assignment Event Real Time to the HCM Approval Notification area?Summary: We have a request to pull all terminations during a defined time period for a certain Business Unit and then show when the termination transaction was initiated…Cheryl Burwell 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
What table ties a job requisition to a candidate?Summary: I am trying to recreate a seeded report that is not working in HCM/ORC, and am just trying to tie a candidate to a job requisition. Does anyone have any clue wh…User_2025-02-10-17-54-21-557 21 views 3 comments 0 points Most recent by Juan Rendon Reporting and Analytics for HCM -
OTBI - Not returning Most Current Assignment RowSummary: OTBI - returning more than just the Most Current Assignment Row. This began happening after our 21C update. Content (required): Hi, I'm creating an OTBI report … -
Comparison between the content provided by latest Cloud HCM OTBI and Fusion HCM AnalyticsSummary: Is there any comparison available between the content provided by latest Cloud HCM OTBI and latest Fusion HCM Analytics. Content (required):If a customer has to…Mangesh Bhanage 51 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Schedule Event Trigger in Data Model Errors immediately when ScheduledSummary: I have created an event trigger in a data model, which I have done before without issue, but for this one as soon as I schedule the report that uses this data m… -
Reg OTBI CountHi we are have OTBI report which gives the count of enrollment for each plan , for some of the plan no emp is enrolled ,in the report we are not getting this plan detail…User_7836 31 views 10 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…Jaeyshree Kumaran 31 views 1 comment 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM
-
workforce structure change reporttrying to build a report that captures changes on the department table. We maintain history on our departments, but would like to be able to report on it. If we do the r…Mike Borghoff 81 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Subject Area - Department Hierarchy(Department Levels) coming up as blank columnsSummary: Subject Area - Department Hierarchy(Department Levels) coming up as blank columns Content (required): Hi! I'm trying to create a subject area analysis that disp…User_2025-02-11-21-40-21-159 141 views 5 comments 1 point Most recent by User_2025-02-11-21-40-21-159 Reporting and Analytics for HCM
-
How do we design action links to navigate to a web page related to that record in HCM?Summary: I would like to be be able to create Action Links in Oracle BI Analysis reports that allow the user to click and then be taken to the record that is being repor…Len M. 21 views 4 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
View Formatted CLOB Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …Tanu Shri Patel 254 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to use one or the other parameter in a SQL querySummary: I have a query that I built that is supposed to either pull in the list of terminated employees based on the date range entered OR a list of terminated employee…User_2025-02-04-08-51-08-912 51 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Can we Hide Exporting options from user while running BI Publisher Reports ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Kaustubh Deshmukh 31 views 7 comments 1 point Most recent by Kaustubh Deshmukh Reporting and Analytics for HCM
-
Combining two analysisHi Team, Can we combine two or more analysis (columns are same for all analysis) results in a single report? Thanks.
-
Report With the FileURL (Download Link) of an Employee DocumentSummary: We need a BIP report with a download link to an employee's document (DocumentRecords) Content (required): Hi, Is it possible to generate a BIP report with the d…Yaniv 21 views 5 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Position FTE Over Under - hr_all_positions_f_VL linked to position_fte_sum via position_idSummary: Content (required): We have a data model that was created by a third party and they are linking to HR_ALL_POSITIONS_F to get details on overunder FTE counts. It…Annette M 41 views 13 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Amalgamated Absence DaysSummary: My report is totalling the absence days for all absences of the same reason name and displaying that total on each line of absence in the report. I need it to d…Dawn Cawston - CPS 11 views 6 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Pictorial Representation of Organization TreeSummary: Pictorial Representation of Organization Hierarchy Content (required): HI Team, How we can create Pictorial Representation of Organization tree. Need to display…Reddykrishna 71 views 21 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM Extract schedule SQLSummary: Need SQL to get HCM Extract schedule end date Content (required): Need SQL to get HCM Extract schedule end date Version (include the version you are using, if a…
-
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to deeply understand your Oracle Cloud Applica…This discussion has been merged.Bethany Hubbell 1 view 0 comments 0 points Started by Bethany Hubbell Reporting and Analytics for HCM -
Unable to edit delivered RTF report templateSummary: Unable to edit delivered RTF report template Content (required): Hi, I'm attempting to edit the benefits summary delivered RTF template. The issue I'm running i…User_2025-02-11-21-40-21-159 52 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM