Category 81
Discussion List
-
I'm trying to use the concat function in ether OTBI or BI to combine 4 fields.Summary: I have tried using the pipe method (||), the nested method and the case/when. and still can not get this to work. I am trying to to combine cost center informat…RJ Blankenship 321 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
"Job Requisition - Posting Structure"."Job Function" and "Current Phase" ProblemSummary: Content (required): Hello Guys, We would report if we create a simple analysis from "Recruiting - Recruiting Real Time" subject area we lost a lot of data than …Giuseppe Iacono 11 views 5 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Need to add different images of signatories in the rtf template for a BIP reportSummary: Content (required): I want to add signature's image to the letter which is in rtf template where path of the image is an XML element. As far as i researched im … -
BI Publisher Integration with Google CalendarSummary: Can we integrate BI Publisher with Google Calendar (i.e.) To make a web service call from BI to Google Calendar API and create and update events. Please share i…Srikanth_M 11 views 1 comment 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
How do I retain drill-down reporting with a null value in a data setSummary: Hello. I have a dashboard which has several pies on it that draw data from talent review categories. I need to enable drill-down person reports from the pies fo…User_2025-02-05-22-55-58-511 31 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 Reporting and Analytics for HCM -
(QUERY) Fix null value isn't show in csv outputSummary: When export as xls or view online it show header with all of null value, but header is disappear in csv output Content (required): Hi, I wanted to fix the data … -
Turnover Report Filtering 0-2 year TenureSummary: We have a requirement for a report that would have a rolling 3 year calendar that shows the headcount/termination counts for employees that are 0-2 years during…Rob Stahly 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Record Identifier In GL InformationSummary Record Identifier In GL InformationContent Is there any additional info resubject area apart from this note. Record Identifier In GL Information under Manager De…CraigX 70 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, …Remi Grégoire-Jacques 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
OTBI report for ChecklistSummary: OTBI report for Checklist Content (required): Tring to create OTBI report for Checklist for a questionnaire, however, the questions are not reflected nor the re…
-
Missing columnsSummary: Not appearing columns heading when records are exported. Content (required): We have created query to export data which has been generated in xml. However, when…
-
How to Restrict Custom BIP Report Business Unit Wise without using Secured Table ViewSummary: How to Restrict Custom BIP Report Business Unit Wise without using Secured Table View Content (required): How to Restrict Custom BIP Report Business Unit Wise w…Ghanshyam M-Oracle 131 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
The BIP Catalog page search box is inoperable.Summary: I've been looking into it for a long time, but I've never figured out why the BIP catalog page search box doesn't work. I tried the same thing in multiple insta…User_2025-10-24-00-15-43-324 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report requiredSummary: GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report required Content (required): Business wants seeded report/query to show GRN has … -
Analysis from Compensation - Salary details real time returns double the annual salarySummary: While creating analysis from Compensation - Salary details real time, the report returns double the amount of the annual salary for few employees. Have anyone e…Hem 41 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Extract Draft Status on ECO for a Report in OTBISummary: Business needs the ability to see what Change Orders have a Status in Draft to better understand metrics. Per SR 3-28465964691 this is not something Oracle OTBI… -
Need to print sum of Position FTEs by Business Units in OTBISummary:We have a requirement in OTBI to fetch business unit name and Position FTEs. But we have to print the sum of FTEs grouping it by each business unit. We are using…Sovan Mishra-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Attendance Summary ReportSummary: Does anyone have a report where you can see a summary of absences by plan type for an employee? Would like to audit and keep track of usage against balances. Al…Tristan Aquino 41 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Custom Balance ReportHi We have a requirement to display custom balance details in the report along with some other employee/payroll details , so I would like know whether to go with BIP or …
-
Database mapping documentsSummary: We've recently moved to 21D but the latest database mapping document we have is REL13_21_C_HCM_OTBI_Database_Mapping_with_ViewObjects can anyone point me in the…User_A80ZS 41 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to search for text string across all BI componentsSummary: Content (required): I need to find all BI data models and report templates referring to specific attributes. Has anyone tried to do this, or have an idea how we…Scott Paulin 41 views 11 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
Sum Parts of a ColumnSummary: We have a table with the %age of absence per absence name however on the pie chart, I need to sum the ones that are at the lower end of the spectrum. Content (r…Dawn Cawston - CPS 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BOM Cost Report for Average costingSummary: Customer is requesting for a BOM Cost report. But the available one in OTBI is applicable for Standard Costing (as Scenario information is required as parameter…
-
Custom Recruiting Dashboard To Provide Global and Restricted View of InformationSummary: My customer have requested a Recruiting dashboard with a summary page with target stats on the recruiting process (time taken to move from one phase to another,…Thaddeus Inekuku 22 views 2 comments 0 points Most recent by Thaddeus Inekuku Reporting and Analytics for HCM
-
Creating a report to show how much time learners have spent learningSummary Is it possible to create a report that shows how long each learner has spent learning?Content Hi everyone, I hope you are well. I am currently trying to build a …
-
Create a report to show both accrual values for an employee and absence value for an employeeSummary: I want to create a report, that shows how much holiday an employee has left on their balance, and in the same report show how many days of absence an employee h…Nicolas Vahman 11 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM