BI Publisher
Discussion List
-
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Enforce 2 decimal places after a column result in s query.Summary: The table column can have values like 2,3,56.78,34,8 etc. We need something on the query such that 2 must show up in query result as 2.00, 67 as 67.00,45.6 as 4…Aloka Bhattacharya 151 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
HCM Extract and Bi Publisher delivery option auditHi Whatever change has been made to the delivery option in both HCM extract and BI Publisher. Does the change and the user who made changes gets audited?? If Yes, could … -
Non-Hired ApplicantsSummary: I need a report that lists all non-hired applicants in the past year. Content (required): Looking for a way to list all candidates that applied for open positio…Scott Conaway 21 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Unable to get data in HCM Extract linked BI report after 21D updateSummary: I have created a dummy extract, and have linked a BI report to the Extract delivery option (as we need to use autoload parameter in HCM extracts, data is coming…User_2025-02-11-23-20-16-609 61 views 0 comments 0 points Started by User_2025-02-11-23-20-16-609 HCM Extract -
Job offer letters issuei am working on recruiting module in HCM Cloud i wanted to create Job offer letters. we have mulcible templates for same requisitions using some conditions in main templ…Akram1206 31 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Loss of benefit eligibilitySummary: Content (required): I am trying to report on employees who are losing eligibility to benefits based on recent life events processing. Can anyone help me with th…Scott Paulin 11 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
Is there a way to track the 'Recommended Candidates' from the AI database tables back to the req?Summary: The aim is to develop a report to analyse how many 'Recommended Candidates' are actually being hired. Hence, looking for a way to report this using the AI table…Dheepak Jeevaraj 11 views 0 comments 0 points Started by Dheepak Jeevaraj Reporting and Analytics for HCM -
Learning bi publisher report How to display learner activity's status and grade?Hello , How can we implement BI publisher report ,which displays the status and grade of activity of learners in a course. A course can have few offerings - and we would…Revital Mefano 21 views 2 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
How to "decode" Notice Period UOMSummary: How do one decode Notice_Period_UOM in SQL/Query Builder Content (required): How do one decode Notice_Period_UOM in SQL, so that the output display e.g. days, m…
-
Need table names for reporting on the report job historyContent Hi All, Could you please provide the table names associated with the report job history. We need to pull the data for a report where email is being sent to emplo… -
how to send a email and place file in sftp server using BurstingSummary: how to send a email and place file in sftp server using Bursting Content (required): My Requirement is to place a file into SFTP location and sending a email no…Pritam Das 251 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
How to use current system date as a prompt and bring current year value as a column in OTBISummary: Hi Team, I have a requirement to use current system date as a prompt in an OTBI and bring current year as a static value in a OTBI. Please suggest solutions. Th…
-
Attendance Register Report for LearnSummary Attendance Register Report for LearnContent Does anyone have an Attendance Register Report for Learn? To list delegates within a specific ILT Offering / Activity…Ruzwan Akram 72 views 2 comments 0 points Most recent by Esther Hess Reporting and Analytics for HCM
-
Using Session Variable can be used in BIP report to restrict data based on the user who will run it?Summary: Is Using Session Variable can be used in BIP report to restrict data based on the user who will run it? Content (required): Hello, I am running a BIP report reg…Hazel De Castro 42 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Is it possible to download the BIP output files to the particular folder in Machine?Summary: Is it possible to download the BIP output files to the particular folder in Machine? Suppose when we run any report, is there a way to download the output files…Kovi Harish Kumar 21 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Is it possible to download the BIP output files to the particular folder in Machine?Summary: Is it possible to download the BIP output files to the particular folder in Machine? Suppose when we run any report, is there a way to download the output files…
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names/SQL that is being used in the Workforce Learning - Learning Management Real Time subject are .we have requirement…minati_behera-Oracle 101 views 2 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
Need a BI Publisher Add-In Supported by MS Office 365Summary Need a BI Publisher Add-In Supported by MS Office 365Content Hi, We need a BI Publisher Add-In Supported by MS Office 365. Please provide a link to download the … -
Error uninstall Oracle BI Publisher Desktop 1670:Unable to Load module with error code:1114Summary: We are trying to uninstall Oracle BI publisher Desktop , but we are getting below error 1670: Unable to load module c:\Users\Admin... Error Code: 1114 Could you…
-
Table for Pension Scheme name stored at PAE at UK calculation CardSummary Table for Pension Scheme name stored at PAE at UK calculation CardContent Hi Experts, I am try to pull the Active Qualifying Scheme for employee stored at PAE UK…
-
How to Calculate Payroll ReversalsSummary: How to include payroll reversal values in calculation Content (required): We have BI publisher report that calculates Payroll distribution for all of our employ…GauravGupta39 61 views 5 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Email Notification when Employee Changes Their NameSummary: I would like to setup an email notification to go out to a particular address each time an employee changes their name. Or optionally one email per day with a l…User_2025-02-12-02-38-00-520 21 views 4 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM
-
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher…
-
Table name to query the Delegation Approval rule and categorySummary Table name to query the Delegation Approval rule and categoryContent I have a requirement to create a report for Delegation Approval Rule and category informatio…Sricharan Monigari 481 views 5 comments 0 points Most recent by Visu Reporting and Analytics for HCM -
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…Mohan Murali 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Organization Audit ReportSummary BIP Audit Query to tract the mutations happened with respect to Departments.Content Hi All, We have a BIP requirement to tract down the mutations that are happen…User_2025-02-10-16-28-01-402 47 views 4 comments 1 point Most recent by Karen Long Reporting and Analytics for HCM
-
SQL to return all job roles where a particular duty role is usedSummary: SQL to return all job roles where a particular duty role is used Content (required): Hi Team, Please share SQL to return all job roles where a particular duty r… -
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 511 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM