BI Publisher
Discussion List
-
How can we create drill down charts in Oracle BI Publisher (BIP) ReportsSummary: I want to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables. Not sure how to achi…Neha Bhatt 181 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Does anyone know how to restrict data in BIP report based on user who will run it?Summary: How to restrict data in BIP report based on user who will run it? Content (required): Hello I am running report in BIP regarding no performance goal plan. Can y…Hazel De Castro 555 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Payroll query that fetches results only if Archive and Generate Payslips is run post Payroll runSummary: We have a requirement to fetch the run result values only if the Archive Periodic Pay results and Generate Payslips processes have been run for the person post …Pinky Mukherjee 688 views 3 comments 0 points Most recent by Pinky Mukherjee Reporting and Analytics for HCM -
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
BI Publisher reportingI primarily use OTBI for reporting and then copy the SQL from these reports if I need to create a BI Publisher report. I do this because I find it so difficult to find t…Paul Morrissey 23 views 3 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
SQL Query - List Of Email-Notification DetailsContent We have a requirement to fetch all the Email-Notification Details (Recipient Email Address, Subject, Email Body Text., ) received by an employee. We have identif…Mano Haran-61126 1.6K views 4 comments 0 points Most recent by DevasishG Reporting and Analytics for HCM -
How can we send the report or notification BI or OTBI different languages based on country or personSummary: Hi Team, I'm new to above type of requirement to convert or send the resptive languaes , how can we achive this type of scanario? Thanks, Ajay Content (please e…AjayKumar Maddipati 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 92 views 10 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Talent Pools - Succession Plan KPI reportSummary: Need to build report using below fields - either OTBI or BIP. Kindly help please. Content (please ensure you mask any confidential information): Column Name Des…Pradnya_Pampatwar 11 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
IN BI report how to restrict the usersSummary: Hi Team, how to restrict the user in BIP query. suppose i want to restict one person in query how can i restrict. Thanks, Ajay Content (please ensure you mask a…AjayKumar Maddipati 21 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you…Shubham Bindal 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BI Report: Empty report is downloaded eventhough the data is present in the view data modelSummary: Able to see the data in view data model. But in report, the data are not getting displayed and while downloading the report, Empty report is getting downloaded …SARAVANA KUMAR T-Oracle 106 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
BI Reporting on BPM SetupSummary BI Reporting on BPM SetupContent Hi Team, Hope everyone is doing great ! We have a requirement to create a report on BPM Approval setup . Is there a table that s… -
Bursting BI Publisher HTML EmailHi Experts, I have created the Bursting Definition below for testing purposes. select har.REQUEST_ID as KEY, har.RUN_ID as TEMPLATE, 'en-US' as LOCALE, 'PDF' as OUTPUT_F…Paul Worsley 52 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Is it possible to identify the user running a BIP report to use for dynamic content?Summary Shared-service users need to run letters generated for employees and the signature must be the user who is running the report. How can we identify the user?Conte… -
How to add a specific custom button to a page using Page Composer?Summary: How to add a specific custom button to a page using Page Composer? Content (please ensure you mask any confidential information): I have a custom button that li…Stefano_Mazzocca 487 views 1 comment 0 points Most recent by Vijay Shanmugam-Oracle HCM Redwood Personalization Helper Tool -
Need to fetch HOD comments in Performance managementSummary: I am trying to fetch HOD Comments in Performance task in Fusion HCM? And which table this comments will store? Generally, comments will store in HRA_EVAL_RATING…Venkatasivaiah 1 view 1 comment 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Issue while extending offerSummary: Dear All, We are trying to extend the offer for one of the candidate and getting below error: The job offer couldn't be extended. There was a problem with the j…Sayali Pawar-Oracle 682 views 6 comments 1 point Most recent by Shalini Keshri Reporting and Analytics for HCM -
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records … -
Changes reportSummary All changes for specified fields in date rangeContent Hi, Is there a report that shows all changes in period: ID Name Effective Date Old Department New Departmen…Mike Borghoff 83 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Dynamically logos of the different legal employer dynamically in BIPSummary: I am trying to display the logos of the different legal employers dynamically on my BI report. I created a SubTemplate folder where I store the logos The Sub Te…Consultant Ian 21 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Need table name to pull "payroll processing status" field from time and laborSummary Need table name to pull "payroll processing status" field from time and laborContent Hi Team, Need table name to pull "payroll processing status"(Like Processed …User_2025-02-04-07-00-18-658 78 views 3 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM -
How can I have a nested for-each group inside rtf report?Summary: How can I have a nested for-each group inside rtf report? Content (please ensure you mask any confidential information): If I add a for-each group outside anoth…Stefano_Mazzocca 62 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Order by phase in Recuiting OTBI ReportSummary: Hi everyone, I tried to sort the phase in recruiting but it doesn't work can anyone tell me why? and what is the solution to sort the phase? -
Add Pay Group using data augmentation.We are trying to bring the field of Pay Group through data augmentation. Can you guide me to select the source tables (see attached screenshot)? which PVO contains Pay G…Rodrigo Durán 41 views 7 comments 0 points Most recent by Rodrigo Durán Reporting and Analytics for HCM -
Issue with a custom notificationHi, I customized four notifications: PerformanceGoalNotificationsReport PerformanceGoalApprovalNotificationsReport PerformanceGoalRespApprovalNotificationsReport Perform… -
Which table stores bip reports scheduled history data.Summary: Which table stores bip reports scheduled history data. Content (please ensure you mask any confidential information): Hi Team, Can some one will help me to find… -
pending worker record not fetching in OTBISummary: Content (please ensure you mask any confidential information): Hello, We are creating a report to fetch the checklist task values from the configurable form fil…Aishwarya_15 65 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there any possibility to extract the emp image in JPG or PNG format from oracle through Report.If not from reports what is the possibility of extracting the image from Oracle Fusion HCM?YAMINI DANTOORI 1 view 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Standard report for Oracle journeysSummary: Standard report for journeys Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard reports delive…Oriana L. 222 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM