Reports
Discussion List
-
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l… -
Report to pull goals not createdSummary: Can any one please send me the query or analysis to pull the employees who not created goals. Content (required): Version (include the version you are using, if…Reddykrishna Chidella-Oracle 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hourly Rate FormulaSummary: I have a report using the subject area Compensation – Salary Details Real Time and need to add a formula that calculates a base hourly rate. Here is what I'm lo…JHaden3 121 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Date Match Formula ErrorSummary: Date match formula errors when I run the report. CASE WHEN "Work Relationship Details"."PER_PPS_LEG_DDF_ST_BS_SR_STRT_T_" = "Workforce Management - Worker Assig…
-
EPM performance score cardSummary: As part if enterprise edition, do we have performance scorecard as out of box feature? Content (required): As part if enterprise edition, do we have performance… -
Provide Participant Feedback" link text needs to be changed in BI notification templateSummary Provide Participant Feedback" link text needs to be changed in BI notification templateContent We need to change link text in notification however unable to find…
-
Will migration of new Reports in EPM Cloud pods to MR be possible?Summary Looking for a way to migrate the new Reports in EPM Cloud pods to the Management Reporting tool within Narrative Reporting. Is this possible now, and if not, wil… -
Urgent Help Needed: Migrate the Reports (MR) from Planning to Narrative ReportingContent We have a need to migrate a set of reports (MR) from Planning to narrative reporting. Please let us know if there is a way to do that. Regards, Sandeep -
Suggestion for an easy method : Financial reporting studioSummary: Suggestion for an easy method : Financial reporting studio Content (required): Hi We are using a PBCS Application, and is in the process of creating an income s…
-
OTBI Report Performance IssueSummary: OTBI Report Performance Issue Content (required): Hi Team, We have developed the turnover dashboard using "Workforce Management - Workforce Trend Real Time" sub…Vasanthakumar Ravi 81 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Dynamic time series feature in Financial reporting studioSummary: Dynamic time series feature in Financial reporting studio Content (required): Hi This is a PBCS Application and We are in the process of creating a FRS report. …
-
Need to configure HCM infolets in Newsfeed SpringboardSummary Need to configure HCM infolets in Newsfeed SpringboardContent Hi All, I want to know the priviledges for showing only HCM infolets. By default, it is showing CRM…Ravi Singh 68 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP table for pending approval assignees?Summary: We want to be able to get the list of assignees from an approval process/transaction, before it is completed. Content (required): If an approval process is stil…User_2025-02-12-18-16-11-815 51 views 2 comments 0 points Most recent by User_2025-02-12-18-16-11-815 Reporting and Analytics for HCM -
Turnover -Month on MonthSummary: I am looking for calculating turnover 12 months from a certain date month by month. But I want the period start date to remain the same as the start month of th…
-
Most recent salary record (Active and Termed)Summary: I have a report using the subject area Compensation – Salary History Details Real Time. I need the report to display only the most recent salary record for both…
-
Need inputs to display Dependent and other information side by side in OTBISummary: Need inputs to display Dependent and other information side by side in OTBI Content (required): We developed Benefit OTBI report. Currently if an employee is ha…
-
Image stored on Web content Server not getting displayed in the Email Output after scheduling ReportSummary: Hi, We have created a check-in on content server to store an image and we are using that link in a report. The link is working fine when tested directly. We als…Abhishek Bhawalkar 141 views 5 comments 0 points Most recent by Abhishek Bhawalkar Reporting and Analytics for HCM
-
OTBI Reports of ORC - Job Requisitions not open yet - Field Status come filtered and only show opeSummary I´m trying to create a report to list all job requisition that are in a phase before been publish or open to publish. But whe I add Phase field from phase histor…Christian_Kaladjian-Oracle 39 views 6 comments 0 points Most recent by Bounmy Reporting and Analytics for HCM -
BI Report on Notification Approvals StatusSummary Trying to create a BI Report on the status of Notification ApprovalsContent I've tried looking at a number of tables, firstly in OTBI, but the subject area "Huma…User_2025-02-06-00-01-08-606 98 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need to report on how long is it taking for managers to approve their tasks in a particular workflowSummary: We need a report from the workflow side of things to give us insight into how much is each manager taking to approve their tasks. Content (required): This is a …
-
cmp_transactions doesn't track Override when Worksheet Overridden by Another Manager is disabledSummary: Content (required): Hello, we are configuring a custom Worksheet Overridden by Another Manager notification. When we extract user transactions on compensation p… -
Pick Slips Not printing to printerSummary: Pick Slips Not printing to printer Content (required): We have scheduled Pick waves. Document set attached to the rule. Pick slip is submitted but failed to pri…Chandrajit 63 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
What table is absence Plan Period Start Date stored?Please see sample screenshot:notautomni9 201 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Tools > Audit Reports - What table can I look at to see this data?Summary: Tools >Audit Reports > run the report to view changes to supplier banks. There is a field Description. Need the table where this data is populated Content (requ…Jacque Reeves 11 views 2 comments 0 points Most recent by Jacque Reeves Reporting and Analytics for ERP
-
how to create extract such that it should only give the record for which department has changed.Summary: how to create extract such that it should only give the record for which department has changed. Content (required): This is change only extract. I have created…
-
Is it possible to pick multiple selections (that add up) in the POV of reports?Summary: Is it possible to pick multiple selections (that add up) in the POV of reports? This would be similar to how it behaves in Pivotables in Excel as per the screen…
-
Formula rows/columns from reports in ad hoc gridsSummary: Hi all, As I was opening reports in Smartview, I noticed that my formula rows / columns from the reports are not imported (everything is there accept for the fo…
-
Aggregation function like stringagg() is supported in oracle BI queriesselect string_agg(goal_name,',') from (select distinct goal_name from HRG_GOALS) t Received ORA-00904: "STRING_AGG". invalid identifierChandra Thangavelu 121 views 1 comment 0 points Most recent by MandeepGupta BI Publisher Learning Center