Reports
Discussion List
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks. -
Dashboards - Manage capability showed up in FCCS role assignment reportSummary: New entries showed up in the Role Assignment Report for FCCS users with the Power User application role assigned, "Documents - Manage" and "Dashboards - Manage"…Tony Downs DTV 71 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co… -
Table for BPM Worklist vacation periodNeed a query for BPM Worklist vacation period Rules. Which table stores the below information.Aishwarya Somvanshi 161 views 3 comments 0 points Most recent by Madhavi.Modala Reporting and Analytics for HCM
-
How to connect periods of service with schedule assignmentsSummary: Hello, I am currently trying to report on the work schedule assignments for employees with a past termination date. Would anybody know how to connect the two ta…Dan_Hinsley 31 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
User variables" not visible in the MR reportsSummary: As per the oracle document we can use the "User variables" in the MR reports and user variables should reflect along with substitution variables. We cannot see …
-
Infolet Section says Refresh to Load after LoginSummary Infolet Section does not load Infolets by DefaultContent We are on 19C and on news feed. I have enabled HCM infolets and infact made couple of infolets. But What…Prateek Parasar - GTUK, ACE Pro 117 views 15 comments 6 points Most recent by Radouane Allam Reporting and Analytics for HCM -
Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv…
-
Line Manager Email notification with their Employees Due and OverDue Trainings in LearningSummary: Line Manager Email notification with their Employees Due and OverDue Trainings in Learning Content (please ensure you mask any confidential information): We hav… -
Is there an option in NR to have the data in Staging table to store Source dataSummary: Every time when the NR report opens, it pulls the data from Source. The current reports when it opens during Qtr-ends with number of usage at the same time agai…Rajarajan Ellappan 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Can Employer Comment under Termination Details be on a report?Summary Is there a way to add the Employer Comment informaiton to a reportContent We list the company that an employee leaves us for in the Employer Comments box on the …Denise Jo Crangle 82 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Dimension Folder Not Visible in Subject Area But It Is SearchableGood Day Experts, There are times when I am creating an analysis report. Some folder-columns are not visible in the subject area but it is showing when searching in the …JMLMIII 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Fast Formula ReportSummary Fast Formula ReportContent Hi Experts, Is it possible to download a report of all fast formula details along with code? Regards, Nivya Version 18CNivya Mathire 136 views 4 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Data not appearing on all tabs of an Excel report when run as a payroll FlowSummary: We have an HDL Error report that is based on a Data Model and creates an Excel spreadsheet with 3 tabs of data. The first tab is the Summary, the second lists a…Al Darabaris 11 views 3 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 52 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
How can we get a list of all Scheduled BIP Reports in Oracle HCM CloudSummary: We are looking for a SQL using which we can get a list of all Scheduled BIP Reports and their recent status Content (please ensure you mask any confidential inf…Mridula Mitra Pal 62 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
LAG Function not able to pull previous job of an employee.Hello Experts, I am creating a report to pull the previous job of an employee, I am using LAG function to fetch the previous job, but i turns out to fetch the same data …Joliver Caangay 11 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Allow Expansion Functionality in Management ReportsHi, Do we have the similar functionality to "Allow Expansion" that we have in FRS in the Management reporting (Reports) platform as well? Regards, Ayeshan
-
Address change report to capture old and new valuesSummary: I have not been able to build or find a report that captures address change data. We have been looking for something and was wondering if the community would be…Tammy Hemmingson 313 views 5 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Row Count and Control Sum in EPM ReportsSummary: We have a request by our Accounting Team to add Row Count and Control Sum in the Financial Reports. We recently converted from FRS to Reports. The requirement c… -
Query to fetch manager hierarchy based on Functional Reports-toSummary: Need help in fetching manager hierarchy based on most recently assigned Functional Reports-to manager. Content (please ensure you mask any confidential informat…Dinky Dudeja 479 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
What values should be provided to lexical parameters for seeded BIP data model?I am working on the SQL query for Oracle Seeded Data Model - Transactions Print Data Model for Invoice Print Template report, where it shows some lexical parameters and …Kratika Sharma 357 views 4 comments 0 points Most recent by Dhinakaran G BI Publisher Learning Center
-
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 150 views 13 comments 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM
-
Getting different employee counts using the same filtersSummary: I was getting inconsistent employee counts on a dashboard I was working on so I created 2 different analyses from different subject areas and applied the same f…
-
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
In OTBI, how to set the filters to fetch data between the last 3 years to the current year?Hello, I'd like to create an analysis to fetch Performance Rating from the last 3 years up to this year based on "- Competencies"."Review End Date". How to set a dynamic…Lise_Rekik_Acc 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Timecard Time Attributes Not Appearing in OTBI Timecard Subject AreasWe have Time Attributes set up that can be viewed in the application by navigating to Setup & Maintenance -> Workforce Deployment -> Time and Labor -> Time Entry Layout …