Reports
Discussion List
-
User Last Login Details Using OTBI ReportSummary: OTBI reports to pull out last login user Details Content (required): Hi, We have requirement to pull out last login user details using OTBI report. Is it possib…Vasanthakumar Ravi 12 views 5 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 17 views 5 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
OTBI Security by Line ManagerSummary OTBI Security by Line ManagerContent MY OTBI security by Manager doesn`t work. I have the Line manager person profile secured by Manager hierarchy, but the Line …User_HF4N3 178 views 17 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Leave Balance showing incorrect IN Custom BIP reportSummary: Hi Team, Some of emplyoees showing incorrect leave balance that zero and some of have showing corret value . Could you please assit on ? Thanks AJAY Content (re…AjayKumar Maddipati 11 views 6 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Headcount by week or date returning blanksSummary: Is there a way to report a headcount trend by week or by date using Workforce Trend subject area? Content: I'm trying to build a report that shows headcount by …Callum Jones 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to get a report on cascading GoalsSummary: Content (required): Can anyone Give me a better way to have list of Cascaded Goals Version (include the version you are using, if applicable): Code Snippet (add…Sowmiya 3 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
in my below only getting for india data and one processSummary: Hi sir, for above query with out put country parameter or process name parameter only geting india and regination process ? when i scedule the report but i seei…AjayKumar Maddipati 3 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Display OTBI Analysis to Employee Without Giving Access to Reports and AnalysisSummary: Content (required): We have a requirement where the logged in employee can view his/her development goals count viz., total goals completed, total goals in prog…Jaydeep More 26 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA…
-
Report integration on a pageDear all I integrated a dashboard on a custom page. There are two open points fr which I can't find an answer at the moment: 1. The report is not fully shown. There is a…Annelies Van Erom 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can we report on how many Share Colleague Data Access are active?Summary: We are currently trying to establish how many colleague's have an active Share Colleague Data Access of 1 or more and we want to be able to identify how many co…Natalie L Woodland 12 views 3 comments 0 points Most recent by Natalie L Woodland Reporting and Analytics for HCM -
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 44 views 4 comments 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Development Goals Count Scoreboard Employee WiseSummary: Need to display the count of the development goals in various status to the logged in employee in form of a dashboard Content (required): We have a requirement …Ronit Swain 21 views 3 comments 0 points Most recent by Jaydeep More Reporting and Analytics for HCM
-
Sample OTBI Dashboards/Reports - RecruitingSummary: Content (required): Are there any recent shared sample packs of dashboards or reports related to ORC Recruiting? Version (include the version you are using, if …Toni Olivier 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hi there, I am unable to run a single report for a complete details of an employeeSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):_Sanjay_ 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T…
-
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T…Celo Z 1 view 1 comment 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
when we using full name column, we are missing the middle name of employee any another column ?Summary: Hi Team, when we using full name column, we are missing the middle name of employee but when we try to using first name , middle name, last name but it is takin…AjayKumar Maddipati 12 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Active Profile QuerySummary: Looking for help on how to build a query that checks for active profiles within different environments Content (required): Hi all, I'm looking to see if anyone …
-
RTF Template spilt the output in different documentSummary RTF Template spilt the output in different documentContent Hi, I am using RTF Formating using Word Add-on(BI Publisher) We created a custom RTF temple that have …Awadhendra Tripathi 20 views 8 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Where is the rate field for hours worked?Summary: Content (required): I have a report that uses the subject area Payroll - Payroll Balances Real Time, but it does not have a pay rate field. Below is an example …
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 116 views 1 comment 6 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
BI Dashboard filter causing score tiles to not showSummary: We have a dashboard built to summarize the scores of a questionnaire. When we filter, even though there is data, some of the tiles will randomly not show up. If…
-
Hiding Output TAB in Schedule Page of ReportSummary: Hiding Output TAB in Schedule Page of Report Content (required): Can we hide via Personalization or Role Duties and Privileges restriction hide the Output TAB i…C.R.Balaji 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to schedule a BI Publisher report to run on interval of 15 daysSummary: Need to schedule a BI Publisher report to run on interval of 15 days. Content (required): Version (include the version you are using, if applicable): Code Snipp…Abhimanyu Kumar27 13 views 2 comments 0 points Most recent by Abhimanyu Kumar27 Reporting and Analytics for HCM
-
Include/Exclude column based on the ParameterSummary: We have requirement to Include/Exclude the column based on the parameter Content (required): We have a requirement to hide a column in the report output based o…Vasanthakumar Ravi 12 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Only issue with one person number of the querySummary: HI Team, for below working fine but coming to one person number not getting the data. below error coming error:Data_das Could u please assist on [email protected] G…AjayKumar Maddipati 12 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How to change date format in 30-06-2022 to 30-June-2022Summary: Hi Team, we have developed date as of now 30-06-2022 but business wants this format 30-June-2022. to_char(CURRENT_DATE,'DD-MM-YYYY'), -- 30-06-2022 May I know t…AjayKumar Maddipati 11 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Scheduling Dashboard with BIP ReportSummary: Content (required): I am trying to schedule a dashboard which contains a tab with a BIP Report. When I schedule or export the dashboard, all other tabs (that co…Riti Malhotra 2 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Filter to pull employees with anniversaries in the following monthSummary We need to build a report that is emailed monthly and pulls any employees that have service anniversaries in the following monthContent We need to create a repor…