BI Publisher
Discussion List
-
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 219 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 155 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 26 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 18 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 435 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 85 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 105 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 140 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 17 views 3 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 59 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
How can we get a list of all Scheduled BIP Reports in Oracle HCM CloudSummary: We are looking for a SQL using which we can get a list of all Scheduled BIP Reports and their recent status Content (please ensure you mask any confidential inf…Mridula Mitra Pal 66 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Solved:I cannot find DOC ID 2478863.1 How to Download and Use the Microsoft Word BI Publisher PluginSummary: Solved by using firefox and using How to Install BI Publisher Desktop Template Builder Add-In - Microsoft Office - Office 365 (Doc ID 2591350.1) ===============…RichardFoxFoxTaskForceNatureScot 296 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
LAG Function not able to pull previous job of an employee.Hello Experts, I am creating a report to pull the previous job of an employee, I am using LAG function to fetch the previous job, but i turns out to fetch the same data …Joliver Caangay 15 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Address change report to capture old and new valuesSummary: I have not been able to build or find a report that captures address change data. We have been looking for something and was wondering if the community would be…Tammy Hemmingson 302 views 5 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Query to fetch manager hierarchy based on Functional Reports-toSummary: Need help in fetching manager hierarchy based on most recently assigned Functional Reports-to manager. Content (please ensure you mask any confidential informat…Dinky Dudeja 452 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Line manager dashboard through My Team > My DashboardSummary: We found the line manager Dashboard that was available through My Team > My Dashboard is no longer accessible for line managers. The function (tile) is no linge…
-
Excel template missing row header infoSummary: I have converted an Excel template to display in rows rather than columns. I have updated the Name Manager and the results display as expected however the param…Viviane Beaudoin 6 views 1 comment 0 points Most recent by Viviane Beaudoin Reporting and Analytics for HCM -
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 148 views 13 comments 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM
-
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 19 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Whenever bursting job ran where can we find the details whom all the trigger is sentHi , We have letters like tenure/grade change we need the detail to whom the trigger is sent. Where will the details stored. Can i get the tables. Please help Regards, S…
-
CMP_ASG_SALARY_V we need these fields zone_name,ZONE_TYPE_NAME,ZONE_TYPE_ID,ZONE_ID related querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Surya Prakash Chetla 19 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM