Reports
Discussion List
-
OTBI Analysis to identify employees with missing payment method - any help appreciatedSummary: We are looking to create an OTBI (not BIP) analysis which returns employees who don't have a payment method Content (required): Our current queries are bringing…Kevin M Storrie 81 views 5 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
Formula for most recent grade name on current assignment?Summary: Subject Area: Workforce Management - Person Profiles Real Time Column: "Grade"."Grade Name" Content (required): Does anyone have a formula to pull in an employe…William_Johnson 41 views 6 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 305 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Folder Permissions Error in 22BSummary: Since 22B we receive error when adding or removing users to folder permissions under Custom Content (required): The following error is thrown: "Exceeded number …Janine Brown 31 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Compensation Details (Top of Stack) when End DatedSummary: Hi - We are looking to create a report where we are able to audit active employees where their salary was incorrectly end dated. The problem is that when the sa…Kyle Norris 71 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need help on arrears balance ReportSummary: Content (required): Hello, We are trying build a custom arrears balance for both active and terminated employees. We do not have anything available for terminat…Ganesh G 203 views 3 comments 0 points Most recent by Catherine Chan Reporting and Analytics for HCM -
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …vamshi krishna-283622 415 views 8 comments 0 points Most recent by Arun Menon Reporting and Analytics for HCM
-
How can I get an interaction to filter on 2 columns at once?Summary: I have created a graph to show male/female by Grade level. I created an interaction to drill down to a report, however the interaction is only filtering on eith…Dannielle Dellucci 42 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ…Parag Hiremath 309 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…Parag Hiremath 355 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Best practice for reporting on incomplete allocated checklists?Summary: Hi All, Does anyone have any "best practices" for reporting on incomplete allocated checklists? We have a business case to report on number of incomplete checkl…William_Johnson 62 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Extract information about the Job Board eQuest in ORCSummary: Content (required): Hello everyone, We are having problems extracting information regarding the publication of a job requisition. In particular, in addition to …Gerardo Peluso 12 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
Function to convert accented characters to their plain ascii equivalents in BI reportSummary: Function to convert accented characters to their plain ascii equivalents in BI report Content (required): Function to convert accented characters to their plain…
-
Can the parameter affect both the row and the column in the Matrix report prepared from the analysisI have a matrix report that I use on the Dashboard screen, and the column information consists of job name information. The row information is also from the locations. a…Cansel Karasoy 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Error Code U9KP7Q94Summary: Path not found - Check input path entered Error Codes: U9KP7Q94 Content (required): Hi All, Has anyone run into this problem before? We archived and unarchived …William_Johnson 240 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Best practices for Journeys reporting in Workforce Management - Checklist Real Time subject area?Summary: Subject Area: Workforce Management - Checklist Real Time Need: Leverage best reporting practices to drive adoption rates and system monitoring for allocated jou…William_Johnson 102 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
can we create report on the missing candidates (unconfirmed candidates).There are some candidates who were not able to submit there job applications because of issues with being able to access the assessment. I need to check if we can create…Chetana Pawar 63 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
Analysis error - Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Analysis of 3 Subject areas, if no prompts are selected, produce report, when selecting a prompt, analysis result in error Content (required): Analysis of 3 sub…
-
Reading SQL Error CodesSummary: Hi All, Does anyone have any documentation/point me in the direction of resources that would help us read standard SQL error codes when working in OTBI? Include…William_Johnson 33 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Does anyone know in which table 'Domicile state other than the District of Columbia' field is storedSummary: I am not able to find in which table the State card component 'Domicile state other than the District of Columbia' field from calculation card (Tax withholding …SowmyaSk 45 views 1 comment 0 points Most recent by Raju Sandepogu-Oracle Reporting and Analytics for HCM
-
How do I show all completions for same Course Title in OTBI report?Summary: OTBI report to show completions only shows first completion if title is the same. Need to get OTBI report to show the same data as the View Transcript (which ca…Aaron Reynolds 71 views 6 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
Reporting on count of incomplete/complete Journeys in OTBI?Summary: For OTBI analyses - our organization needs to be able to report on the following in the Workforce Management - Checklist Real Time subject area: 1) Total number…William_Johnson 475 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Impact Rating Model column filter breaks analysisSummary: Subject Area: Workforce Profiles - Person Profiles Real Time Column: Impact Rating Model Content (required): Hi All, We run into an error under the Workforce Pr…William_Johnson 22 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
What is the best way to implement ECC200 data matrix in oracle reports?Summary: Need to add a 2d data matrix to report letters that will store a string of numbers. The ECC200 data matrix does not seem to be currently supported by Oracle so …KevinCochran 42 views 1 comment 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
End Dated values no longer appear in OTBI reportsSummary: We have end dated a number of Sickness Reasons (sub reasons), which used to pull through on OTBI reporting, these no longer appear after being end dated Content…Luke Harrison-126889 41 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Subject Area for Workflows & Approvals?Summary: I need to do a review of all of the Workflows & Approvals, and would like to be able to export them all, as is to avoid going through each one, one-by-one. Is t…Jessica D 344 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is it possible to customize AbsenceApprovalEmailNotification report to get Absence Balance included?Summary: We need to somehow modify the data model so that the absence balance of the absence type from the absence request gets displayed on the report. Content (require…bervin13 51 views 2 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM -
Is there a query for fetching LinkedIn profile details in BIP report? Which is the table for that?Summary: To fetch linkedin profile details in BIP SQL report. Which table needs to used to achieve this requirement? Content (required): Version (include the version you…RithwikSivanand111111 31 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How would we restrict the access of Hiring Manager to the other reports in a Dashboard?We have Dashboard A where Hiring Managers has access to. Inside the Dashboard A, we have a couple of reports (eg. Requisitions, Candidates, Hiring Manager requisitions).…
-
How to make a drop down Prompt, in a Report based on an Analysis, work?Content (required): I've created the Analysis. Which is used as the Datasource for a Dataset in a Datamodell. The Datamodell is used in a Report. I want to create a Prom…