Sample Reports
Discussion List
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need … -
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme…Cansel Karasoy 1.2K views 8 comments 0 points Most recent by User_E31A6 Reporting and Analytics for HCM -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.1K views 18 comments 1 point Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 84 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ…Nusrat Shaheen 71 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…JSalarza 147 views 7 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM
-
Sample report (preferably OTBI) of candidates that have applied using multiple emailsSummary: Does anyone have a report (preferably OTBI) of candidates that have applied using that one email. In essence, same candidate name and address applying with mult… -
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…Swati U 3.5K views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th… -
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Document of Record Drill to Document DetailsSummary: This report uses Deep Links for Document Records to navigate directly to the worker's DOR from the report results without additional clicks or navigation. Conte…Melanie Mahon-Oracle 192 views 4 comments 7 points Most recent by Samantha Collins Reporting and Analytics for HCM -
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
I need a query which will fetch Percentage of completed performance reviews with highest ratingsSummary: I need a query which will fetch Percentage of completed performance reviews with highest ratings Content (please ensure you mask any confidential information): …
-
I need a query which will fetch Percentage of employees with succession plansSummary: I need a query which will fetch Percentage of employees with succession plans in fusion hcm talent management Content (please ensure you mask any confidential i…
-
I need a query which will fetch Cycle time in days for the formal performance review processSummary: I need a query which will fetch Cycle time in days for the formal performance review process from start to finish Content (please ensure you mask any confidenti…
-
Sign On Bonus Effective Date ReportWe have a OTBI Sign On Bonus report that runs based on hire date. I'm looking to update this report to pull based on Sign On Bonus Effective date instead. However, when …Nicole A. 12 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Course Completion ReportSummary: Looking for something similar to what we see in the Learners section of a course/transcript. I'm able to build off of completed activities, but when an offering…
-
OTBI – Calculate Percentage of Responses per Question in Learning Evaluation SurveysHi everyone, I'm building an analysis in OTBI using the Workforce Learning – Learning Records Real Time subject area, and I’m looking to better understand how learners r… -
Report that shows job requisition salary vs job offer salary.Hello I am trying to pull together a report that compares the requisition salary and the job offer salary filtering only on requisitions that are filled. I am unable to …HCM_Dot 123 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI Publisher – Is it Possible to Reposition the 'Processing' Notification for Wide Reports?Summary: In BI Publisher, when running a report that is horizontally wide, the "Processing" notification only appears near the center of the report layout. This requires…
-
How to get list of tables that stored a data in oracle fusion hcmSummary: I am looking for list of table name that stored a data in oracle fusion hcm. Content (please ensure you mask any confidential information): Version (include the…Anup Karmankar 29 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
when I scheduled OTBI report through agent it's failingSummary: Hi Team, when I scheduled OTBI report through agent it's failing. Thanks, Ajay Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 94 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr … -
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …SowmyaSk 466 views 9 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
Report on Benefits Self-Service Enrollment actionsSummary: Looking for a way to report whether employees went through the Benefits Self-Service enrollment process thoroughly. For example, did an employee click on Enroll…
-
BIP Report Query to Fetch Participant (Matrix Manager ) as Reviewer in Perfofmance DocumentSummary: Can anybody Please share the query to Fetch details of Participant Name as Matrix Manager as Reviewer along with Review Period and Performance Documents in Perf…MilanMohanty 104 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
In My report have two views is Pivot table view and Table view how can we schedule both to emailSummary: Hi Team, In My report have two views that is Pivot table view and Table view how can we schedule both to email. when i tried it goes to only table view report. …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports …Abhishek Dixit-Oracle 267 views 7 comments 5 points Most recent by MMS Reporting and Analytics for HCM -
V3 seniority date multiple seniority date in OTBI IssueSummary: We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling ju…