OTBI
Discussion List
-
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 238 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
-
General ledger Schedule process is not visible to all usersDear All, I am writing to inform you that the scheduled process to extract general ledger data is currently not visible to all users. Anyone can give me the privilege to…George Mattar 11 views 3 comments 0 points Most recent by George Mattar General Ledger & Intercompany
-
How to hide Sealed Response InformationSummary: There is a problem with the Sealed Responses. It is possible to query Sealed Responses and their reilated information even if the negotiation is active and clos…
-
Need help to build a sql to get approval transaction historySummary: We have a requirement to capture approval transactions and the respective data like what changed in the transaction. For example If it is for Location Change,wh…Praveen D 162 views 5 comments 0 points Most recent by Hrushikesh Pentewad Reporting and Analytics for HCM
-
BI report paramters not working in DasboardSummary I attached BI report to dashboard and created date paramter in dasboard prompt with same name as BI parameter.But not getting ouputContent Hi, I attached BI repo…User_6I33I 28 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
REQUISITION_POSTED State Code Giving Strange ResultsHello, I have a need to find the most recent date a requisition was posted and unposted. For compliance purposes, we need to ensure our jobs are being posted for a minim…