Sample Reports
Discussion List
-
How to fix the error results in this report?Summary: We tried to add a column name ORIGIN from Workforce Management - Person Real time however, every time we add any column from Workforce Learning in the subject a… -
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded…Koteswararao Yenikepalli 186 views 6 comments 1 point Most recent by Ruthwij Reporting and Analytics for ERP -
HDL Template to update assignment recordsSummary: Hi All, I may request a data loader to update all the assignment records simultaneously too since I just received ALL the statuses for 100% of the population to…
-
Is there a way to pull the name of third party provider in the report or only training supplier?Summary: We tried to pull the report the name of the third party provider however, only training supplier for ILT can be pull. We need to pull the name of provider like … -
Talent Pool Report in Oracle BIPSummary: This report is required by the business to report on the grades of talent pool candidates while they are actively part of the talent pool and later, in future y…Pradnya_Pampatwar 43 views 9 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th… -
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…Omran Zeaiter 286 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Compensation Plan Worksheet with notesSummary: I have created a report to pull compensation worksheet with notes. I am facing the following issues: 1) It only picks up employees with Notes. I need to pull th… -
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 32 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card… -
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 532 views 2 comments 1 point Most recent by Yves Chanel Reporting and Analytics for ERP -
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…Omran Zeaiter 281 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Is it possible to fetch details of community in Learning?Summary: OTBI report to fetch community details. Checking on the below subject areas for Learning, there is no related to Community. Workforce Learning - Learning Conten… -
Security of custom reports to be only appear to specific rolesHello, we made custom reports with specific details which should only appeared to specific roles, For example Report A only appear to employees with roles HR Specialist …mshehab 11 views 1 comment 0 points Most recent by Saurabh Poddar-Oracle Reporting & Analytics for Fusion Service -
OTBI-ORC report issue on filter of candidate job application dateSummary: HI Team, when we apply the filter of candidate job application date report running long time without result but when we remove the filter on date it takes only …AjayKumar Maddipati 31 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?Summary: I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management…BeachDreamer 91 views 1 comment 0 points Most recent by Mohamed Mahrir Reporting and Analytics for HCM -
How to report on days since assignment status changeSummary: Hello! I am looking to report on days since Leave. We track leaves using the Assignment Status field, so I am looking to report on days since assignment status … -
when trying to edit a report getting error: Error Codes: OAMP2OPY:U9KP7Q94Unable to run or edit a report getting error -
Subject text update of standard notificationSummary: Subject of standard notification update Content (please ensure you mask any confidential information): Hello experts, does anyone know how to change the subject… -
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "…AjayKumar Maddipati 395 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
IN below OTBI Manager DR report but country name not showing it showing DRS country nameSummary: Hi Team, we have list of people with direct reporties but when we add the country name in the it showing reporties country but we need manager country . Any one…AjayKumar Maddipati 41 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Goal approval request notification template non editableSummary: Goal approval request notification template non editable Content (please ensure you mask any confidential information): Hello experts, we have enabled the appro… -
IN BI Report two parameters From Date to TO Date but need to change TO Date as sysdateSummary: Hi Team, I have changed parameter Todate as SysDate but it correct or not I'm not sure, any one could you please check this is correct data or not on below quer…AjayKumar Maddipati 22 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
time to fill OTBI report in ORCSummary: Does anybody have time to fill OTBI report or dashboard build in ORC? Content (please ensure you mask any confidential information): Version (include the versio…Avinash.Potti 21 views 2 comments 0 points Most recent by Avinash.Potti Reporting and Analytics for HCM -
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…Bernadette Dorris 164 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to convert bip report out format into JSON format by using e-Text templateDear Experts, I need to convert Bip report out format into JSON format by using e-Text template. Please send me the e-Text template and how to use that template with XML…Ravindr-Oracle 492 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 61 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM