Reports
Discussion List
-
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 52 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 40 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 101 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 61 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 202 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 122 views 1 comment 0 points Most recent by MandeepGupta BI Publisher Learning Center
-
Need Employee wise data where Checklist Response Text and Response answer in same row using OTBITrying to create an OTBI report from a survey which consists of both Response answer type and Text answer type questions. The report should show employee details, checkl…
-
Is there any way to change the order of displaying prompts in Run Time Prompt Window - ReportsSummary Looking for option to change the order of displaying prompts in a Run Time Prompt Window (Financial Reports)Content Hi All I'm looking for option to change the o… -
Customize Receivables aging seeded ReportSummary Customize Receivables aging seeded Report - to include Project information and grouping totalsContent Hi, We want to customize Receivables aging by General Ledge…User_V0Y9V 656 views 7 comments 6 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Security Console Audit Report?Summary: I am looking to build a report to show when changes to team member's security profiles were changed in Security Console, and when they were changed. I can't see…
-
Need help with CAST formulaSummary: I have a report using Subject Area Recruiting - Recruiting Real Time. I need to calculate the number of remaining openings (Number of Openings - Hired Count) mu…
-
Facing Issue with Multiple Adjusted Service DatesSummary: Trying to run service anniversary reports using our adjusted service dates. However employees have multiple adjusted service dates and need the report to only p…Dannielle Dellucci 103 views 19 comments 0 points Most recent by Rahul.Yarlagadda-Oracle Reporting and Analytics for HCM
-
Create Individual Compensation History reportSummary: I need to create a report of historical individual comp data, to include only additional comp like bonuses and such - No regular salary needed. I’d prefer to do…