BI Publisher
Discussion List
-
Payroll balance value using PAY_RUN_BALANCESContent Hi All, We have a custom payroll balance (XX_MISC_BAL) and added dimension as "Assignment Tax Unit Year to Date" and "Relationship NoCB Year to Date" as on 01-Ja… -
How to adjust default selection in Line manager dashboardSummary Change default selection in Line manager dashboardContent In the Line Manager Dashboard by default one BU is marked. I want to change this to 'All'. I have copie…Wouter.Schaap 77 views 3 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
Display on a radar graph 2 times the same gradeSummary Display same grade on the radar graphContent Dears, In the absence of the radar graph for the competencies , I am developing on BI a "home made" version. In some…User_2025-01-30-22-29-59-990 52 views 1 comment 3 points Most recent by User_2025-01-30-22-29-59-990 Reporting and Analytics for HCM -
Conditional Formatting in a BIP GraphSummary Conditional Formatting in a GraphContent Hi I have the requirement of conditional formatting to graphs in a Report, e.g., if the amount outstanding is less than …Misael Gutiérrez-Oracle 52 views 4 comments 0 points Most recent by Misael Gutiérrez-Oracle Reporting and Analytics for HCM -
Need to schedule multiple BIP reports at onceSummary Need to schedule multiple BIP reports at onceContent Hi, I need to know if we can create sort of a job to combine all the BIP reports so that they can be schedul…User_2025-01-31-02-27-22-166 77 views 8 comments 1 point Most recent by User_2025-01-31-02-27-22-166 Reporting and Analytics for HCM
-
SUCCESSION PLAN CANDIDATE READINESSSummary SUCCESSION PLAN CANDIDATE READINESS column detailsContent Hello Everyone, How to find current active record for the succession plan candidate readiness, as per o…VarunG 80 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BI Publisher - Default ViewContent Hello, Whenever I create BIP report with supporting data model, report always runs in PDF view/format. How can I enforce Interactive view as a default view? Rega… -
How do you report in OBI on workers who have not created any goals?Summary Cannot work out how to bring back colleagues who have not even created a goalContent Hello everyone, One of our business requirements is to be able to report on …User_2025-02-04-13-09-16-898 67 views 2 comments 0 points Most recent by User_2025-02-04-13-09-16-898 Reporting and Analytics for HCM
-
Query to get non person account detailsSummary Query to get non person account detailsContent Using the below query to get the non person account details but for few users the first name, lastname and email a…SuryaMuralidharan 89 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
-
Report with two different As-Of-Dates to calculate Delta variationsSummary We need to pull two lines for employees, one referring to CURRENT_DATE and the other to the previous monthContent Hi All, we do need to calculate, for Payroll pr…User_2025-01-31-00-30-34-540 35 views 4 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Agent mail trigger issueContent Hi, I have created a agent. In 'Delivery Content' tab I have given content as 'Briefing Book' with PDF format , and also configured mail ids in Recipients' tab, …
-
Issues with BIP reportSummary Issues with BIP reportContent Hi, I have following issues with my BIP report: 1. How to fetch country name from a country code ? I need to print country name in …User_2025-01-31-02-27-22-166 59 views 4 comments 0 points Most recent by Ashish Shrivastava-Oracle Reporting and Analytics for HCM
-
Need Subject area to get the Person Identifier number for external applicationsSummary Need Subject area to get the Person Identifier number for external applicationsContent Hi Team, Does any one have an idea on which subject area to use for gettin…User_2025-02-04-07-00-18-658 170 views 2 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
Global Transfer ReportingContent Hi all - we have come across an issue for reporting that we need your expertise on. Recently, we found that a Global Transfer action-action reason can be correct… -
Agent Deletion errorContent Hi I am getting below error while deleting the agent , please assist on this. ThanksUser_7836 22 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI Does Not Produce ResultsContent Hi All, I am just running a simple query to get the list of all employees. It's only showing my name, plus as soon as I one more column it does not produce any r…Neha_Takkar 50 views 5 comments 2 points Most recent by Ivy__Valverde Reporting and Analytics for HCM -
Audit report for user roles in HCMSummary Audit report for user roles in HCMContent Hi When I tried to pull the User roles report form the delivered LDAP report it is displaying roles which are currently…User_2025-02-01-08-16-14-343 212 views 3 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
19B caused a number of BIP reports to now fail - HY000Content Hello, Following our upgrade to 19B at the weekend a number of custom reports are now no longer working that we had built. I wonder if any reporting experts woul… -
Entitiy Model/relationship diagram for HCM CloudContent Please could someone point us to the entity model / entity relationship diagram for the Bi reporting tables for HCM Cloud ThanksRebecca Smith-27468 85 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL QueSummary Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL Query Data Set and other as Static Excel Spreadsheet)Content Hi …AshishERPCloud 183 views 15 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM -
Time card transferred to Payroll with success and failureContent Hi All, I am working on a report to get details of 1. Timecards transferred to Payoll. 2. Time cards not transferred to Payroll due to error and 3. Time card exc…Vibha Pandey - Oracle 77 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Unable to identify manage element screen under settlement date column in element entry tableSummary Unable to identify manage element screen under settlement date column in element entry tableContent Attached application screen shot from Manage element entry an…
-
Query to get active and active uses in the systemSummary Query to get active and active uses in the systemContent Query to get active and active uses in the system.We have Crosse verified the per_users table but didt g…Koteswararao Yenikepalli 83 views 3 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Query/Table to view BPM commentsSummary Query/Table to view BPM commentsContent Hello All, We have requirement to capture the Approver comments in a report. Let us know if you are aware of table/query … -
How to link Data Sets belonging to different Data Sources in Oracle BI Publisher in HCM CloudSummary Approach to link data sets created from WebServive and SQL Query Data SourcesContent Hi All, We have a requirement to build reports on data from external data so…Kalyan Amaravathi 53 views 3 comments 0 points Most recent by Ashish Shrivastava-Oracle Reporting and Analytics for HCM
-
HCM - Business Intelligence: Using OTBI Hierarchies -- September 14, 2017, 9 a.m. PT - Submit QuestiContent Submit your questions for the HCM - Business Intelligence: Using OTBI Hierarchies session to have them answered during the live event. Post your questions by pos…Gail Langendorf-Oracle 104 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Delivered Analytics on Pay Equity InformationContent Hello again customer connect community! I'm looking for information regarding delivered analytics in cloud HCM OTBI or your experiences reporting on pay equity. …User_2025-01-22-19-43-38-766 50 views 8 comments 0 points Most recent by Lauren Owen Reporting and Analytics for HCM
-
BI Publisher GUI Outer Join QueryContent Hi, We have created a query which is comprised of 3 data sets.They are joined by the elements within the data models. Background: We used to have this pending ap…User_KOLMZ 43 views 3 comments 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
Manager Assignment vs Worker Assignment in OTBISummary Manager Assignment StatusContent Hi Team, I know there are a few Manager's information fields available in OTBI but I could not find Manager Assignment Status, f…Alvaro Couto 72 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Prompt Search Edit functionality for BIP reportsSummary How to achieve the prompt search edit functionality for BIP reports similar to one available in Analysis ReportsContent How to achieve the prompt search edit fun…