Category 81
Discussion List
-
Table Names which stores the Journey InformationSummary: Hi Experts, Need one help, we have created one Journey which has 2 Questions. This journey will be assigned to each employee and each employee need to answer th…Gaurav Bhardwaj 439 views 2 comments 0 points Most recent by Gaurav Bhardwaj Reporting and Analytics for HCM -
i'm not able to read finance data related to over time and training expence in custom HR dashboardSummary: Hi i used finance subject area (General ledger-Transactional balance real time) in HR dashboard but system is not allow to me to select subject area , i think t…Mahgoub S.Mohamed 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP report includes a parameter as the first column in the CSV formatSummary: BIP report includes a parameter as the first column in the CSV format Content (required): Hi experts, BIP report includes a parameter as the first column in the…Volodymyr Faranosov 182 views 7 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
What table to get Goals / Behavior Names?Summary: To find what table Behavior names are in Content (required): I know that Goal names can be extracted from HRG_GOALS, but is there a different table for Behavior… -
How to link locations with geographySummary: Content (required): Hello Guys, We would load the city present in the locations inside the Geography of the recruiting. How could we perform it? Where could we …Giuseppe Iacono 32 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Duplicate a page in Dashboard - OTBISummary: Content (required): Hi there How can I duplicate a page in an OTBI Dashboard? Thanks Bobby Version (include the version you are using, if applicable): 21C Code …Bobby Jourdan 1 view 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Query for extract Hierarchy ManagerHi there , we need to reconstruct the hierarchy of a user's managers via a query in BI. The real problem we encounter when a manager then has several active assignments …User_2025-02-07-06-30-13-200 2K views 6 comments 0 points Most recent by User_2025-02-07-06-30-13-200 Reporting and Analytics for HCM -
Payroll Costing and BalancesSummary: Has anyone ever used these two subject areas in an OTBI analysis correctly? : Payroll - Payroll Costing Setup Details Real Time & Payroll - Payroll Balances Rea…Andrew_Schmitz 43 views 7 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
how to sum two condition in e-text template on oracle fusion hcmSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
how to sum two condition in e-text template on oracle fusion hcmSummary: When we add all 4 fields the output of the report comes blank. I am able to add Shift Pay+Incentive+Current Salary the output appears but when i add Lead Pay (w…
-
Display Extended Absences by day from Absence ModuleSummary: We have a requirement to show absences by day if they are booked over a period of time. Content (required): The example we have is if someone books a week long …User_2025-01-31-00-25-12-234 21 views 2 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
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 44 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 22 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 32 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 32 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 82 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 146 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 53 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM