Reports
Discussion List
-
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat… -
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli…Brandon Roberts 11 views 4 comments 0 points Most recent by Brandon Roberts 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 41 views 3 comments 1 point Most recent by Rosetta Jasperson Reporting and Analytics for HCM
-
How to display indirect terminations for a specific manager?Summary: We have a requirement to build OTBI (Graphs) to display number of terminations under a specific manager. There are 2 OTBI analysis I use in the dashboard - 1 wh…VRaj1182 1 view 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle 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 21 views 10 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
Need to report on how long is it taking for managers to approve their tasks in a particular workflowSummary: We need a report from the workflow side of things to give us insight into how much is each manager taking to approve their tasks. Content (required): This is a …Adil_R 11 views 6 comments 0 points Most recent by Abhishek Premchandra-Oracle 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… -
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… -
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…
-
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 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
address purpose Filed and table locationSummary: Looking to add the address purpose field into a previous BI report Content (required): I have a previous supply report i had built in BI publisher, a recent req…RJ Blankenship 1 view 4 comments 0 points Most recent by Abhishek Premchandra-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 … -
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 1 view 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…VRaj1182 11 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…
-
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 1 view 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 21 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…
-
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 1 view 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 11 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 12 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 Stouffer 6 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 11 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 11 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 …Tammi Desens 1 view 0 comments 0 points Started by Tammi Desens Payroll and Global Payroll Interface (GPI)