Reports
Discussion List
-
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than… -
Can we build a single report for BIP or OTBI and then restrict columns for different users.Summary: We have a requirement to build one report and then send it to multiple users with different combination of columns. Content (required): Hi Team, We have a requi…Vikas V. Kamat 52 views 9 comments 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
Duplicate Departments when using Goal Status Overview Real Time Subject AreaSummary Duplicate Departments when using Goal Status Overview Real Time Subject AreaContent Hi Experts! Good day! We are having issues with duplicate departments. Is the…Raymund Jerome 45 views 5 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM
-
What can we do so that OIC applications do not use license limits?Hi, What should be done to prevent the versions created for the live and test environment from using license limits in the applications we develop in the OIC environment…Cansel Karasoy 22 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Position hierarchy report prepared from Oracle AnalysisHi, I am preparing a position hierarchy report using an analysis report. How can I find the person in the next position of a position? RegardsCansel Karasoy 55 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Agent - would like to see why it failed to runSummary: Is there a way to see the reason for an Agent's failure? Content (required): When an Agent fails to run and deliver an Analysis, we can see that it Failed (unde… -
Valid Grade Report-Multiple Grades on jobs auditSummary: We are trying to run a report on all the active valid grades associated with a job, to audit and clean up any that may have multiple grades associated with the …Tammy Hemmingson 41 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is there usage and adoption reports for HCM?Summary: Is there usage and adoption reports for HCM? I see the adoption reports for CRM, but none for HCM. We need some info for a business case we are presenting to pu…TerryM01 94 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Report in Workforce Goals - Goal Status Overview Real Time, Unable to add Organization LevelsI am building an OTBI report in a single subject area (Workforce Goals - Goal Status Overview Real Time). I am able to add Development Goals details from the "Developmen…rd17 142 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Why am I unable to report on the ratings given within a completed performance document?I need to be able to report on the ratings given by the manager for a pre-assigned performance document. I am using the Workforce Management - Performance Rating Real ti…Helen Tilling 51 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables?Summary: Content (required): Hello experts, are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables? If so, could you share t…Valerio Curzi 43 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Document Record Deep Link in SQL Query - use parameter regarding uploaded document record IDSummary: There is a requirement for BI report to have direct / deep link to a document record for persons Content (required): I found the Deep Link URL and several of it…Shant Sarkissian_NES 407 views 3 comments 1 point Most recent by Balaji Vijayakumaran Reporting and Analytics for HCM
-
when i try to schedule the report through agent in condtion section when test its show false why?Summary: Hi Team, when i try to schedule theOTB report through agent in condtion section when test the condtion its show false why? Please help me on ? Thanks, Ajay Cont…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Report or OTBI report - create Bell Icon Notification via BI Publisher scheduler or AgentSummary: How can one trigger the creation of a notification in the Bell Icon, so a BI Publisher BI report or OTBI appear there? Content (required): Want BI to be able to…Shant_Sarkissian_WJG 114 views 3 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Need help connecting Transaction Data to Workforce Management DataSummary: I need to create a report connecting the following subject areas: Human Capital Management - Approval Notification Archive Real Time to Workforce Management - W…Jose Guerra 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Audit on Termination DataSummary: Audit on Termination Data Content (required): Hi All, Greetings! Is there any report available based on audit for termination data for the employees? We'd need …Parag Hiremath 103 views 4 comments 0 points Most recent by Daniel McMillian Reporting and Analytics for HCM -
Mail notification sending and limitHi, Can a special mail extension be used in notifications prepared as bursting and sent via email? For example, it should only go to people whose e-mail is @aaa.com.tr ?…Cansel Karasoy 33 views 2 comments 0 points Most recent by Sandeep19rm Reporting and Analytics for HCM
-
Reporting on Holiday Entitlement and Remaining BalanceHi all, Is it possible to report on total holiday entitlement as one combined field (factoring in employees carry over, annual accrual and other adjustments) within OTBI…
-
I can't see absence approvers in transaction tableHello, I am preparing a report to see who approved or denied the absences for the absence records in the transaction console. However, I cannot access the approver infor…
-
seeded CheckReport USCheckwriterTemplate.rtfSummary: Somehow, the seeded template (US) for CheckReport.xdo appears to be overwritten in the Oracle Fusion HCM BI cloud, trying to find a seeded version for USCheckWr…Ruchika Gujarathi 32 views 3 comments 0 points Most recent by Ruchika Gujarathi Reporting and Analytics for HCM
-
Can somebody assist. on how to get the "Seniority Date" calculation date in OTBI subject report?Summary: How to include Seniority Date calculation date in OTBI subject area report (Please refer the screenshot 1 for reference)? How to include Seniority Date transact…
-
Time zone in BIP .xpt templateSummary: How can we add the user preferred time zone along with Date and time in the BIP .XPT template? I am aware of the tags for RTF template but the requirement is to…Debkanya 45 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli…Brandon Roberts 315 views 13 comments 0 points Most recent by Scott Pisani Reporting and Analytics for HCM -
SQL query for Length of service in years and monthsSummary: Hi, I am trying to add formula in OTBI report on Service Date field to calculate duration in years and months. However, I don't know SQL, but was able to find b… -
SQL query to extract Candidates ResumeSummary: Content (required): Hello experts, we need to recover candidates resume URL. Is it possible to retrieve this information? Which table store resume URLs. Is ther…Valerio Curzi 407 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Not Able pull the Latest Location from "Workforce Management - Worker Assignment Real Time" subjectSummary: Hi, We created the new location and running the OTBI to get the data from subject area "Workforce Management - Worker Assignment Real Time" and has employee det…Kiran Kollamsetti 13 views 2 comments 0 points Most recent by Kiran Kollamsetti Reporting and Analytics for HCM
-
OTBI to fetch adjusted service dates from Work relationshipSummary: Hi everyone, We are trying to fetch the adjusted service date field from the employee work relationships page service dates section through OTBI. Can anyone sug…Prabha_112 136 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Position details with transaction summarySummary: Hello Everyone, I have a requirement to create a position report with a real-time transactional summary. Columns are: I could fetch all the above eleven columns…Saher 52 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to know BI reports andOTBI Reports of scheduled report jobs and Agents list through query or anySummary: Hi Team, we have sceduled reports and OTBI reports through Agents how to get the list of reports scheduled from system any query or OTBI for ? we have report jo…AjayKumar Maddipati 74 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Payslip Reprinting Report flow does not Produce Output and cannot be opened because it has no pagesSummary: Payslip Reprinting Report flow is completed successfully and does not Produce Output and cannot be opened because it has no PDF (Blank) pages ####[2023-07-11T16…Janardhan ACS-Oracle 42 views 3 comments 0 points Most recent by Janardhan ACS-Oracle Reporting and Analytics for HCM