OTBI
Discussion List
-
Restricting Data for Direct reports of a Line ManagerSummary: Hi All, How do we restrict Line manager access to only his/her direct reportees Learning Items in OTBI Report. Can you let me know the steps ? Content (required…Veena P 71 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Adding a number format for OTBI reportSummary: I have created an OTBI analysis to get the grade related min, max and average values. Content (please ensure you mask any confidential information): The OTBI an…Ayesha Iroshani 231 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
We have long service award OTBI Report but need to show in performance tile viewSummary: Hi team, we have long service award OTBI Report but need to show in performance tile view chart by if we click the 5 years then need to show 5 years completed c…AjayKumar Maddipati 81 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
how to update position, job and location using hdlSummary: want to change employment data using HDL Content (required): I'm new to OTBI and want to change employment data for columns like Position, Job, Location. From w… -
impact of scheduled HCM Extract and Reports during the maintenance or upgrade timeSummary: Customer has concern with scheduled BI, OTBI Reports and HCM Extract during the Maintenance window. What will happened with them. CRitika.ray-Oracle 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Phone numbers repeating instead of suppressing duplicatesSummary: Mobile phone and home phone number columns are repeating even though they are duplicates and the columns are set to repress. Content (please ensure you mask any… -
Where is the LONG URL stored for candidate source tracking?Summary: I am trying to locate the LONG URL that is captured as part of Source information mentioned in the second paragraph of this oracle help document. Does anyone kn…MarkHodges 1 view 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Labor Distribution - Reporting Attribute to Identify Labor Cost AdjustmentsIs there a reporting attribute within the "Projects - Labor Distribution Cost Analysis Real Time" subject area within OTBI that identifies when a transaction is related … -
Response ScoreSummary: Hi, Does anyone know where can I find the Response Score (if it is the correct answer - 1 or the wrong answer - 0) in OTBI? I've tried under Questionnaire Respo…Vasco 11 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Trouble with GaugesSummary: I'm trying to create a simple gauge that shows the percent balance left, but the gauge is not reflecting the correct information. Content (required): I'm using … -
What kind of transactions processed by 'Extract Assets Reporting Data program'?Summary: Could I ask what kind of transactions processed by 'Extract Assets Reporting Data program'? Content (please ensure you mask any confidential information): Could… -
Dashboard prompt is not workingSummary: Hi, I have created an analysis using logical sql and passed parameter i.e. presentation variable inside logical sql. But when I am using dashboard and dashboard…Shreya Datir 51 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM -
Dynamic generation of URL (from OTBI) to Person's Person Management in HCM ApplicationContent Hello, Just wanted to check if anyone tried to generate a dynamic URL from an OTBI analysis that can go to Person's Person Management screen at HCM Application. …SantoshKumarBhairi 241 views 33 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What is the OTBI Subject Area for State Wise Minimum Wage?Hi Team - Can anyone please let me know the OTBI subject area for State Wise Minimum Wage. The DB tables for the same are PAY_VALUE_DEFINITIONS_F and PAY_RANGE_ITEMS_F. …Ramya Rajendran 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to pull latest termination date AND/OR null term date based on Person Number & Latest AssignmentSummary: I'm using an OTBI report to pull a distinct count of # of employees at a specific location between two dates. This report includes fields like Job Name, Hire Da…CGardner01 297 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Selection Process Internal vs External - OTBISummary: Hi Expert, I have a requirement to show no application to the respective phase name and with the filter criteria month, year, and candidate Selection process na… -
Duplicate lines of data for employee in Worker Assignment Real TimeSummary: I have developed an analysis export which brings all current assignment data for an employee based on the Worker Assignment Real Time subject area. However, the…Dan_Hinsley 22 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to use 1 common filter for graph and tableSummary: Hi Experts, I created an OTBI analysis and want to add one common filter for graphs and tables. Can someone assist me with how to use all filters for both? Than… -
Report to monitor SCORMs answersHello everyone If the contents are SCORM, it is possible to produce reports (e.g. a report that highlights, for each individual question, the answer provided by the user… -
Using SOAP Web Services to Automate the Promotion of BIP and OTBI ReportsSummary: We are in the process of migrating to Oracle ERP cloud and need to determine a process/tool to automate and provide version control around BIP and OTBI report m…MD-JMS 81 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
On Hand at Requisition CreationSummary On Hand at Requisition CreationContent Hi All, There is a requirement to show On hand availability to buyer before creation of requisition order. Buyer should be…Mayank Pande 40 views 11 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
Need to edit the NewHireReport data model to include the SecurityFinal tableSummary: In the AssignmentChangeReport datamodel (EmploymentUpdateProcess), there is a table called "SecruityFinal". This table provides the following data (see below) o… -
Job Change ReportSummary: I have a Job Change report that I was sent and I need to add a few fields to it. It was built in Logical SQL and I'm having trouble adding a few fields. Any hel… -
Report who all are using Fusion Cloud applicationsSummary: Report who all are using Fusion Cloud applications Content (please ensure you mask any confidential information): Version (include the version you are using, if…SathishVellampalli 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service -
Cross Subject Area join between Checklist and Helpdesk Request SummarySummary: There are Checklists created for certain Helpdesk Service requests. We need the data from both checklist and helpdesk on an OTBI Analysis **** Dashboard. Is it …Vibha Pandey - Oracle 1 view 4 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Is there any way to check the work order start and completion date changes done on the work order .Summary: There has been many revisions that are seen in OSP Purchase order that are seen triggered automatically. To check this we want to see if there are any date chan…P.S.Nikhitha Muduliar 11 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Manufacturing -
Read only user unable to open standard dashboard report. how to get required privilege for report.Summary: We have Auditors user having read only role access and also given standard dashboard report access but report not opening. Content (required): for e.g standard …AmitD 51 views 3 comments 0 points Most recent by Lakshmi Prasanna Bandaru Payables, Payments & Cash Management