OTBI
Discussion List
-
Missing column in Subject Area for ReservationsSummary: Missing column (Subinventory) in Subject Area for Reservations Content (please ensure you mask any confidential information): I am trying to create a report, ba…IdK1992 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Abdool Rahman 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Learning Management Real Time RemovalSummary: Will it be removed or not anymore? Content (required): There were news way back 21A about the removal of the Learning Management Real Time Subject Area. Is it s…
-
Report display incorrect in dashboardSummary Report output on dashboard shows fewer rows of data than expectedContent I'm having some irregularities when trying to run an OTBI Analysis embedded in a dashboa…E McDonald 54 views 9 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Index Match formular for OTBIHi all, I am after some help on a formular that works similar to an index match formula in MS Excel I'm after the Legal Employer value of Managers using the manager pers…Tina T 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ERP Report Sharing CentreSummary LocationContent Hi All, The HCM report sharing centre (https://cloudcustomerconnect.oracle.com/resources/5c46181001/summary) is a hive of activity, but the ERP o…Mark_Daynes 158 views 6 comments 2 points Most recent by DennisOliver Reporting and Analytics for ERP -
Does oracle provided any learners reporting dashboardSummary:Does oracle provided any learners reporting dashboard ? Do we have any standard dashboard on oracle learners reporting? Content (please ensure you mask any confi…
-
Which table stores the output data of the Print Receivables Transactions Email Delivery: InvoicesHi Everyone, Can anyone point me the table which stores the output of the Print Receivables Transactions ESS job especially the child ESS job - Print Receivables Transac…A Vigneshwar 477 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
In which subject area I can find Site details to create an OTBI report?I need the following fields in my OTBI report related to site to know their subscription status: 1) Oracle Fusion Site Name 2) Oracle Fusion Site Number 3) Oracle Fusion…Vishal Thakur 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Subject Area Information for Item Structure Component Details (Item Basis)Summary Subject Area Information for Item Structure Component Details (Item Basis)Content Hi All, I'm able to create item structure OTBI report using below subject areas…
-
Query that retrieve Eligibility Profile from Benefit ProgramSummary: Hello! I need some help to finish some query, and it envolve Eligibility Profiles in benefit Program. Is there a table that I can get the Eligibility Profile th…Matheus Roberto 122 views 1 comment 1 point Most recent by Monica Vijayashanker -Oracle Reporting and Analytics for HCM -
Is it possible to built an OTBI report to see the depreciation reserve balances based on cateogry?Summary: Is it possible to built an OTBI report to see the depreciation reserve balances based on cateogry. If yes, from which subject area ? Content (please ensure you …
-
Webservice or REST API to fetch Data from OTBI Seeded ReportSummary: We are in need of a Webservice or REST API to fetch data from OTBI Report Content (required): We are trying to get data from seeded OTBI Report through webservi…Neha Bhatt 81 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI Report is not giving actual Absense start date and absence date insted it is giving Date StartSummary We developed a OTBI Report to get the Absence details using the subject area Workforce Management - Absence Real Time subject area.To get the absence start date …User_2025-01-30-17-37-30-647 83 views 2 comments 0 points Most recent by Neha H Sharma Reporting and Analytics for HCM -
Discount for multiples. Not tired Based RuleSummary: The requirement indicates that if the order line requests multiples of 5 each of the product, a 10% discount is applied. Any amount that exceeds the multiples i…
-
Is it possible to hide unnecessary buttons from OTBI Dashboard?Summary Is it possible to hide unnecessary buttons from OTBI Dashboard?Content I designed an OTBI dashboard, which when I run shows OTBI Header buttons and search option…Dharmendra Shukla 79 views 10 comments 2 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Trying to pull Comments from Mid-Year Performance document into a reportSummary When Employee/Manager Comments fields are added to performance report, errors outContent I have a request to pull a report of all Goals and include the Employee …User_2025-01-28-20-43-56-568 59 views 4 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM
-
how to remove ESS Job "Create Uninvoiced Receipt Accruals" from user so that they cant runSummary: Business is not performing "Create Uninvoiced Receipt Accruals" So we want to remove this so that nobody will not run by mistake Content (please ensure you mask… -
Need access for Custom OTBI Dashboards : "Projects Control Dashboard" reportSummary: Project Role as "Project Team member" on Oracle seeded has no access for Custom OTBI Dash boards (specially "Projects Control Dashboard") . Our request is to pr…SRIRAMULA RAJKUMAR 41 views 6 comments 0 points Most recent by Sudhir Agir-Oracle Project Management
-
Is the accounting status of payments accessible in OTBI?Currently, only the accounting status of invoices appears in the criteria. Could you please specify the location column for the accounting status of payments?Anne Nicole 71 views 9 comments 0 points Most recent by Anne Nicole Payables, Payments & Cash Management -
DOR Report: How would I create a report that allows me to see DOR data by employee?I am trying to build a report that shows the following information for Document of Records, but the fields I add show no data. Would it be possible to know which fields …Jay_Brannan 112 views 11 comments 0 points Most recent by Jay_Brannan Reporting and Analytics for HCM
-
Is it possible to add candidate Hire date using OTBISummary: We have a requirement to include hire date in the report. The intention of the report is to capture all offers that are created, even if they don't end in hire.…Christina Roy 24 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
How to sum (group by) more than one column on OTBII need to create a custom column that aggregates WIP balance by both WO and Cost element. I can create sum(wip balance by wo) and sum(wip balance by cost element) but th…G.Engelmann 182 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Field to report the "Last Hire date"Summary Field to report the "Last Hire date"Content What is the field present in OTBI to report Last hire date. We are looking for the Field to populate Hire date if the…Prabhu Krishnamoorthy 340 views 3 comments 0 points Most recent by Gunjan Bobade Reporting and Analytics for HCM -
concatenate error in otbi reportSummary: CONCAT(NVL(TO_CHAR("Worker"."days"), '0'), ' Days, ', NVL(TO_CHAR("Worker"."months"), '0'), ' Months, ', NVL(TO_CHAR("Worker"."year"), '0'), ' Years') i tried t…
-
Manage Internal Supplier Profile Change ApprovalsCannot find Underlying Oracle Tables For The Setup And Maintenance Task - approval management Looking for the underlying Oracle tables for the Approval Management tasks,…NZ-user999 32 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to provide a Procurement Requester access to OTBI report creation?Summary: How to provide a Procurement Requester access to OTBI report creation? Do we create a custom role and add the BI Author role? Is there a privilege which governs…Asutosh Mishra 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for SCM
-
Global Access Groups clarification - Oracle LearningHi Experts, We have a request to create an access group for a particular course/offerings. Request is that only supervisors and managers should be able to see this cours…
-
How to get Miscellaneous Transaction Serial Numbers range if the serial numbers are consequetive?Summary: I have some report requirement to get the transaction serial numbers as: serial_from, serial_to, and range. The only source table I have is the serial number on…