OTBI
Discussion List
-
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 239 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 284 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 21 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 82 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 167 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 29 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
REQUISITION_POSTED State Code Giving Strange Resultshttps://us.v-cdn.net/6034893/uploads/SEVJVQA956IF/u-s-req-posting-time.txt Hello, I have a need to find the most recent date a requisition was posted and unposted. For c… -
Date Range Parameter value should be defaulted to previous year in OTBI ReportHi Team/Raghavendra Raghunath-Oracle, We have created an OTBI report it's working fine. However in the Prompt parameter we wanted to default the filed values as below; S…Mahendra Y 51 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
SQL query to return the image attached to Related MaterialsSummary: Hi I need help building a SQL query to return the image attached to Related Materials. In a query we can bring the image extension, but not the image. SELECT wl…
-
Identify Hire Dates that are any date in the Next WeekSummary: I have an OTBI report using subject area Workforce Management - Work Relationship Real Time. On the Advanced tab, I have already entered the prefix SET VARIABLE…
-
Is it possible to report on what learning content is attached to learning courses?Summary: My organization needs to audit the learning content (videos, PDFs, etc.) associated with our courses and offerings. I am exploring the Workforce Learning Conten…
-
No Results custom message not updatedSummary: No Results custom message not updated. Design Sample: Parameter selected: Absence Type parameter selected = Purchase Day. No Results message expected to be prin…
-
REST API learningContentItems ContentIdSummary REST API learningContentItems ContentIdContent Hi, I want to get a report for the learning item contentid with item title. Because of contentid to use in REST ap…
-
Supplier: In which Table to find the "Use Witholding Tax" (Site Assignments) field at Site levelSummary: In which table can be found the "Use Witholding Tax" field at Site level (Site Assignment) Content (please ensure you mask any confidential information): Versio…Christian Flegler 1 view 2 comments 0 points Most recent by Christian Flegler General Ledger & Intercompany -
Completion Certificate DefaultsSummary: Is it possible to create various types of certificates so that each course has its own individualized certificate? I don't see a way for us to associate a uniqu…