BI Publisher
Discussion List
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…awheel09 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure…
-
BI Publisher Sending a report to FTP Server with SSHSummary: How do I schedule a report to be delivered to a destination configured with SSH authentication? Content (please ensure you mask any confidential information): H…
-
How to get the assignment name for an OTBI analysis?Summary: I need to know which subject area and fields I need to use, to get the employee assignment name for an OTBI analysis. Content (required): Assignment name Versio…Ayesha Iroshani 81 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What table holds the future incumbents details?I am trying to pull the person number of a future incumbents but i'm not sure what table holds that info. Does anyone know? TIA. 😊Michael Angelo Lucena 21 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Are there agreed standards used by the community when reporting dates?We have adopted the US format for all reporting with users then setting preferences at an account level. Are there any standards which are adopted by customers as best p…Clare Murtagh 1 view 2 comments 1 point Most recent by Clare Murtagh Reporting and Analytics for HCM -
Report on Benefits GroupSummary BEN_BENFTS_GRPContent Hello. I am trying to link the table BEN_BENFTS_GRP (name field) back to the employees (person_id or person_number). I have tried linking i…
-
Birthday alert with Background imageSummary: i have a birthday alert requirement and whenever i try to put the image as background using watermark option, rtf file size is getting increased and getting bel…
-
How to show amount of times a report has been run?Summary: The 'OTBI usage real time' subject area can't show usage of reports - how to report on this? Content (please ensure you mask any confidential information): We h… -
How Do I get access to the WebCenter Content serverSummary: I have SQL provided by Oracle that give me the Content Server URL. When I click it, I get directed to the Content Server, but I do not have access to the file. …Al Darabaris 81 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How can we pass date parameters into the List of values to fetch the data based on the date rangeHow can we pass date parameters into the List of values to fetch the data based on the date range? Based on the dates the recoded should get refreshed in the parameter n…Shanmukhi 161 views 2 comments 0 points Most recent by Vaishnavi Katiyar Reporting and Analytics for HCM
-
EEO-4 Category table nameSummary: Hi, everyone. would like know where I can found this columns. Regulatory Response Ethnicity - TEXT → I can't found the string data data type. EEO-4 Category → E…
-
How to fetch Reason value from ORC in BI reportSummary: Hello Experts, Need your help in pulling a field called reason found in ORC module. PFA the screenshot of the field i want pulled. I am aware this field is pres…Jithin Mathews 51 views 4 comments 0 points Most recent by Nimisha Nirmal QC Reporting and Analytics for HCM
-
Ability to burst output file from BIP Report to OCI object storageWe have a requirement to burst output files of BIP reports to the OCI object storage buckets. Currently we don't see any delivery option in bursting that supports this. …Phaneendra Vallapu 228 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Accessing worker details in learning report by learning specialistDear Community, We have the BIP report request from user which required to show worker name, worker number and department information in the report. While the users are … -
Learning assignment alert delivery reportSummary: We have a requirement to report on the delivery of compliance assigned training alerts for audit purposes. Content (please ensure you mask any confidential info… -
How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.Sourabh_Patial 151 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM
-
Subject Area (or Table) for Regional General Preferences?Summary: Are the General Preferences: Regional reportable in OTBI/BIP? Content (please ensure you mask any confidential information): Hello everyone, Asking if it is cur…Tom John Bontoyan 21 views 2 comments 0 points Most recent by Anusha B S Reporting and Analytics for HCM
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.
-
How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co… -
How to run Oracle Standard Cheque Report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report cheque report of payroll module of HCM. But I don't know how to run this report. Thanks Content (please ensure y…
-
Runtime Properties on BI Published Configuration SettingsHello, Recently, the Sever value for parameter "Exclude Line Feed And Carriage Return for LOB" was updated to TRUE which caused some of our interfaces to exclude Line Fe…Nishit Doshi 11 views 1 comment 0 points Most recent by Sunder Subramanyan-Support-Oracle Reporting and Analytics for HCM
-
BI Report ran using SOAP service is not picking multiple input parametersSummary: We have a requirement to run BI publisher report using SOAP request. There are 3 input parameters there in the report as well as passed through the SOAP request…
-
Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv…
-
How to query user details if person_id and party_id are null and no data in per_ldap_users?Summary: Customer has requested a report to display all the usernames along with their first name, last name, email etc. I have encountered a username for whom person_id…Abhi_19 444 views 2 comments 0 points Most recent by Adrian Nae-Oracle Reporting and Analytics for HCM
-
Need a SQL query to get the value for Parent Position for the employee's Assignment Position.Summary Need a SQL query to get the value for Parent Position for the employee's Assignment Position.Content Need a SQL query to get the value for Parent Position for th…JP Chandran 2.5K views 6 comments 0 points Most recent by user3929728 Reporting and Analytics for HCM -
Can Employer Comment under Termination Details be on a report?Summary Is there a way to add the Employer Comment informaiton to a reportContent We list the company that an employee leaves us for in the Employer Comments box on the …Denise Jo Crangle 82 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to query Content server objects?Summary: I would like to query a list of specific Content ID's from object in the content server (https://.fa.em2.oraclecloud.com/cs). Is it possible to find the content…Mia Tøttrup 101 views 3 comments 0 points Most recent by Mia Tøttrup Fusion Applications Administration -
Fast Formula ReportSummary Fast Formula ReportContent Hi Experts, Is it possible to download a report of all fast formula details along with code? Regards, Nivya Version 18CNivya Mathire 134 views 4 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Data not appearing on all tabs of an Excel report when run as a payroll FlowSummary: We have an HDL Error report that is based on a Data Model and creates an Excel spreadsheet with 3 tabs of data. The first tab is the Summary, the second lists a…Al Darabaris 11 views 3 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM