BI Publisher
Discussion List
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 27 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Colorado state employee retirement benefits year end reportingWorking with a school district in Colorado whose employees are participants of PERA. PERA has a very specific requirement for reporting year end data in the exact EFW2 S…Muriel Sindyla 12 views 1 comment 0 points Most recent by Rajesh Tota Reporting and Analytics for HCM -
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B… -
Person address data not displaying for user - BI reportSummary: I created one BI report and it has SSN and person details including address. When I ran the report, it shows all the details. When user ran it, the address fiel…Peoplesoft 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to cancel double row in changes BIP report?I have a BI PUBLISHER report that shows changes in addresses and marital status of an employee. I use the table HRC_EVT_OBJ_CHANGE_COMPONENTS, The problem is that it sho…Alex_Balanovsky 13 views 1 comment 0 points Most recent by User_4XX09 Reporting and Analytics for HCM
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 371 views 5 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM
-
Empty Reports on BIP Result files with DATA_DSSummary DATA_DS file removalContent Hello. I have created a daily BIP report that is sent to an SFTP, however the report is not expected to result in records every day. … -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 73 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 52 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
what all types of the condition/logics can be used in e-text templateRequired Types of logics, condition and syntax for e-text templates in BI Publisher -
Count of development Goals analysisSummary Can't add people with 0 Goals altogether with other Assignment fieldsContent Hi Team, We are trying to build an OTBI analysis that lists Person Name, Person Numb…Alvaro Couto 23 views 3 comments 1 point Most recent by Shawn Gertler Reporting and Analytics for HCM -
Tables to fetch queries used in DataModelsSummary: Hello Team, Is there any specific tables that are being used to fetch queries used in Data Models? Is there any way to achieve this? Thanks, Paramesh Content (p…Kurva Paramesh 21 views 3 comments 0 points Most recent by Kurva Paramesh Reporting and Analytics for HCM
-
Secured List Views: For any information related to SLVs please raise a Service RequestSummary: I raised an SR some days ago asking for some additional information on Secured List Views (as instructed by Doc ID 2708546.1). I got this response: Your questio… -
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 11 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
How to customize change personal information workflow notification?Summary: How to customize change personal information workflow notification? Content (required): Hi All, Need to customize the change personal information WF notificatio…
-
there is a way to check access for the report who have ?Summary: Hi Team, we have placed the BI reports in shared folder and some of have given the access the reports based on request but now we need to track the report who h…AjayKumar Maddipati 32 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BIP report to fetch employees that are included in Automated Grade Step ProgressionSummary: Other than GSP_ELIGIBILITY_FLAG from PER_ALL_ASSIGNMENTS_M, is there any tables which can identify employees that are included in Automated Grade Step Progressi…
-
excel output, splitd linesSummary: Content (please ensure you mask any confidential information): HI team, I have a report that one of the field is HTML with new lines, the problm starts where I …Hadassah Friedman 29 views 3 comments 0 points Most recent by Hadassah Friedman Reporting and Analytics for HCM
-
Import Oracle Taleo Recruiting to HCM Fusion.Summary: Hi Team, Could you please let us know, Candidate Imported form Taleo to fusion through "Import Oracle Taleo Recruiting Cloud Service Data" process, in which tab…
-
PDF output with color background other than whiteDear Experts we have a requirement to print a RTF report - PDF output with black background. We have made the required changes. 1. On the Design tab, select Page color b…Saptadip Datta DXB 4 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Oracle OLM - Business wants to track a user and his assigned course progress by date wise break-up.For ex: ******* 1. Maria John did a course on "Sexual_Harassment". She started the course on 1st Jan and stopped after an hour, again continued on 2nd Jan for an hour an…
-
How to get all Active and Inactive Records Regardless of Assignment Type Except for Inactive PendingSummary: Hi All, I have a report that get all Active and Inactive Records but I want to Exclude Inactive Pending Worker only. Any one have already tried this? Trying to …
-
Payroll run exclusion GroupSummary Identifies employees who are in an exclusion group and will not be included in the payroll run.Content Hi, Can you please suggest if Payroll exclusion group is a…User_2025-01-30-20-59-13-989 40 views 4 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Office 2019 Oracle BI Publisher ErrorFor example when I try to load a xml data ı got this message Hello I just downloaded Oracle BI Publisher but at my publisher area there is an error . I tried to install …Kaan Can Calkan 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…User_2025-11-21-00-15-21-711 3 views 2 comments 0 points Most recent by User_2025-11-21-00-15-21-711 Reporting and Analytics for HCM
-
Production to Stage for BIP ReportsSummary Easiest way to copy BIP reports from Production to Stage environmentsContent Hi all - we have two ways that we use BIP reports on our dashboards: 1) Embedded Con…Prudence K 49 views 6 comments 4 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Does BI Publisher allows dates in dd/mm/yyyy format?Summary: Does BI Publisher allows dates in dd/mm/yyyy format? Content (please ensure you mask any confidential information): I see only these formats: I need dd/mm/yyyy …Stefano_Mazzocca 42 views 5 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
unauthorized access: either you do not have the privilegeSummary: Content (please ensure you mask any confidential information): hi team, I have embedded a bi report, but I'm getting this error- unauthorized access: either you…Alex_Balanovsky 13 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
job history reporthi Experts, From the below table I am able to get only the history of past one month. Does anyone now the table names to get the report for more than month ? fusion_ora_…Nivya Mathire 35 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM