BI Publisher
Discussion List
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th… -
Need help on Payroll Pension Summary BI reportSummary: These are the columns that I am not able to find the exact table name from Oracle fusion Plan Annual Pension Pension Date Pension Year % Vested Fiscal YTD Conte…Deepak Bhatt 22 views 1 comment 0 points Most recent by Asmita Barman Reporting and Analytics for HCM -
Query to extract employee grade ladder in the assignment pageSummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query to retrieve the employee current grade ladder. Howeve…Valerio Curzi 396 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, I got to know that its… -
Disable and Migrating BI Publisher JobsGood Day, For OTBI Agents, we can set it to disable if we do not want it to run. How about for BI Publisher Jobs? Is there a way to disable it? I cannot find any option …
-
OTBI agent monitoringSummary: We have scheduled OTBI agents, We cannot able to find a way to monitor the agent status - whether its active? - Whether its still running? - how long its runnin…Prabhu Krishnamoorthy 125 views 7 comments 5 points Most recent by Louis K.Emezina Reporting and Analytics for HCM -
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 85 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
report about changes the employee has madeSummary: Content (required): Good morning, Is it possible to have a report about changes the employee has made to Personal details, Additional personal details, and Bank…
-
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Cherry Carpo 22 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Is it possible get a output in text format from bip report oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 150 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee detailsSummary: We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flo…
-
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d…
-
offer approval notification template to include Requistion Approval History, Candidate CV etc.Summary: We have requirement to Include Links to Requisition Approval History, Candidate CV and Interview Feedback within the Offer Approval Notification template. Is it…
-
BI Publisher Report Auto Run - Open Report from home page instead opening from BISummary BI Publisher Report Auto Run - Open Report from home page instead opening from BIContent Hi Experts I have created a BI Publisher Report. i have taken the url of…Mansur Khalil 157 views 17 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM -
Query functions only if "Connect By Prior" added"SELECT DISTINCT hrao.effective_end_date effective_end_date1, hov_inner.status status1, hov_inner.organization_id org_id FROM per_dept_tree_node_v pdt, hr_all_organizati…C R Anil 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): …AjayKumar Maddipati 93 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Data Archival & retention for HCM CloudSummary Data Archival & retention for HCM CloudContent we wanted to know you what would be recommended best strategy for Data Archival & retention for HCM Cloud & do we …Ranveer.Tiwari-Oracle 56 views 3 comments 3 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM -
In OTBI, when I am using Subject Area, how can I generate XML for the dataI am trying to generate the report using OTBI for a particular subject area. What I want is that I should be able to generate XML of the data so that I can use this in B…
-
BI reports Permission Related QuerySummary "Application Roles" and "Users" : Is it AND or OR?Content Hi, We have a query related to permissions given to BI reports. When you navigate the BI reports folder…User_MC37Q 79 views 2 comments 0 points Most recent by Lakshmi Bai-112908 Reporting and Analytics for HCM -
How to bursting the BIP report and where we use the bursting conceptSummary: Hi Team, I'm still send the reports through schedule job only but we have butsting concept in BIP reports how can we send through bursting and where we can use …AjayKumar Maddipati 104 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
CreateException:Index 6 out of bounds for length 6 in BIP reportsSummary: CreateException:Index 6 out of bounds for length 6 when I add 7th RTF template to the report I am getting below error and I am not able to delete extract RTF an…Gorla Shiva 79 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Workflow Transactions/Transaction Console Reporting (Rel 13)Content Hello, Just checking if anyone managed to create any Transaction Console related reports out of these two subject areas: 1) Human Capital Management - Transactio…SantoshKumarBhairi 860 views 11 comments 4 points Most recent by Samarpan Reporting and Analytics for HCM -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 536 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
To optimize Run Deduction Report, converted to BIP report.Facing issue displaying Ded and Arrear colSummary: Payroll Run Deduction Report which Prior to 24A run times averaged about 30-minutes. Following 24A, run times increased to approximately 90-minutes. Proposed a …Bindu Janoti-Oracle 57 views 2 comments 0 points Most recent by User_3MHU1 Reporting and Analytics for HCM -
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 176 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 553 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 675 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 24 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 21 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