Reports
Discussion List
-
Is there a provision to hide the formatted or Data option in OTBI?Summary: Feature to hide or unhide the formatted or Data option in OTBI Content (required):We have developed a report with the Pivot option. While exporting the data if …Venkateswaran Murali-Oracle 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
Candidate Success of Hire ReportThis analysis displays candidate information such as past employers, education, certifications, and termination data like last position held and length of service. To ad…Dishti Malhotra-Oracle 51 views 3 comments 1 point Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
How to get Department of Level1 , level2 and level 3 position in position HierarchySummary: We have a requirement to fetch following fields in OTBI, Person Number Assignment Number Position Name Level1 Org: Populate department of the position One level…Raghavendra M 621 views 10 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
State: HY000. Code: 27047. [nQSError: 27047] Nonexistent table: "SET". (HY000)Summary: I am trying to create 2 reports: 1) Workforce Management - Worker Assignment Event Real Time:- Picking all person numbers with action names and effective date b…
-
BI Publisher Solution ? - Start Excel Preview only open: falseSummary: Hello R&A forum: Start Excel Preview only open: false mTemplate: C:\Users\john.white\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\tmp\tmp.xls mT…User_2025-02-12-15-41-59-245 1.7K views 0 comments 0 points Started by User_2025-02-12-15-41-59-245 Reporting and Analytics for HCM -
BI Publisher Excel Template preview failsSummary BI Publisher Excel Template preview failsContent I am new to the use of BI Publisher Desktop in Word and Excel to create templates for BI reporting. I have a rep…Dena Swanson 204 views 7 comments 0 points Most recent by User_2025-02-12-15-41-59-245 Reporting and Analytics for HCM -
Defined Flex Field (DFF) & Person Count and Head CountContent We have created a defined flex field (DFF) for gender as we use different values from the default HCM gender field. The DFF has been placed into Workforce Manage…User_2025-02-04-10-47-55-876 64 views 3 comments 1 point Most recent by Harry Oracle Reporting and Analytics for HCM
-
Query to fetch existing and proposed information of pending transaction in oracle hcmSummary: We have a requirement to develop a BIP report to display the existing and proposed information of pending transaction like Promotion. Content (required): Need t…Meenakshi K 601 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Agents sending out from test instanceSummary: We just received our 22A and received our first refreshes since. We applied the administrative settings to override the email and set notifications to none but …Shanna Oppenheim 21 views 6 comments 0 points Most recent by Gaurav F Reporting and Analytics for HCM -
OTBI Analysis > Time Displayed IncorrectlySummary: Hello All, I will appreciate your support on the following issue: The Start Time and Stop Time reported from the Time Device Machine are displayed correctly on …Bernard T 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Termination Headcount causing errorSummary: Reporting Experts - We are trying to build a simple OTBI that should list the managers (Any level: Level 1 or level 2) with the direct and indirect reports. Whe…Vijay Rajendran 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to map multiple columns from 2 different subject areas to one dashboard promptSummary: Hello everyone, I have 2 different OTBI analyses - 1 that refers to the Workforce Management - Worker Assignment Event real time and the other one refers to Wor…Vijay Rajendran 21 views 1 comment 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Dashboard Embedded into HCM Not ResponsiveSummary: Issue with dashboard running/completing that are embedded in HCM. The dashboards were working until a recent patch after 22A. Content (required): Hi there, We h…
-
Matrix ReportSummary: We have a created a matrix report using BI Publisher report.The requirement is to have the drill down also to view the deatils. Can someone please suggest how c…minati_behera-Oracle 11 views 0 comments 0 points Started by minati_behera-Oracle Reporting and Analytics for HCM
-
Please help on Oracle Learning activity report not pulling activity completion date.Summary: Trying to create a OTBI report for Oracle Learning activity report using Workforce Learning - Learning Management Real Time subject area . But I am not able to …Srinivas Sakinala 51 views 7 comments 0 points Most recent by Jane Warwick Reporting and Analytics for HCM
-
Organization Hierarchy fields causing missing employeesSummary: We have a report that keeps dropping employees whenever we add the Organization Hierarchy fields level 2 and level 3. We have made sure the values are populated…Shanna Oppenheim 21 views 9 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Turnover report with custom column filterSummary: Hi Experts, our requirement is to create a turnover report with Active employees on the 1st of every month and the last date of every month, no of hires and Ter…Naveen setti 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I add a column for % Holiday Balance remainingSummary: Hello, I'm looking to see if anyone has the correct formula for me to use, or has already added in the column for '% Balance Remaining' for the annual holiday a…Karen Doig 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report for all the users along with all the rolesSummary: I am wondering if we have any report available that shows all active users with the roles assigned to them ? I am able to build OTBI report that shows Employees… -
URL inserted into browser window allows access to report without securitySummary: Users able to run reports using direct URL access Content (required): We have identified an issue where our users can enter a report specific URL into a browser…Ruthie 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Succession Plan Candidate Readiness Timeframe not showing in ReportSummary When reporting on our current succession plans, the Readiness Timeframe field is not showing any data.Content Is anyone experience issues when reporting on succe…Jaclyn S. 26 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Issue in weekly schedule Bi report with effective date parameterSummary: Issue in weekly schedule Bi report with effective date parameter Content (required): Hi Team, Recently I was schedule a report which is weakly basis and it cont…
-
How to fetch the translated value from an Independent Value set in Oracle Fast FormulaSummary: How to fetch the translated value from an Independent Value set in Oracle Fast Formula Content (required): How to fetch the translated value from an Independent…Meenakshi K 62 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Running OTBI based upon the Results of another OTBI getting Error getting Drill InformationSummary: We are trying to base the results of one OTBI analysis off the results of a second OTBI analysis. Both analysis run successfully on their own. However, once con…Denise Izzi 51 views 19 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …
-
Succession Plan BIP Report based on Job RoleSummary: Hello Experts, I have to create a Succession Plan BIP Report based on Job Role. Please help with a sample SQL/Report if you have worked on a similar requirement…Abhishek Premchandra-Oracle 81 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to use Hyperlink in RTF templates?Summary: Hello Experts, Is it possible to use Hyperlink in RTF templates? Like, in the report output, the Person Number attribute will have a hyperlink, once the user cl…Abhishek Premchandra-Oracle 921 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
HCM > Others tab > My Dashboard > End User Dashboard Does Not OpenSummary: HCM > Others tab > My Dashboard > End User Dashboard Does Not Open Content (required): Hello All, I will appreciate your support on the issue below: When the HR…
-
Application channelSummary: Mobile vs Desktop - Is there a way to report on how candidates are applying, whether it be on a mobile device or from a desktop/laptop? Content (required): We a…Mitch_123456 21 views 1 comment 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM