Reports
Discussion List
-
ESS and MSS ReportSummary: How can I report the number of transactions that were done through ESS and MSS? We want to check which countries are using the self-service the most against the… -
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…Swati U 1.1K views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM -
Assignment Manager Prompt - Direct and Indirect ManagersHi all, Does anyone know if its possible to use Assignment Manager as a prompt for a dashboard and also include the full direct and indirect managers for the user? At th… -
Footer is not displaying when data of custom report is output in WordSummary: Footer is not displaying when custom report is exported to Word. What is causing the footer to disappear when report is exported to Word? I can see the footer w…Consultant Ian 11 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
ORA-20001:An internal assertion test couldnt be completed at location pay_balance_pkg.chk_rel_actionSummary: Custom BIP report is developed and It is not working from ESS job. Note: When it directly run from BI Publisher is working. Error: Waiting Time: 2 seconds Trigg…Bejoylin 409 views 1 comment 0 points Most recent by Simona Stoian-Support-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 111 views 6 comments 0 points Most recent by H.Chauhan Reporting and Analytics for HCM -
OTBI > Ability to AggregateSummary: OTBI > Ability to Aggregate Content (please ensure you mask any confidential information): Hello All, In order to prevent the repetition of the Time Card Commen… -
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…GJ79 51 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Write a BIP report query in which termination records should be picked only once in output fileSummary: My requirement is: I have to write a query in BIP report to fetch the current and future hire employees, and termination records should be picked only once. The…Anuroopa Sahoo 111 views 1 comment 0 points Most recent by Serban Nicolae-Oracle Reporting and Analytics for HCM -
Report footer not showing completely in report outputSummary: Report footer not showing completely in report output. My client wants to display this footer on all the reports. When I run the report then everything in the f…Consultant Ian 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. …Dara Nagasai 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Can we Use .XLS template with Excel Macro enabledHi Team, Is it possible to utilize a BIP .xls template that has a macro embedded into it? Our User requirement is to have a Macro in excel template a user can run on the… -
Use .XLS template with Excel MacroIs it possible to utilize a BIP .xls template that has a macro embedded into it? If so, are there any examples that can be shared with me? I am not sure how to apply for… -
I have made changes to emps to workers from our integration urls but unable to find AssignmentDffId"Summary: I have made changes to emps to workers from our integration urls for testing one url need this "AssignmentDffId" but i have checked frontend as well as backend … -
Learning Access Group Organization Chart Selection Method Details -BIP Table mappingSummary: We have a requirement to develop BIP report for all learning items where we need to fetch the name of selection method for Organization Chart Criteria. We have …Kamini Kaushik-Oracle 11 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
How to add Calendar chart in OTBI Analysis under Learning Module?Summary: Hi Everyone, I have a requirement to implement a Calendar Dashboard that has an identifier if an activity is scheduled for that date - e.g. turns green if class…Prashanth Sangram-Oracle 41 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and viewsSummary: Need to build Onboarding - Overdue Tasks Report Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Pradnya_Pampatwar 411 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM -
how to join pay_tasks_vl table with person number?i wanted to fetch task name from (pay_tasks_vl) for a particular person but not getting how to join this table with person detailsChetana Pawar 11 views 2 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM -
Option to download multiple file from content serverSummary: Using BI Publisher report, I have extracted multiple files to content server , Whats the way to download all files from content server Content (please ensure yo…ROOPESH MADAN-Oracle 21 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle BI Publisher Learning Center -
No results using subject area Help Desk - HR Service Request LifecycleSummary: I'm trying to create an analysis using Help Desk - HR Service Request Lifecycle. In particular I need to see the data such as "Previous assignee resource id" or… -
Can we automate the HDL loads for Business Objects like Talent Profile / DOR having CLOB Files ?Assume, client is giving the DOR files on a regular interval and placing them in some folder and we have to automate the DOR HDL load on a recurrence basis. Is there a m… -
Chnages only extract to pull chnages on same daySummary: I have requirement to pull Employment Assignment Action at changes only extract. It is working fine when there is single change in a day but user is expecting b… -
feasibility check of triggering Manager's direct and indirect reportees dataHi Team, Requirement: I have a requirement to trigger the report to managers as an attachment. The report should include data from both direct and indirect reporters. Co…Haritha 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to send a report to a network folderSummary: Is there a way to schedule a report or Agent to send directly to a network folder? Content (please ensure you mask any confidential information): Version (inclu…THawkins_LGI 151 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Planning and NEW Report formatting loss under new REPORTSummary: Content (please ensure you mask any confidential information): Hi all As we are preparing for the REPORT migration this year, we are seeing some important forma… -
Showing error in BIP report ScheduleSummary: Hi Experts, we are facing following error during report scheduling. Content (please ensure you mask any confidential information): Version (include the version … -
Reporting only role - OTBISummary: Content (please ensure you mask any confidential information): Are there any ootb reporting roles which just grant access to the OTBI layer and restrict all oth…Clare Murtagh 11 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Need to add column for consolidation status to Process Monitor ReportSummary: Need to add column for consolidation status to Process Monitor Report Content (please ensure you mask any confidential information): We noticed that our Process…Ryan DeFilippi 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close