OTBI
Discussion List
-
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 163 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 52 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… -
Where in OTBI subject areas can I find the actual start date of an assignment?Summary When trying to find the start date of an assignment, I can only find all actions related to the assignment. How to show only the actual starting date of the assi…Matti Bugge 663 views 6 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
Repeating RowsSummary: I am creating a report that will show job requisitions, the candidates who applied along with their education and previous employment information. Due to multip…Jae.L 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Filter OTBI report using dff's effective start date and effective end dateSummary: Need to filter dff data using effective start and end date Content (please ensure you mask any confidential information): I created a analysis report which has …Taushif Anwar 121 views 10 comments 0 points Most recent by Taushif Anwar Reporting and Analytics for HCM
-
Possibility to do Gross Pay in OTBIContent I am working on a report to show gross pay and specific imputed earnings during a specific date range divided by pay dates. I am attempting this report with Orac…User_2025-02-10-19-21-48-801 135 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report for Performance Document Question ResponsesSummary Report for Performance Document Question ResponsesContent I have created a performance document with only a questionnaire section. I am trying to build an OTBI r…User_2025-01-22-19-28-29-985 235 views 21 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Looking to Create a Reports Landing Page for HR Users in OTBILooking to create a Landing Page for HR users when they land in OTBI, to allow them to see Developed Standard Reports curated by the business. Would like to have links t…Patrick Scally 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
INFORMATION_TYPE is not unique IN PER_JOB_EXTRA_INFO_F table for same job title.Summary: Integration is failing due to sql not returning data for INFORMATION_TYPE ='EIT'. In BIP report INFORMATION_TYPE is coded 'BMC Grade Details' How the INFORMATIO…Ankush_Jadhav 11 views 2 comments 0 points Most recent by Ankush_Jadhav Reporting and Analytics for HCM
-
Average salary by compensation zone (getting sum instead of average)Summary: I am trying to create a report that will show Minimum, Average and Max salary for each compensation zone (Market A,B,C,D) using Compensation - Salary Details Re…Ameya_J 41 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is it possible to find the Purchase Requisition (PR) based on projects in the approvers User accountSummary: The business wants to see the requisition and the status (Approved, rejected) based on the project filter and approver person further to see the relevant requis…
-
Missing Salary data post 24A upgradeSummary: Post 24A upgrade all OTBI reports failed to load salary data. We looked into each column added in the reports and noticed the issue is caused when there are col…Ridma Karunanathan 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Dynamic Date parameter in OTBISummary: I have a requirement to get output depending on date parameter user will provide from prompt . how can i achieve this in OTBI report Content (required): Version…Sudipta007 596 views 8 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM