Reports
Discussion List
-
Line Manager DashboardSummary Line Manager prompt - Connect by in Logical SQL?Content Hi Team, I've added a Line Manager prompt in our custom version of Line Manager Dashboard. Because some o…Alvaro Couto 68 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
"Insufficient Privileges" in Fusion CloudContent Hi All, We have a requirement to find the approver name of a particular transaction. I did some research and found that may be we can get relevant data in hcm_fu… -
FTE by Actual Hours WorkedContent Hi All, I need a report that shows FTE per cost center by actual hours worked (in time card) instead of FTE based on scheduled hours. Have any ideas on how to be…
-
migrate data model from test instance to productionContent Dear Members, I have accidentally deleted a data model of a report from production instance. Thankfully, our Test instance still has that data model as is and un…Megha Patel 34 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Agent Failure NotificationSummary Would like to have a notification sent to our HRIS group when Agents fail without sending the reportContent We are looking for a way to have agents send a notifi…Kyle Norris 57 views 4 comments 3 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
Transaction Administration through multiple languagesSummary Process Name and Process Category are challenging in multiple languagesContent Hello Everyone, I've been pushing to create useful reporting on the goal setting p…Rob F 19 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Role Change Reflect to AnalyticsSummary When you change roles in Fusion, does it also get changed at the same time in Analytics?Content We encounter scenarios where we cannot see a report and then we a…Pernel Dela Pena 29 views 6 comments 0 points Most recent by Matt Nease Reporting and Analytics for HCM
-
Missing Payroll Element within OTBISummary Missing Payroll Element within OTBIContent I cannot see an Element with Element Classification Name = Information and at the Payroll Relationship Level within El…Andrew_Schmitz 40 views 4 comments 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM -
How can we pass a table prompt selected in the main report to the table prompt in the drilldown repContent We have a dashboard with a drill down to a detailed report. The main dashboard has a report that shows the rollup counts of documents by task status. When you cl…Tom_Giarratano12 33 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Cannot Find Category Name in Service RequestsSummary Looking for Category Name in the CRM Service ModuleContent Hey everyone, We recently installed HCM and we use the service model to act as our HR Help desk. I hav…
-
Organization Chart Custom ReportContent Hi All, I customized the DirectoryPrintReport report in /xmlpserver. I have kept only Custom as Default and Active. But the system is still printing the delivere…Mohit-Sinha 41 views 2 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Custom report for goals displays HTML tags and splits the Success Criteria Text CLOB data into multiContent Sample text in Success Criteria Field. - -This is a sample for success criteria textoralife 49 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Hello All, Currently I am using SQL Results option to populate value of a dashboard prompt called "Module Name".I am using below SQL code for this : actual colum…Janardhana Kondaveeti 27 views 6 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Custom Labels of OTBI are getting changed automaticallyContent Hi I have customized labels names of the parameters used in OTBI reports But somehow those customized labels are changing to it's initial name automatically This…Dhajani Perera 39 views 2 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for HCM
-
deep link to reportSummary deep link to reportContent Hi, We are trying to deep link to report in OBI report. below is the link we copied from the browser address bar:…Nizar Kassam 202 views 5 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
How to navigate from OTBI report to Absence Record Entry page in Edit modeSummary There is no Deep Link available to navigate to Absence Record page in Edit Mode using Absence Entry ID. Want to know if there is any way to open the Absence Reco…User_UM4C6 52 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
how to extract sql query in data modelSummary how to extract sql query in data modelContent Hi, I wonder if there is any way to extract SQL Query in Data Model using table/web service/etc. Regards, Suyoung V…Suyoung 37 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting…Rahul Bedia 98 views 8 comments 1 point Most recent by Suma Raghavendra Reporting and Analytics for HCM
-
What roles needed to let custom HR Specialist Role able to open any report or analysis?Content What roles needed to let custom HR Specialist Role able to open any report or analysis? and what controls reports and analysis data security? BI consumer Role? B…Walid Hamdy 47 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
OTBI Report showing multiple Parent Position Codes for a recordSummary Display the current parent position code in the OTBI analysisContent I have an OTBI analysis that is using Workforce Management - Worker Assignment Real Time and…User_2025-02-04-08-51-08-912 36 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Number of days a requisition is suspendedSummary Asking if it is possible to calculate the number of days a requisition is suspended (regardless of the number of times it is suspended) in OTBIContent Hello ever…Tom John Bontoyan 59 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Personal Payment MethodSummary Is it possible to report on personal payment method when this is blankContent Hi, please can someone confirm if it is possible to identify in a OTBI report when …Helen Tilling 138 views 4 comments 0 points Most recent by User_2025-02-08-06-26-45-662 Reporting and Analytics for HCM
-
Conditional format image - The file type is invalid, only .png .jpeg .jpg .gif and .bmp files are suContent I am trying to add a image if a condition holds true but I am getting this error message trying to upload an image. I confirmed the image format I am trying to u…User_2025-02-10-08-27-16-805 10 views 6 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
HDL - Element Entry IDContent Hello, I'm trying to update recurring element entries but am not sure where to find the ElementEntryID so that we can refer the HDL to a specific element entry. …
-
In which table is the issued by field for license and certificate for talent profileSummary issued by field for license and certificateContent In which table I can see the full entry for issued by field for license and certificate ? I can only see the a…
-
How to Embed a BIP Report with Prompts on a DashboardSummary How to Embed a BIP Report with Prompts on a DashboardContent Hi All, I have an existing custom Missing Time Cards report which is built using a custom SQL refere…Vinay Soni 226 views 4 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
how to default the date parameter in BIP report with sysdate-1 hourSummary how to default the date parameter in BIP report with sysdate-1 hourContent Hi All, Could any one help me in defaulting the date parameter in BIP report with an h…User_2025-02-06-09-41-56-955 400 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Data Model for HR Service RequestsSummary looking to report on HR Service Request dataContent Hi, we've recently started using the 'HR Service Request' facility. Was wondering if anyone had built a data …David McLellan 42 views 4 comments 0 points Most recent by David McLellan Reporting and Analytics for HCM
-
SQL for w4 tax Calculation card -2020Summary SQL for w4 tax Calculation card -2020Content Hi Team, We need a SQL to fetch the all fields in w4 tax calculation card 2020 -Federal form. Can you please share i…User_4VVG2 424 views 3 comments 0 points Most recent by Parupally Srikanth Reporting and Analytics for HCM
-
Eligibility Profile Validation Report for BenefitsSummary A lot of time customer requests to validate Or have the Benefits Eligibility Matrix handy as to query for each plan and combinations using UI is a cumbersome pro…