BI Publisher
Discussion List
-
The OTL compliance table hwm_tm_comp_msgs_v purging the missing time card dataHi, I have created a Time Card Status BIP Report to display for the Entered (With Time Card status value) & Non-Entered(Missing Time Cards) data. I have used the hwm_tm_… -
<?ref:xdo0053?> for XML tags for LARGE form field size seeded RTF templateSummary: Current seeded template not meeting client requirements so having issues for seeded template of on making changes of adding additional fields Content (please e…Mallik Kencha 34 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Can we use case when condition in Parameter 1(To email address) while using burstingSummary: Can we use case when condition in Parameter 1 (To -email address) while bursting. Content (required): I need to deliver report to different email address as per…
-
Goals related OTBI report-Location dependencySummary: Hi, I have created OTBI report for performance goals , for the people who don't have location , in my report it is showing goals are not created even though the…
-
Manage Audit Policies -> AUDIT_CHANGE_BIT_MAP_Content Helo, I have activate the audit of assignment object : Navigator > Setup and Maintenance > All Tasks > Name : Manage Audit Policies> Search > Go To task > Audit …User_2025-01-25-01-33-46-269 551 views 4 comments 0 points Most recent by cesar.contrerasz Reporting and Analytics for HCM -
OTBI-Learning-Is there a way to report on who specifically took the action to Withdraw the learner?Summary: OTBI - Learning Module - Is there a way to report on who specifically took the action to Withdraw the learner or who assigned the Learning item to the learner? …Harish Malik 50 views 3 comments 0 points Most recent by Harish Malik Reporting and Analytics for HCM -
BI Publisher RTF Template Error - conditionsHi All, I'm working on an offer letter template where I need to use the below if then statement. It is working as expected by itself. However, I need to use it to replac…Balazs Grajczar 42 views 2 comments 0 points Most recent by Balazs Grajczar Reporting and Analytics for HCM -
BIP Report: How to auto scale a graph in percent to 100Hi everyone, I would like to ask if anyone has a similar report where you were able to plot column values as percentages and scale the graph to display 100%. Columns: - …CAMIL_Q 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Report for onboarding buddySummary: In which table can I find the oboarding buddy? I need a query to extract it in a report BI. Version (include the version you are using, if applicable): 24AGian Luca Triglia 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
etext issue for multiple child tag printing with master record multiple timesSummary: Hi All, Need your suggestions on how to solve the below requirement: We have a created HCM Extract to deliver data to a third party Benefits provider The XML st…Prashant Prabhakar Fusion 3 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to wrap text in BIP report with excel outputSummary: Is there a possible way to wrap the text in BIP report? In the current setup, the description in the field is too long to fit within the cell, making it difficu…
-
Is there any table that stores the transaction of the Transfer Direct Reports transaction?Summary: Which table stores the transaction or transaction history of the Transfer Direct Reports transaction in Fusion? Need to pull the one who initiated or do the Tra…James Leborn 1 view 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Oracle BI tables to retrieve individual compensation plan nameSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom report. Do you know the BI table to retrieve Individual Com…Valerio Curzi 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
LRU Registration ReportSummary: LRU Registration Report Content (required): Hi Team, Greetings! We have the details for LRU (Legal Reporting Unit) Registration defined under "Manager Legal Rep…Parag Hiremath 71 views 11 comments 0 points Most recent by Chris Carloff Reporting and Analytics for HCM -
In what table can I find Box_Assignment Column from Talent Review?Summary: In the Oracle Fusion Cloud HCM Talent Review module, wherein the Tables and Views for HCM can I find the value for the Box Assignment? Content (please ensure yo…
-
XML-2200 Error while parsing XSL fileHello everyone, I would like to ask if anyone has experience this error in BIP Reporting? The issue was encountered after migrating the report to another environment. Th…
-
Are there any out of the box reports that would tell me if a Second Pass email was triggeredSummary: Looking for an out of the box report that would tell me if Second pass emails are being sent to applicants. Content (please ensure you mask any confidential inf…
-
Bar graph using BIP reportI have a bar graph in my BIP report , but the values are coming in decimal. In the Data model it is coming without decimal. Is it possible to have the values display on …Shreya Datir 11 views 1 comment 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
Is it possible to track who changed user roles and when it happened in Security Console?Summary: Content (required): Hello experts, is there a way by OTBI or SQL to retrieve who changed user roles in security console and when it occured? Thanks in advance f…Valerio Curzi 737 views 6 comments 0 points Most recent by Pavan Kumar Thummalapalli Reporting and Analytics for HCM
-
Report for a Salary basis of the type "Salary amount is determined by simple components"Summary: We have a Salary Basis defined of the type "Salary amount is determined by simple components" and we have hired an employee with this salary basis. There are 5 …Sachin_Shirke 333 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the…User_2025-02-01-06-07-07-886 836 views 7 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
Query to Display the Roles with their Data Security Profiles NameContent Hi Team, Has anyone created any report to display the List of Roles along with their assigned Data Security Profiles. Regards, Harish Vummidi Version 21CHarishVummidi 162 views 15 comments 1 point Most recent by Mohit_Pal Reporting and Analytics for HCM -
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t…Manoharan 45 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
Transpose rows to columns in OTBISummary I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent Hi I hope you can help me. I need to build a report th…
-
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)…THawkins_LGI 82 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
PDF output is not giving the correct fontContent Hi, we are trying to generate a PDF output with custom font. While downloading RTF output, it is giving correct font, but PDF is not giving the same font. How do…Nivya Mathire 88 views 8 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
How do you display the run date, time (AM/PM), and timezone. Example 11/28/23 11:57 AM ESTSummary: When running a BIP report I am trying to show the timezone of the run date and time being displayed. I am using an RFT template. Content (please ensure you mask…
-
How to use an OTBI analysis to create a data model with a parameter (prompted?)Summary: I am trying to use an OTBI analysis to create a data model. My data model will be refrenced by Oracle Journeys so there is a requirement that I attach a specifi…Amy Wilson 789 views 7 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM -
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 41 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Business Unit Hierarchy looking for Parent Business Unit NameSummary: I would like to know what table Parent Business Unit Name is in for a BI publisher SQL Content (please ensure you mask any confidential information): Version (i…