BI Publisher
Discussion List
-
Audit Trail for OTBI ActivitySummary We would like to see an audit trail of who has made changes to a specific folder of OTBI reports and also who has generated specific reports.Content We have a nu…User_2025-02-06-10-48-34-019 95 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Is it possible to add Department Parameter in Seeded Gross To Net Payroll Report?Summary: I have a requirement to add a Department Parament in GTN Seeded Report Content (required): Version (include the version you are using, if applicable): 22B (11.1… -
NewHireReport not getting triggeredSummary: Content (required): We have set the value as "true" for all the below profile options: BIP_EMAIL_NOTIFICATION_HCM BIP_EMAIL_NOTIFICATION_HCM_IRC BIP_EMAIL_NOTIF…Vinay Gharge 21 views 1 comment 0 points Most recent by Vinay Gharge Reporting and Analytics for HCM
-
Where is 'Expedite Payroll' flag stored?Hi All, Summary: I'm trying to find what table is the 'Expedite Payroll' flag on timecards stored? Content (required): this is what it looks like in front-end Thanks!notautomni9 33 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
When we apply filter below for particular process not working on pending transactions reportSummary: Hi Team, we have developed pending transactions report in that all process are coming like change manger,'Resignation', location, and etc but we need only Resig…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Date is not appearing after transaction madeSummary: Custom report is not reflecting date immediately after transaction is made in system. Content (required): We have created custom reprot which is based on absenc…
-
What tables store the representatives that are assigned to each employee?Summary: I have been tasked with creating either an OTBI analysis or BI Publisher report to pull all employees and the representatives that have been assigned/linked to …BeachDreamer 240 views 6 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
User Last Login Details Using OTBI ReportSummary: OTBI reports to pull out last login user Details Content (required): Hi, We have requirement to pull out last login user details using OTBI report. Is it possib…Vasanthakumar Ravi 1.5K views 5 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How do you join WLF_ATTACHED_DOCUMENTS with other learn tables of coure? For example WLF_LEARNING_ITSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Bhasha Desai 15 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Leave Balance showing incorrect IN Custom BIP reportSummary: Hi Team, Some of emplyoees showing incorrect leave balance that zero and some of have showing corret value . Could you please assit on ? Thanks AJAY Content (re…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Table for Public Info (Me-> Directory-> My Public Info)Summary: We need to fetch the representatives information for an employee. I have tried with PER_ASG_RESPONSIBILITIES but unable to find the information. Please guide me…
-
Adding a BI Publisher Report to a Flow - parameter questionSummary: Hi, I have a BI Publisher report that I want to add to a flow. I have followed the steps described under https://docs.oracle.com/en/cloud/saas/human-resources/2…
-
Deep Link for Employee detailsSummary: Content (required): We have a use-case to send workflow notification BIP Report to the HR Team/Head in case of Termination or Re-hire. Oracle provides the stand…Vinay Gharge 22 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report integration on a pageDear all I integrated a dashboard on a custom page. There are two open points fr which I can't find an answer at the moment: 1. The report is not fully shown. There is a…Annelies Van Erom 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I exctract Work Terms Number field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Work Term Number field to update employee managers by HDL. Is it possible to find this fiel…Valerio Curzi 497 views 14 comments 1 point Most recent by Girish Singh-Oracle Reporting and Analytics for HCM -
What is the Table that stores Oraganization EFF details.Summary: What is the Table that stores Oraganization EFF details. Content (required): What is the Table that stores Oraganization EFF details. Version (include the versi…User_2025-02-12-17-19-33-738 12 views 2 comments 0 points Most recent by User_2025-02-12-17-19-33-738 Reporting and Analytics for HCM
-
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T…
-
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T…ZenG 26 views 1 comment 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
when we using full name column, we are missing the middle name of employee any another column ?Summary: Hi Team, when we using full name column, we are missing the middle name of employee but when we try to using first name , middle name, last name but it is takin…AjayKumar Maddipati 32 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Active Profile QuerySummary: Looking for help on how to build a query that checks for active profiles within different environments Content (required): Hi all, I'm looking to see if anyone …
-
Font size is different for different fields after removing HTML tags in OTBI reportSummary Font size is different for different fields after removing HTML tags in OTBI reportContent Hello Everyone, Can you please help me regarding this issue? Created a…User_1OXJZ 42 views 3 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Is there a way for an Analysis to retrieve the results of a data model?Content Hi, I currently have a data model but I need its results to get displayed via OTBI. Any way to achieve that? Thanks, IsaacICO 27 views 10 comments 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
BIP Bursting - getting duplicate outputsSummary: I have BIP bursting working and delivering an e-mail to my "Split By" value (managers email) and "Delivery By" value (Person Number) successfully. However, it i…Scott Conaway 106 views 0 comments 0 points Started by Scott Conaway Reporting and Analytics for HCM
-
Hiding Output TAB in Schedule Page of ReportSummary: Hiding Output TAB in Schedule Page of Report Content (required): Can we hide via Personalization or Role Duties and Privileges restriction hide the Output TAB i…C.R.Balaji 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to schedule a BI Publisher report to run on interval of 15 daysSummary: Need to schedule a BI Publisher report to run on interval of 15 days. Content (required): Version (include the version you are using, if applicable): Code Snipp…Abhimanyu Kumar27 21 views 2 comments 0 points Most recent by Abhimanyu Kumar27 Reporting and Analytics for HCM
-
Include/Exclude column based on the ParameterSummary: We have requirement to Include/Exclude the column based on the parameter Content (required): We have a requirement to hide a column in the report output based o…Vasanthakumar Ravi 117 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM
-
How to get multiple value from table in Array format in Oracle BISummary: How can get Multiple value for the same data in Array format in one single row Content (required): Get the value in Array format in oracle need sql query Versio…
-
How to change date format in 30-06-2022 to 30-June-2022Summary: Hi Team, we have developed date as of now 30-06-2022 but business wants this format 30-June-2022. to_char(CURRENT_DATE,'DD-MM-YYYY'), -- 30-06-2022 May I know t…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Scheduling Dashboard with BIP ReportSummary: Content (required): I am trying to schedule a dashboard which contains a tab with a BIP Report. When I schedule or export the dashboard, all other tabs (that co…Riti Malhotra 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to fetch the data for Calculation card in HCM Payroll Employee Deduction BI reportSummary: Hi all I am not able to get these data from the backend for Element Name, Value, Effective Start date inside the Calculation Card : Benefit and Pension in HCM. …Deepak Bhatt 112 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM