BI Publisher
Discussion List
-
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen… -
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…Swati U 2.1K views 4 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
Can we restrict learning course details from backend for reporting ?Summary: We would like to give restricted access to the technical person to on the basis of specific course or offering details in oracle learning cloud . We would like …
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
The scheduled BIP report is not received to gmail accountsSummary: Content (required): We've scheduled the report to be received by the users with specific roles. It is successfully delivered for some of the accounts but we hav…Evgeniya Repnina 32 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Reporting on rejection commentsSummary What is the name of the BI database table that stores the tracking of rejection comments for transactions?Content I was easily able to find / report on the comme…User_2025-01-28-21-53-32-678 142 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Learning item access group -BIP table to fetch Person Number List details for Learning access groupSummary: I am working on one BIP report where I am fetching one column to learning access group members using Person Number List options. In which table the person numbe…Kamini Kaushik-Oracle 43 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …
-
I want to use hth.xml_data_cache.getClobVal() to get the Promotion details like new Position, etcSummary: I want to use the hth.xml_data_cache.getClobVal() function to display the Promotion details like new Position, new Manager, new Salary in separate columns. How …Consultant Ian 21 views 0 comments 0 points Started by Consultant Ian Reporting and Analytics for HCM -
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or … -
It is possible to track compensation change statements line manager have already downloaded?Summary: Content (required): Hello experts, in the compensation change statements system page (please, see the attached screen) our customer want to create a checkbox wh… -
How to export all pages on a dashboardHello, Is there any way we can export a full dashboard and it return the full table of results rather than just the rows shown on the dashboard page? Thanks, Stacey
-
BIP Report LOV becomes read-only when the number of characters increasesSummary: Content (required): I am trying to build a report with prompts for Degree, Certifications, Languages, Major etc. profile items. I have used SQL queries as LOV t…Akash Kiran Jana 68 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to send the BIP report output to dynamic email address based on the report resultsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Shlomo Elnekave 534 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
What is the Table name to fetch Comments & Attachment posted in Allocated TaskSummary I want to know the table name which stores the comments & attachments which are added by the Approver while marking a allocated task as completeContent I want to…VinodKumar 622 views 6 comments 0 points Most recent by Stephan Steup Reporting and Analytics for HCM
-
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 71 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 89 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Missing TimeCards ReportSummary Missing TimeCards ReportContent Hi Experts, Anybody developed Missing Timecards BI/OTBI Report. Could you please share the report. Thanks ThiruThiru Ch 308 views 16 comments 2 points Most recent by Venkataramana N Reporting and Analytics for HCM -
Expand Issuing comments in Document Record Notification email templateWe are currently working on expanding the comment box for document record email notifications and BPM work lists, as the current character limit does not align with the …
-
Is there any table/way to find the tables used (data set details) in BIP reportSummary: Is there any table/way to find the tables used (data set details) in BIP report Content (required): Hi Team, Greetings! Is there any table/way to find the table…Parag Hiremath 897 views 16 comments 0 points Most recent by HarshithDarla Reporting and Analytics for HCM
-
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval …
-
BI Publisher reports now timing out (previously working)Summary: I have two BIP reports that were created several years ago that are now timing out. They began failing around the beginning of September 2023. Content (required…
-
query to get current logged in user_id in BI publisher reportSummary query to get current logged in user_id in BI publisher reportContent Hi Experts, how to get current logged in user_id in BI publisher report. Thanks, PradvinPradvin Prabhakar 5.2K views 7 comments 2 points Most recent by MastekLtd Reporting and Analytics for HCM
-
How to fetch learning community access group details?Hi everyone, I have a requirement to fetch the learning community access group details like, Community Access Group Name, Community Access Group Learner Count and Commun…Prashanth Sangram-Oracle 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
What HCM table can I use to get the future Line Manager?Summary: I'm checking if I can use the BIP Bursting feature to send details which includes tasks to the worker's future LM once the transfer is approved. The client want…
-
Which tables store the Weekly Working Hours data?Summary: Which tables store the Weekly Working Hours data? Version (include the version you are using, if applicable): 23BLuke.Findex 66 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How do we find out the date a leave of absence was approved?Summary How do we find out the date a leave of absence was approved?Content We are using the 'Workforce Management - Absence Real Time' subject area and using the 'Assig…
-
Oracle BI Tables for compensation plan columnsSummary: Content (required): Hello experts, do you know which Oracle HCM BI Tables store compensation plan user-defined columns (custom numeric and text column); Compone…Valerio Curzi 25 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM