BI Publisher
Discussion List
-
calcul division , result wrong OTBISummary result of Division of sum (measure ) /sum(measure ) is not goodContent Hello , I want to calculate the percentage of headcount by competency So I have the number…User_I6AXL 32 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…Brenda Jacks-49721 116 views 4 comments 0 points Most recent by Brenda Jacks-49721 Reporting and Analytics for HCM -
Cloud HCM cannot enable writeback,,,Summary Unable to understand how to write back dataContent Hi All, I am attempting to write back to a dff that i created but have been unsuccessful so far. In OTBI the o…Nicolas Trojack-24006 29 views 8 comments 1 point Most recent by Anil Pillaresetty Reporting and Analytics for HCM -
High number of columnsSummary High number of columns in BIP reportContent Hello everyone, Could you please give some tips on what is the best layout output option in BIP for a report that has…Alvaro Couto 25 views 13 comments 0 points Most recent by Nikhil Nelluri-71478 Reporting and Analytics for HCM -
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …Pamela Batts-Brown 54 views 6 comments 1 point Most recent by Nikhil Nelluri-71478 Reporting and Analytics for HCM
-
Duplicate Rows; Multiple lines of dataSummary My report is spitting out multiple lines of the same data; trying to find a way to consolidateContent I'm building a report that will serve as a validation/audit…Alexis Arnold 81 views 8 comments 0 points Most recent by Alexis Arnold Reporting and Analytics for HCM
-
HCM Extract Bursting PrioritySummary How to set bursting priority in BI Bursting or HCM extract delivery optionContent One of our integration partner requires trigger file (empty file with same file…Saravanan Thirunavukkarasu-26616 49 views 3 comments 0 points Most recent by DIVIAMARENDRA1201 Reporting and Analytics for HCM
-
Job Function NameSummary Need Function Name in BI Publisher reportContent Hello, I am building a BI Publisher report and need to pull in the Job Function Name I found the JOB_FUNCTION_CO…Shawn McDonald 74 views 3 comments 2 points Most recent by Shawn McDonald Reporting and Analytics for HCM -
Absence Accrual Plans for EmployeesSummary Need query table/analysisContent One of our states where our employees are located has ruled to provide hourly employees with sick pay of 40 hours per year after…Frank Wheatley 118 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Department tree versions issueContent Hi , Department tree having 2 versions , both are active , old version is end dated 31/12/2016 and new version is starts from 1/1/17. In new version existing dep…
-
How to Obtain "People Group" Field through BI PublisherSummary How to obtain "People Group" field through BI PublisherContent Hello All, I am unable to obtain "People Group" and "Legal Employer Name" fields through querying …Aahiri Sarma 46 views 7 comments 0 points Most recent by Aahiri Sarma Reporting and Analytics for HCM
-
Table name to find the approved date and approve by columnSummary Table name to find the approved date and approve by columnContent Hi, I have a requirement to create a report with approved date and approved by column. My custo…Nirmal Kumar L 38 views 3 comments 1 point Most recent by Surlina Yin-Oracle Reporting and Analytics for HCM
-
Locate setup/configuration tables in reporting/analytics toolSummary Locate setup/configuration tables in reporting/analytics toolContent We are discussing where set up tables can be located in the Reporting tool. For example, we … -
Weight updated from PerformanceSummary table of weight updated by PMContent Hi, I need to export the weight field about a goals that you can define from Performance Section. Could you please help me? …Alessandro Sepali 33 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogSummary Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogContent We have developed some analytics and dashboards and the cl…Sricharan Monigari 90 views 11 comments 0 points Most recent by Lynda Huebsch-Oracle Reporting and Analytics for HCM -
Cross Subject Area Dashboard OptionSummary Need to join multiple subject area for dashboard purposesContent Hi, I apologize in advance if this is already discussed in some previous thread- if that is the …Kuldip Khatri 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the …User_I6AXL 20 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
User Audit RolesSummary Can we report on roles removed?Content Hi all - I have seen multiple postings about how to report on what a user has for roles, but those are current roles. Is i…Prudence K 98 views 5 comments 0 points Most recent by Surlina Yin-Oracle Reporting and Analytics for HCM -
Error on InfoletsSummary I've created two simple infolets for employees to see HC and FTEContent I've created two simple infolets for employees to see HC and FTE - but when then go to th…Peter Johnson-61682 68 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report off of Attachments Within Performance ModuleSummary Managers and employees can add attachements to their performance form. I need to know who has an attachment.Content Our managers can use the attachment field at …Margaret Harvey 54 views 6 comments 0 points Most recent by Margaret Harvey Reporting and Analytics for HCM -
Possiblity of creating a Report which has a combination of data column from two different source oneSummary Possiblity of creating a Report which has a combination of data column from two different source one SQL and other static data (say excel Spreadhseet, XML, CSV..…AshishERPCloud 56 views 3 comments 0 points Most recent by Atish Chandra Supakar Reporting and Analytics for HCM -
What job role gives access to Human Capital Management – Approval Notification Archival Real Time suSummary What job role gives access to Human Capital Management – Approval Notification Archival Real Time subject area ?Content What job role gives access to Human Capit…Ruzwan Akram 51 views 2 comments 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Fusion Field - OTBI Subject / Folder MatrixContent Afternoon all, Is there a master matrix anywhere that lists fields in Fusion and cross-references them to their location subject area / folder / sub folder in OT…Evan Jenkins 99 views 2 comments 1 point Most recent by Evan Jenkins Reporting and Analytics for HCM -
Format of Dates in Excel export shows date and timeSummary Excel Export shows date and time, skewing hire dates within reportContent I have an issue where when I export an analysis to Excel, when I look at the cell conte… -
Valid Job Grade reportingSummary We are trying to determine if we have muliple Valid Grades for Job CodesContent We found some Job Codes with multiple Valid Grades and I am having difficulty wri…Shawn McDonald 97 views 5 comments 2 points Most recent by Nitin.Goswami Reporting and Analytics for HCM
-
TRU detail of an EmployeeSummary TRU detail of an EmployeeContent Hi While developing a report I have a road block to find Tax Reporting Unit detail of an employee. Can anyone please provide tab…Ravindra M-45036 79 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Changes only data in BI ReportsContent Please consider the following scenario: The Department of an employee is updated from 'Department A' to 'Department B' on 15th December 2017. The report is run o…Amrit 42 views 9 comments 0 points Most recent by Puja Bharati-27866 Reporting and Analytics for HCM -
Report on Comments from Performance FormsSummary I'd like to report on the manager and employee comments from a performance docContent Managers and employees are asked to provide a rating and comment on each co…Margaret Harvey 130 views 2 comments 1 point Most recent by Margaret Harvey Reporting and Analytics for HCM
-
Table for getting the Scheduled HCM Extracts listSummary Need table names for getting the scheduled payroll flows listContent Hi All, I have a requirement to generate BIP report with all the scheduled payroll flows and…Sricharan Monigari 59 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat…