Category 81
Discussion List
-
Understanding Actual Termination Date and Per_Periods_Of_ServiceSummary: Looking for SQL to pull in an accurate termination date given a point in time. And if that point in time is BEFORE the termination, then the business is wanting…SeanWesche 12 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Table and field references for compensation manager hierarchySummary: Content (required): Hello experts, for this compensation campaign we should change the manager hierarchy workflow and we set the primary hierarchy as in the att… -
Is it Possible to remove Dashboard creation option from the RoleSummary: Is it Possible to remove Dashboard creation option from the Role Version (include the version you are using, if applicable): 22DHarishVummidi 7 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Sharing Recruit to Hire Dashboard -- download catalog fileSummary: I know I have seen a posting that shared the delivered Recruit to Hire Dashboard in a customizable download file. Can someone share the link to that posting? I …Ellen Manthei 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to report on Date Paid in last 12 monthsSummary: I have a report using the Payroll Balances Real Time subject area. The requirement is that when the report runs on the first day of every month, the output is f…JHaden3 8 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 18 views 4 comments 0 points Most recent by Rambabu L-Oracle Reporting and Analytics for HCM
-
Job Incumbents 10th 25th 50th 75th 90th incumbent baseSummary: We are building an otbi dashboard that can be leveraged to report on incumbents jobcodes and paygrade ranges. We have the base report with jobcodes and number o…Akshay.Agarwal 7 views 1 comment 0 points Most recent by Akshay.Agarwal Reporting and Analytics for HCM
-
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u…
-
Pivot table help - Measures dont sumSummary: Measures in a pivot table do not sum, instead appear as a 1 regardless of total. Content (required): Im new to OTBI and dislike pivot table (OTBI, excel, anywhe… -
how to remove these BI reports shared over app within SaaSSummary: We currently have our talent reports exposed within SaaS as an app per the below screenshot. We would like them to be disabled/hidden/delete from the UI. Can so… -
Unable to see xls export option for BIP report after 22DSummary: Unable to see xls export option for BIP report after 22D Content (required): Hi , we are unable to see xls export option for BIP report after 22D and xlsx gives…PriyankaM 23 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Specialization Title and Number in OTBI Learning ModuleHi Can you please tell me where can i can able to get the Specialization Title and Specialization Number in the Learning Module of OTBI (Workforce Learning - Learning Re…
-
Tile visual errors when The Table Visual is not added to ViewSummary: Hi, can anyone please help with the error message that appears when Table visual is removed from the view leaving the Tile visual in view. Content (required): T…
-
Need A Dynamic way of setting Date Parameters to begin with the 01st AprilSummary: Hi, I need to schedule an OTBI report that looks at changes made to a salary from the 01st April to the last day of the previous month. For example the report s…
-
Organization logo not showing up when exported (MHTML format)Summary: Organization logo not showing up when exported (MHTML format) Content (required): Hi , We have added organization logo in RTF header, and it shows up correctly …
-
An OTBI report in Workforce Management-Work Relationship subject area doesn't work for some rolesSummary: We have an OTBI Report with 4 columns, all under Workforce Management - Work Relationship Real Time category (Display Name, Person Number, Worker Payroll Name, …Justin Hurley 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to extract Goal Measurement IDSummary: Content (required): Hello experts, as MeasurementId is not available in OTBI analysis, please could you share the query to extract this information? Thanks a lo…Valerio Curzi 15 views 4 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …Swati U 21 views 2 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for HCM
-
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, …Cansel Karasoy 34 views 6 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Using 2 different subject areas (Salary and Performance Rating) - Getting split/merged cellsSummary: Hi Experts, I'm pretty much a beginner with reporting. My client wants an OTBI report that can pull salary details as well as latest performance ratings (overal…Shubham Shree 25 views 3 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Is there a way to encrypt the scheduled reports?Summary: Is there a way to encrypt the scheduled reports Content (required): We are looking into scheduling reports but we need to make sure there is an encryption in pl…Balazs Grajczar 21 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Supervisor Hierarchy (Top/Down) Managed departmentsSummary: Supervisor Hierarchy (Top/Down) spanning multiple departments Content (required): We are trying to develop an OTBI report displaying reportees spanning multiple… -
How can I add the manager information of the employees to the Analysis report?I want to add the managers of the employees such as 'head,c-suite,sr.head' to the report I prepared from the analysis report. When I get this information from the "Matri…Cansel Karasoy 32 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
HCM OTBI subject areas to database lineage mapping spreadsheetSummary This spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content Important Note: The subject area to database…Raghavendra Raghunath-Oracle 15.1K views 142 comments 104 points Most recent by Kamalakannan Natarajan Reporting and Analytics for HCM -
Table which stores User password expiration dateSummary: Table which stores User password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a re…
-
Is it possible to build workforce compensation approval workflow by OTBI or BI?Summary: Hello experts, our customer would like to represent the workforce compensation approval workflow by report. Do you know if it is possible to do it by OTBI or BI…Valerio Curzi 19 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Level 02 Organization Name (Business Area) Not Showing UpSummary: We are currently in the process of implementing ORC and we are trying to create some dashboards that we can use for requisition/candidate data. When we run the …Kyle Norris 56 views 15 comments 1 point Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
SQL Query to retrieve User Status both Active and InactiveSummary: Query to retrieve User Status both Active and Inactive Content (required): Trying to put together a query that will tell which users and how many of those are e…Edwin Martinez 47 views 2 comments 0 points Most recent by Edwin Martinez Reporting and Analytics for HCM
-
Any BIP reports to pull Tax withholding details. Federal, State, Local tax dataSummary: Any BIP reports to pull Tax withholding details. Federal, State, Local tax data Content (required): Version (include the version you are using, if applicable): …Prabhu Krishnamoorthy 30 views 6 comments 0 points Most recent by Chelsea Holden Reporting and Analytics for HCM