Category 81
Discussion List
-
Error When open Dashboard by a certain user!Summary: Content (required): I received this error when opening a custom dashboard, noting that the user has access to the report and its Subject Areas The report can be…Walid Hamdy 28 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Locate Job Requisition Submissions Questionnaire ResponsesSummary: Hi all, I am attempting to write a BI report that will show an applicants response to a specific question asked during the job application submission. Can you p… -
Analysis Female Successors for Critical RolesSummary: I am trying to work out #critical roles: used distinct (Plan Business Unit)- Correctly getting the count #atleast 1 female successor on these critical roles # c… -
Identifying/Removing Duplicate rowsSummary: I am creating a report that is trying to highlight any blanks or erroneous data in our active workforce. It requires combining the following subject areas: Work… -
How can I query uploaded learning content?Summary: Is there an easy way in BIP to query learning content title and file name? In my particular case they have been batch uploaded via REST API, but I don't think t… -
Ask for table name - who answered the questionnaire, the questions and answersSummary: Ask for table name - who answered the questionnaire, the questions and answers Content (required): Table name for Questionnaire related have found the following… -
ORA-01841: (full) year must be between -4713 and +9999, and not be 0Summary: Encountering an error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 when trying to pull a value from the element's input value. Data type…RenzelkeithCoquia 372 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Number of Candidate Pool Members metric doesn't match with the value showed in UISummary: Content (required): Hello, We would create a simple analysis that extract the Number of Candidate Pool Members inside the different pools. We create the analysi…Giuseppe Iacono 48 views 8 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
How to report on initial absence start date while maintaining current absence start/end date columnsSummary: Hi All, I have a requirement to report on the initial start date of consecutive absences, while also showing the start date and end date of the current absence.…User_2025-02-11-06-38-03-841 26 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Table name for retrieving representative information assigned to an employee based on AORSummary: I need to write a BI publisher report where I need to fetch the representatives assigned to an employee based on AOR as shown in the screenshot below .Here we c…Nirmal 42 views 2 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM -
BI Publisher Desktop for BIP 11.1.1.9.0 not working with MS Office-365 & WIN-10Summary: Hello Experts, Can you please guide me if you have faced the similar issue while installing BI Publisher Desktop for BIP 11.1.1.9.0 which not working with MS Of… -
Total on the Top of Stacked Vertical BarSummary: Total on the Top of Stacked Vertical Bar Content (required): How to add Totals on top of Stacked Vertical Bar in OTBI, Please see below image, If its possile pl…
-
Can't view own record in OTBISummary: I have a custom role where I would like to see my own data, only in OTBI but not to be able to correct it in HCM. Like add absence to my own person. I don't wan…Nicolas Vahman 580 views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Grouping and sum the RUN values of balances using XSLTSummary: Grouping and sum the RUN values of balances using XSLT Content (required): I have a below requirement to group by and sum the RUN values for each balance under …Deekshith Kalluri 35 views 0 comments 0 points Started by Deekshith Kalluri Reporting and Analytics for HCM -
ORC: Tracking all the End Dates for a RequisitionSummary: Hi, Can we track & report all the end dates for a requisition if Hiring Manger changes the End Date of the Requisition? Any help with details like Tables, Repor…Bhaskar Konar 45 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Requisitions per Department ReportSummary: Content (required): Hello Guys, We would create a report that show the number of requisitions for Departments and that it also have the functionality to explain…Giuseppe Iacono 34 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
BIP Report - Department HierarchySummary: Hello, can I create a SQL for department hierarchy out of this sample pattern? Does it work in Oracle BI Publisher? with Org ( id,idparent, name, level , Path) …Hazel De Castro 40 views 2 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
Please, which subject areas can i use to build a report on personal information data.Summary: We want to build a report on personal information data. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any co…David Sakeye 26 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …Chelsea Holden 530 views 5 comments 0 points Most recent by Evan Rathod Reporting and Analytics for HCM
-
How to create Pivot table in RTF with Text values?Summary: Hello Experts, Is it possible to create a Pivot table in RTF with Text values? If yes, kindly share the details. Regards, Abhishek Premchandra Content (required…Abhishek Premchandra-Oracle 40 views 4 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM -
Waived Benefits fields in OTBISummary: I have a report that HR has requested to add if the have waived their benefits elections. Is their a field/ subject area that will store this information? I'm c…RJ Blankenship 26 views 3 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
OTBI-Report-Workforce Management - Person Real Time-Roles RequieredSummary: OTBI-Report-Workforce Management - Person Real Time-Roles Requiered to get employee information Content (required): Hello I need to get some employee and manage…Cesar Saveedra 5 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to habilitate 'My Reporting' tab in HCM Cloud?Summary: Greetings, I have the Hr Specialist role in HCM Cloud but it seems I lack some configuration to use 'My Reporting' tab, when I search in the simulator Navigator…Saily De Jesus 35 views 4 comments 0 points Most recent by Saily De Jesus Reporting and Analytics for HCM -
Blank line at the end of etext template output fileSummary: I'm trying to fetch the data from cloud in .txt file format by using ETEXT template. A blank line is noticed towards the end of the file always which is not exp…Meenakshi K 208 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Subject Area for Payslip Summary,HoursSummary: Can you please suggest if we have any subject area to get the below info Content (required): Version (include the version you are using, if applicable): Code Sn…pratyushak 12 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Submit a flow - When there is no privilege added to the custom roleSummary: Hi Team, We are facing an issue related to our custom payroll role. We have built a custom payroll role to perform a few payroll administrative works. This cust…Silpi 93 views 1 comment 0 points Most recent by Kathan Bhatt-Oracle Payroll and Global Payroll Interface (GPI) -
Unarchive ErrorSummary: I am unable to unarchive the BIP report to BIP and getting the below error. Tried in different browsers by clearing the cache, but still the same issue. Content…Satyanarayana M-Oracle 39 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Individual Compensation ReportSummary: We are using individual compensation plans to process additional overtime for the employee with defined approvals but approvers wanted to see analytics before t…Santhosh Kumar 60 views 7 comments 0 points Most recent by Santhosh Kumar Reporting and Analytics for HCM -
Talent Review Prior and Latest N-Box AnalysisSummary: I am trying to capture the 2021 n-box and 2022 n-box of employees on Talent Review to find out if anyone has a change in the n-box. I created analysis but when … -
Two Employee Rows Created only one shows Gender but not dual AssignmentSummary: Content (required): We are running an "All Employees" report and there appeared to be an anomaly on a single employee where it returned two rows of identical da…CB Trett 26 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM