Reports
Discussion List
-
Gross to Net YTD valuesSummary Require a report that shows the Gross to Net YTD valuesContent I found the base report in /Shared Folders/Human Capital Management/Payroll/Payroll Calculation Th… -
Employee number along with Candidate numberSummary: Hi, My requirement is to extract Employee details like employee number, name etc. from Core HCM along with Candidate Number, Requisition Number etc. from ORC in… -
Sudden Issue When Exporting Reports ... Spinning Spinning SpinningSummary: Hi everyone, We are experiencing issues running reports. We are not getting an error ... the page simply spins, like for hours. Any ideas on what I can do to tr…Erin Hamrick 23 views 4 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Is there a way to see where the OTBI Agent burst to?Summary: Wondering if there is a way to see where an OTBI agent sent reports to. Content (required): We have a report that bursts based on manager username. The details …
-
Creating analysis using user defined fields in Workforce CompWe are trying to create some reports using the Compensation-Workforce Compensation Real Time subject area and was under the impression this subject area would pull data …Jamie_B 1 view 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
ODBC Error - ADFService11g on OTBI AnalysisSummary: After 22B went into our Test environment, a report built on a few subject areas no longer works. It is giving us the following error: State: HY000. Code: 77031.…
-
Leave Balance Calculation date showing different than UI in BIP reportSummary: Hi Team, Leave Balance Caluclation date showing diffrent than UI in BIP report Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 12 views 16 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
List of Seeded Reports for Oracle HCM CloudSummary: Hello, Is there a place where Oracle list out all of the seeded reports they provide? Content (required): Version (include the version you are using, if applica…Emily Beattie 37 views 2 comments 0 points Most recent by Rosetta Jasperson Reporting and Analytics for HCM
-
Select Max (Last Update Date) from "FUSION"."IRC_JA_EXTRA_INFO"Summary: Calling all SQL Experts: Trying to select the most current record (based upon last_updated_date field) from table "FUSION"."IRC_JA_EXTRA_INFO" in a data model. … -
HC trend working hoursSummary: Content (required): I am using workforce trend real time to pull period start and end HC by calendar month (2019/2020); however, when I want to drill down to wo…Riti Malhotra 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
We need to give read only access to the User to view all the reports dataSummary: Hi All, We need to give read only access to the User to view all the reports data Navigation -> Tools -> Reports and Analytics -> Browse Catalog -> Shared Folde…Sakthi Priya S 21 views 4 comments 0 points Most recent by Raghu Seregar Reporting and Analytics for HCM
-
Learning Audit ReportSummary: Our client has a requirement to be able to audit on the following objects in Oracle Learning Cloud. currently oracle dont provide an out of the box solution to …Nirupa Gnanendran 13 views 2 comments 0 points Most recent by Nirupa Gnanendran Reporting and Analytics for HCM
-
NewHireReport not getting triggeredSummary: Content (required): We have set the value as "true" for all the below profile options: BIP_EMAIL_NOTIFICATION_HCM BIP_EMAIL_NOTIFICATION_HCM_IRC BIP_EMAIL_NOTIF…Vinay Gharge 11 views 1 comment 0 points Most recent by Vinay Gharge Reporting and Analytics for HCM
-
When we apply filter below for particular process not working on pending transactions reportSummary: Hi Team, we have developed pending transactions report in that all process are coming like change manger,'Resignation', location, and etc but we need only Resig…AjayKumar Maddipati 23 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How to fetch attachment report from document of recordsSummary: Hi Team, How to fetch report for attachments of each employee. Content (required): Documents of records - Documents type- COVID 19 Version (include the version …AjayKumar Maddipati 21 views 9 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
Since 22B, Some Agents using an Unknown User in "Run as: Specified User"Summary: We have had a few agents stop running since 22B, when researching we found that these agents were using a user not defined in our system (Maureen Armstrong). Co… -
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware …A.Ferraro 23 views 2 comments 1 point Most recent by Nitika Arora-Oracle Reporting and Analytics for HCM -
Absence Accrual BalancesContent Hi - I have a report that shows the absence accruals for each of our plans and it works great for those that are calendar year Plan Period Type. It shows me the …Prudence K 229 views 26 comments 4 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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 11 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 15 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 177 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 1 view 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 1 view 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 1 view 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 24 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 11 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 43 views 4 comments 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM