Reports
Discussion List
-
Tables for Helpdesk Service Request to capture Journey assignedSummary: Hi All, We recently implemented Journey's integration with Next gen helpdesk in which agents can assign journeys to end users. We have used Journeys to send a h…VishalDhane_HCM 13 views 2 comments 0 points Most recent by Himani1992 Reporting and Analytics for HCM -
Is it possible to run an OTBI report and the results to be what my manager would seeI want to be able to build reports in OTBI for employees to run, with the results to return as if it was their line manager running the report themselves. I understand t…
-
Query optimization questionSummary: Processing is fast only when not filtering by wlf_assignment_records_f.COMPLETION_DATE Content (please ensure you mask any confidential information): I have a l…Stefano_Mazzocca 34 views 6 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Logical SQL not returning dataSummary: I have built a report using logical SQL is not returning expected data - possible subquery issue Content (please ensure you mask any confidential information): …
-
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat…Riti Malhotra 41 views 3 comments 1 point Most recent by Riti Malhotra Reporting and Analytics for HCM
-
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…JMLMIII 55 views 6 comments 0 points Most recent by Vidhya Nadarajan-Oracle Reporting and Analytics for HCM
-
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…VincenzoCoppola 129 views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
pension reason for leaving qualifying schemeSummary: Report on Employees who have opted out of a pension scheme. Content (please ensure you mask any confidential information): Hi All. Trying to create a report tha…
-
How to connect organization hierarchy with job requisition?Summary: I am using recruiting real time subject area and trying to connect Job Requisition with Level 3 Organization Name but unable to get result on the Level 3 org na…
-
How to export three reports output into a single pageHi Team, I have merged three reports into a single page. Out of the three, two are OTBI reports & one is a BIP report. When I am trying to export data, only two OTBI rep…
-
Repeating Groups - Excel TemplateHello. Does anyone have any idea on how to make this kind of layout on Excel Templates using BI Publisher? How to make a repeating group like this? -
RTF Template| Bar Graph | Error: Invalid DataSummary: Hi all, I am working on the RTF template where requirement is to show the data in the bar graph format and it is giving me error like invalid data. For testing …
-
How can I get Double Quotes in eText file for column data which has comma (,)Summary: How can I ensure that data containing a comma (,) is enclosed in double quotes when exporting a comma-separated values .txt file from Oracle Example 1 (No comma…Janardhana Kondaveeti 11 views 3 comments 0 points Most recent by MJ_ Reporting and Analytics for HCM -
How to audit managers/employees comments on a Performance DocumentSummary: Using Audit Reports I am unable to see comments on Performance Documents, is this possible via this or reporting? Content (please ensure you mask any confidenti…Tracy Shelmerdine 8 views 0 comments 0 points Started by Tracy Shelmerdine Reporting and Analytics for HCM
-
Custom HR View Only Role to Run HR ReportsSummary Need HR Custom Role BuiltContent Hi all, I need to create custom role that provides access to run some reports in our HR folder, without granting HR roles to tha…Kevin_W 80 views 11 comments 0 points Most recent by Zaneta Zetkowski Reporting and Analytics for HCM -
I need a unique users report in HCM Fusion.Summary: User Audit Report. Content (please ensure you mask any confidential information): Hello, everyone! I need a report or query that allows me to identify unique us…
-
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…
-
Requirement is to display image uploaded in DOR in BIP reportRequirement is to display image uploaded in DOR in BIP report. I am able to get the UCM content id how to get the image that was uploaded in XML to use in RTF ? select f…
-
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 5 views 2 comments 1 point Most recent by Venkat Vatikuti Reporting and Analytics for HCM
-
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri 2.3K views 3 comments 0 points Most recent by Ashish1Soni Reporting and Analytics for HCM
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Participant Feedback Report including feedback from 360 performance - need helpSummary: Hi there, hoping someone could help me out: This report using Subject Area: Workforce Performance - Requested Feedback Real Time does not include the participan…
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every…
-
Buyer Assignment Rules OTBI ReportGood Day Experts, Is there a way to create an OTBI report to show details and information for Buyer Assignment Rules? Screenshot below is the view from Fusion Applicatio…
-
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached … -
HCM alerts real time Subject Area - data not returningSummary: HCM alerts real time Subject Area - data not returning Content (please ensure you mask any confidential information): Hello I am trying to write an Analysis usi…
-
How to report on journey task expiration configuration?Summary: Is it possible to report on journey task expiration configuration (i.e. Task 1 expires 10 days after assigned date, Task 2 expires 10 days after due date, etc.)…
-
How to fetch the survey section from Performance DocumentHello Experts, Does anyone know where in the tables to fetch the Survey section from performance document? Please Help! TIA
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.2K views 4 comments 5 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c…