OTBI
Discussion List
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 101 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting & Analytics for Fusion Service -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 91 views 1 comment 5 points Most recent by Praveen Kumar Akkala-Oracle Reporting & Analytics for Sales
-
OTBI Report - Effective Start Date UnionI am creating an OTBI report to extract Union member, Union of the employees and the date from which the employee joined the union. I am using the following subject area…Greta S 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
DFF values not appearing in OTBIHow do you get a DFF LOV results values to appear in OTBI reports and analytics? Seems as though I am able to return every value and DFF results value field into the rep…Tina T 302 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Looking for sql to find day/timestamp of employee's policy acknowledgmentI am looking for the table(s) to find the signature day/timestamp for a policy that was 'signed' during an onboarding journey. I started in PER_ALLOCATED_TASKS - is that…Wendy G 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team,Summary: Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team, unit,section, trying with following query, but i am getting …
-
Checklist LetterWe have configured a letter through checklist task and same will be store in DOR after acknowledging, employee has to generate the letter then acknowledge it then the le…Satyam Roy 21 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Changing Aggregation/Group of Column in OTBIHello, I have a Logical SQL report to combine data from the "Workforce Succession Management - Incumbent Plans Real Time" and "Workforce Succession Management - Plan Can…Nick Dorfner 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Refer HR Organization hirarchy on "Expenses - Expense Transactions Real Time"How to get HR Organization Hierarchy details on "Expenses - Expense Transactions Real Time"Eknath 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
OTBI Report not showing pictures when exported as Web ArchiveSummary: We have an OTBI report that stores images + html values. When extracted as Web Archive, first row displays image just fine, but row2 and row3 are only showing I…CAMIL_Q 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBISummary: How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBI Content (please ensure you mask any confidential information): Versio…
-
OTBI END USER are not able to see the promtSummary: I have a requisition report and I create a prompt for a Supplier Field. When I open the report in the Report and Analytics are and select the Open link the syst…Pablo Schenquerman 31 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
V3 seniority date column Mapping in OTBI Subject area??Could you please tell us anyone what is the exact column for seniority date using in the subject areas for v3 ? Workforce Management - Work Relationship Real Time Workfo…User_7A1QO 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Is there any REST API to get the details on Outbound Shipment RequestSummary: Is there any REST API to get the details on Outbound Shipment Request
-
Are there any jobs to schedule hourly/daily/weekly for OTBI?Summary: We have schedule jobs for various areas of HCM but nothing that runs hourly/daily/weekly for OTBI reporting. Are there any jobs that you can recommend to schedu…LFafard 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Asset Depreciation Report with Pivoted Accounting DateI'm trying to create an asset depreciation report in OTBI using a pivot table. My goal is to have the accounting date itself be a pivoted column (displaying depreciation…
-
how to fetch current schedule process start time of any Oracle Fusion scheduled reportSummary: I have a requirement to fetch incremental data. I am using below query. but due to frequent transaction. Few transactions are getting picked by 2 consecutive sc…Grab.saurabh 81 views 2 comments 0 points Most recent by Grab.saurabh Reporting and Analytics for ERP
-
Reports and Analytics AccessSummary: Production Supervisor Role unable to see Reports and Analytics under tools Content (please ensure you mask any confidential information): Production Supervisor …AShekhar 31 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Combining order management & Cost accounting subject area not giving data in OTBI reportSummary: How to combine order management & cost accounting subject areas in OTBI report? Content (please ensure you mask any confidential information): We have an OTBI r…Manisha Shrivastava 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE tableHi All, We have below requirement, Create and confirm shipment through REST API Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective ord…Nagaraju Vandavasi 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to create a report with full and part time EMP count as per department ?I have created a headcount report with basic employee info. I want to modify it such that it has Emp ID, Dept ID, Full time & Part Time Empl count. Basically I am lookin…Trupti Khodke 12 views 2 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM
-
Send a BIP report to PRINTERSummary: How to send a BIP Report output to PRINTER directly Delivery output should be directly sent to PRINTER Content (required): Version (include the version you are …Mudhassar 141 views 6 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for HCM
-
Report Job HistorySummary Report job history only goes back 9 months from current dateContent Hi, After a query from an end user in HR we've noticed that the report job history only seems…
-
How to add a count column for employees aligned to a job in OTBI.Summary: I have created a report in OTBI to show all job names in our business. I need to create a column which does a count on the number of employees who have this job…
-
Alert for re-enrollment in Course for oracle learning cloudSummary: When a course expires, it is necessary to activate an alert that informs the learner to either enroll in the course or provides notification that they have been…
-
How to identify which admin marked the attendance of the user in the ILT offering using the reportUsers need to identify those who have marked the attendance of the learners in the offering and when was it updated those records to get captured to track the admins' ac…
-
Assignment Manager - Performance Document ReportingHi all, We've built a report that we'd like managers to be able to run that'll return their direct and indirect reports Performance document status details. The issue we…
-
Working of CreditCheckingService SOAP WebserviceSummary: Working of CreditCheckingService SOAP Webservice Content (please ensure you mask any confidential information): Hello Team, We would like to know how the Availa…Atul_Ghd 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to find port of exit which is available on shipment table in transportation intelligenceHi, I am looking for port load or port exit date field which is available on shipment table of OTM in Transportation Intelligence analytics, but I was not able to find t…Kishore_Kumar 21 views 4 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management