BI Publisher
Discussion List
-
BI Publisher security on expatriatesSummary: BI Publisher using secured view shows records outside scope of user's AOR who is running the report Content (required): Hello, We have a BI Publisher report on … -
Job detail HistoryHi Team, I am looking for table or Subject area to pull the Job detail history. The Navigation to view history details is given below: My Client groups->Workforce struct…Praveen_Chouhan 45 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on specific Manager and his/her actions with employeesSummary: Content (required): Good afternoon. We have a request to identify any employees that one specific manager either Supervised (their direct supervisor), Hired (th… -
Looking for Learning Reports specified in 20A release notesSummary: NOW RESOLVED. 22/05/23 Hi, I'm looking for a set of reports that were listed on the 20A Oracle release notes (https://www.oracle.com/webfolder/technetwork/tutor…
-
Converting payroll elements from one currency to anotherSummary: Content (required): Hello experts, Do you know if now it is available in OTBI and UI the possibility to convert payroll elements from one currency to another ac…Valerio Curzi 48 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Reporting and Documents of Record Updating / UploadingHi all, Apologies if this is the wrong place to ask. We're looking to build a report within BIP that produces a letter of reference that can be saved to an employee's do…
-
How can restrict the data in reports?Summary: How can restrict the data in reports? Content (required): Hi Team, Can some one help me to understand, how to restrict the data in reports. For example we have …
-
Need to know approval date file & table name of absence records attached my sql, if anyone please moSummary: we use oracle fusion cloud. OBI report and analytic Need to know approval date file & table name of absence records attached my sql, if anyone please modify and…RIfdhy Zain 533 views 3 comments 0 points Most recent by RIfdhy Zain Reporting and Analytics for HCM -
Seeded EEO and VETS ReportingSummary Is anyone using the seeded EEO and VETS Reporting?Content Hello Customer Connect Community, Has anyone used the seeded EEO and VETS reporting from Fusion HCM yet…User_2025-01-22-19-43-38-766 292 views 17 comments 0 points Most recent by Suppu Reporting and Analytics for HCM -
How to find deeplink for Allocate Checklist page?Summary: How to find deeplink for Allocate Checklist page? Content (required): Hi All, How to find deep link for Allocate Checklist Page? From Tools -> deep links , i go…
-
Report on Learning Alerts Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas or BI tables that can be used to report on the learn notifications that are sent out using the Alert Comp…Mahesh_M123 174 views 4 comments 0 points Most recent by Swaraj_Sudhagonela Reporting and Analytics for HCM
-
Logic on Audit bit map field in per_all_Assignments_m_ tableSummary: We are working on an audit requirement to track the insert, update and delete assignment records over a given period of time. We have enabled the audit for prod…User_2025-10-31-01-02-51-214 155 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to remove certain part of a column after parenthesis in BI reportSummary: Hi All, I want to remove the part of Tax Reporting Unit column from where the parenthesis is starting. Please suggest the function to use this in sql. Example: …Dona Das-Oracle 56 views 6 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for HCM
-
In Xsl template we are getting error like:sun.util.calendar.ZoneInfo cannot be cast to java.util.SimSummary: Hi Team, Hope everyone is doing good! We have an requirement, where we have to use Current date condition in xsl template as mentioned below, but we are getting…MaheshRayudu7 66 views 2 comments 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM
-
OTBI Anaylsis to retrieve Security roles by usersHello, How can I create an OTBI Analysis to pull users along with their Security Roles or by able search the Role to see all the users using that role? Any help is appre…Gail Wilmoth 46 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Just like for each that populate several rows in Excel Template, can we do the same for columns?Summary: Hello, For the Recruiting module, our client wants to have a report that dynamically populates the Questions found in Questionnaires of Job Requisitions based o…
-
Oracle BI Publiser for fusion . Applying parameters for excel dataset on element by expression.Summary: Content (required): Hi Gurus, I'm using an excel dataset with 'Element by expression' as explained on the image image . The question is: is it possible filterni…Enzo Venturini 36 views 2 comments 0 points Most recent by Enzo Venturini Reporting and Analytics for HCM -
Need a report that shows assignment numbers that DO NOT have a tax card associationSummary: I'm looking for help on developing a query that will fetch Employee Name, Person Number, Assignment Number, and Assignment Effective Start Date for any assignme…
-
How to hide Mark as read and Mark as unread links based on condition in workflow notificationSummary: How to hide Mark as read and Mark as unread links based on condition in workflow notification(Checklist task) Content (required): Hi All, We got a requirement t…
-
how to call fast formula from SQLSummary: how to call fast formula from SQL Content (required): Hi All, Is it possible to call Fast formula from SQL to verify the FF results? Thanks, Venkatesan R Versio…Venkatesan 788 views 4 comments 1 point Most recent by Ketan Prajapati Reporting and Analytics for HCM
-
How to pull data from Human Capital Management and Workforce Management subject areas?Summary: How can data from the Human Capital Management Approval Notification and Archive Real Time and Workforce Management Person Real Time subject areas be effectivel…Basti 47 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 25 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Impossible to get report output for only some usersSummary: Impossible to get report output for only some users when launching them Content (required): Hello experts, we have been having problems since November 2022 for …Oriana L. 168 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How can I have a data model for Line Managers with Inactive - Payroll Eligible status?Summary: The organization decided to just use one BU. In so doing, there are expense reports generate and managers have not assigned to the new BU. Content (required): W…
-
Benefit Certifications tableSummary: We have a requirement to fetch "Certifications" tab related data in the BIP report. May I know in which tables holds the information on certification? Content (…Satyabrata Nanda 57 views 5 comments 2 points Most recent by Viral Abotiyawala-Oracle Reporting and Analytics for HCM -
OTBI if Grade is Null those employees are not fetching in the report.Summary: We are adding version 3 seniority dates in OTBI existing report, added new subject area "Workforce Management - Person Seniority Real Time" when using filter co…challa praveen 75 views 8 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
How to display the value to be in line using BI Publisher (rtf)Summary: We want to display value in line from the RTF Template. However it displays as per below. Content (required): Please find attached RTF Template and XML Version …Aries 393 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsSummary How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsContent Hi Experts, How to Prevent merging columns in excel output using RTF temp…Bala Kasineedi 1.3K views 6 comments 0 points Most recent by User_67JNL Reporting and Analytics for HCM