Reports
Discussion List
-
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 41 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 311 views 13 comments 0 points Most recent by Scott Pisani Reporting and Analytics for HCM -
Is there a way to copy One Grid in Report A to Report BSummary: Is there a way to copy One Grid in Report A to Report B Content (required): Is there a way to copy One Grid in Report A to Report B. I have very length Grid in … -
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 511 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Steps to Create BIP Reports type ESS Job with Table type value setSummary: Steps to Create BIP Reports type ESS Job with Table type value set Content (required): Hi All, We have a requirement to create ESS Job for BIP Report with multi…RupaliGahalot 141 views 2 comments 0 points Most recent by RupaliGahalot Reporting and Analytics for ERP
-
Excel generated from RTF template is giving wrong valuesSummary: Excel generated from RTF template is giving wrong values Content (required): I have developed a query to get TransactionDr field from GL Lines table. For a spec…Jaeyshree K K 111 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 11 views 2 comments 0 points Most recent by Kiran Kollamsetti Reporting and Analytics for HCM
-
Customer statement for ad hoc queryingSummary: I need a report (BIP or analysis), that gives me the possibility to create an ad hoc Customer Statement. Content (required): The seeded report "Generate Custome…Anders W. Langholm 51 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
Requires to create a role to create reports onlySummary: We have a requirement to create a role that have access to create reports only. Where any Financials or SCM or any other modules are not given access to create …Janitha Perera 181 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
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 61 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 81 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 43 views 3 comments 0 points Most recent by Janardhan ACS-Oracle Reporting and Analytics for HCM
-
Timeout while using ESS to manage BI submissionSummary: Our ESS job keeps failing with an odd error but if we manually submit the BI it succeeds Content (required): We have a long-running BI query which has been gran…Scott Paulin 371 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
Conditional Suppression Based on DateWe are trying to use Conditional Suppression to suppress rows based on a date. In Planning, users enter a date at an Account set to a Data Type of "Date." This same inte…
-
We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle DocsSummary: Hi Team, We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle Docs. Any one help me on ? Thanks, Ajay Content (required)…AjayKumar Maddipati 841 views 11 comments 1 point Most recent by Sudheer Patel Reporting and Analytics for HCM
-
Analysis/SQL Query behind Standard Purchase Order InfotilesVersion (include the version you are using, if applicable): Oracle Fusion Cloud Applications: 22D (11.13.22.10.0) Summary: How to Get the actual OTBI Analysis behind sta…Donald 401 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
OTBI Report parameters and export optionsSummary:. 1.Check to have the parameters section display always after report is run instead of having to go to catalog and come back again to rerun the report. Update OT…
-
Mouseover on Performance TileDears, is it possible to change somehow the mouseover on performance title? I've been trying to add an html "title" within the cell header but that did not work. Thanks …Domenico P. 41 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
HCM Integration with ADP for Absence and OTLSummary: We are trying to create an integration from HCM to ADP with Absence and OTL Data. Content (required): Has anyone implemented this as this is very basic requirem…
-
Hierarchy not availble in BIWe have created an Organzaiotn Hierachy as per 1th of january 2023. The tree version is active, but noy (yet) avaliable in BI. Same for a Department Hierarchy. Is there …Wouter.Schaap 21 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Custom Performance Management Audit BI ReportSummary: Build a custom BI report that contains audit for performance document Content (required): Would like to know if there's an oracle hcm table to capture the previ…
-
Creating a My Reporting tab in HCMSummary: Anyone created a My Reporting tab in HCM with links to dashboards? Content (required): I was recently on a demo using the Vision environment and spotted that a …
-
Standard OTBI report displaySummary: Content (required): Hello everyone, We are experiencing problems with the visualization of a standard OTBI made available by Oracle that allows the 'department …Gerardo Peluso 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Form output created in BI PublisherI prepared a absence form using BI Publisher, when I add the relevant fields, it does not change according to the person, the only date is fixed. What could be the cause…Cansel Karasoy 61 views 15 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BIP Report QuerySummary: Hi All, We created one BIP report where we can run by the Department name that shows all Position in the Department (both filled and vacant) and their Parent Po…Sakthi Priya S 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Statutory Packs with FCCSummary: I would be interested to know if anyone has experience of producing statutory reports with the bulk of the data coming from FCC. The reports include manual inpu…Nigel Keedy 21 views 2 comments 0 points Most recent by Nigel Keedy Financial Consolidation and Close
-
Executing seeded data model to display report - TalentProfileDMSummary: How can I run the seeded data model, TalentProfileDM, to review the data that I have input into the talent profile? Content (required): This is a massive data m…User_2025-02-05-22-55-58-511 31 views 1 comment 0 points Most recent by Welsey Reporting and Analytics for HCM