BI Publisher
Discussion List
-
Data restrictions for Oracle Fusion Middleware BI Publisher ReportsContent There are some data roles with security restrictions for report viewing. Ex : Person in Legal entity A can not view report data in Legal entity B. This data role…Ayesha Thilakarathna-51043 35 views 6 comments 0 points Most recent by Ayesha Thilakarathna-51043 Reporting and Analytics for HCM -
How to get a report for all Saved transactions by Managers? BI Report for MSS Saved TransactionsSummary How to get a report for all Saved transactions by Managers? BI Report for MSS Saved TransactionsContent Hi Experts, How to get a report for all Saved transaction…Mansur Khalil 83 views 5 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
BI Folder: limit visibility only to specific application roleContent Hi all, I'm trying to understand how to limit the access to the 'Custom' folder under Shared folders -> Custom to only 1 specific Application role. We have enabl…Daniela Spaseska-Oracle 45 views 4 comments 0 points Most recent by Alok-71409 Reporting and Analytics for HCM -
Legacy Learning Detail Report (OLC) - BI Publisher ReportSummary Legacy Learning Detail Report (Oracle Learning Cloud)Content "Employee Legacy Learning Detail Report" is a report for Learning administrators to view all the Lea…Manoj.Gupta 109 views 5 comments 4 points Most recent by Manoj.Gupta Reporting and Analytics for HCM -
Error advanced sql request using two subject areasSummary avanced sql query errorContent Hello , Attached the request I did to display competeny proficiency and target for the job profile. I have an error message . Any …User_I6AXL 34 views 4 comments 0 points Most recent by Anil Pillaresetty Reporting and Analytics for HCM -
Report on PermissionsSummary I need a report on permissions for reports and other elementsContent Hi all - is there a way to audit what reports (prompts, dashboards, etc.) have what permissi… -
User Account Details (Email Address) in Security ConsoleSummary Need table names to be able to pull email address kept in Security ConsoleContent Hi All, I am struggling to find and link tables to pull User Account Email Addr… -
BIP - Merging rows using an eText Template based on a conditionSummary The XML returned contains multiple rows for an employee, the requirement is to merge them all into one row using an eText TemplateContent Hi, We have a requireme…Brendon Charles-24581 25 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Competencies : target level and mine level in OTBISummary Competencies by target level and mine levelContent Hello, I cannot find in OTBI the mine level and target level . For example for the competency ITM_Architecture…
-
Report capturing BPM workflow configurationSummary Can we create a report to capture workflow configuration rules for validation?Content Hi All - We have almost 100 rules configured for *VariableAllocation task.I…Naveen Bitra 90 views 4 comments 1 point Most recent by Piyush Mohapatra-19632 Reporting and Analytics for HCM
-
Position Change Report templateContent Hi folks, Could anyone share any position change report template? The report captures an employee's position title changes, which occurs to Promotion/Reorganizat…
-
Standard report to capture position changes for employeesSummary Position Change ReportContent Hi folks, Is there a standard Oracle report available now to capture an employee's position title changes, which occurs to Promotio…User_J6YRM 139 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Self-Service & DashboardsSummary How do you share your reports with your users?Content Hello experts - I am hoping to find out best practices as to how you do reporting for your company (or how …Prudence K 92 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Automatic parameter binding for contextual reportsSummary How to configure R13 functionality "Application Context Passing to Embedded Reports"Content We are trying to configure the solution "Application Context Passing …Gabrielle Ungaro 50 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP Report with OTBI PromptsSummary How do I create a dashboard that uses OTBI prompts for a BIP reportContent Hi all - we are experiencing an issue since our Rel12 upgrade, where the parameters fo…Prudence K 174 views 4 comments 0 points Most recent by Neena S-82284 Reporting and Analytics for HCM
-
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 79 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
MAX formula with CONCAT calculated measureSummary Difficulty getting the formula to workContent The way our Talent Review Meeting's were created we were forced to use flexfields to store the data. So to include …Ryan Davis-43690 46 views 12 comments 0 points Most recent by Ryan Davis-43690 Reporting and Analytics for HCM
-
Is there a way to catch the No Results message with a user-friendly message?Summary Is there a way to catch the No Results message with a user-friendly message?Content A way to catch the No Results error message with a user-friendly messageI hav…
-
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 118 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 28 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 24 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 59 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 77 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 73 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 119 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 45 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