OTBI
Discussion List
-
How to integrate the analytics between Oracle Digital Assistant's skill and Oracle FusionSummary: So we have beautiful data in Oracle Digital Assistant and Oracle Fusion Service. We want to put them in the same dashboard. Content (please ensure you mask any …Calin Pavel 31 views 2 comments 0 points Most recent by Calin Pavel Reporting & Analytics for Fusion Service -
I have a report with element totals and I need to filter so it only shows the total rowSummary: I was able to get totals by month for each element. Now I need to only have the Totals row visible. Any ideas? See below. I do not want each element total to sh… -
What is the subject area and column that holds the Cash GL Accounts of Bank AccountSummary: Can you help me find the OTBI subject area column name to get the Bank GL Account? Front-end navigation: Setup and Maintenance Subject area: Financial Functiona…Earth place 22 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Print Maintenance Work Order Material List ParametersSummary: We want the Work Order To and Work Order From Field to be Mandatory or have the same value if Work Order From is left blank. Is there a way to do this? Content …
-
OTBI report not displaying seniority dates for secondary WRSummary: OTBI report designed out of delivered subject area - "Workforce Management - Person Seniority Real Time", is displaying only the primary WR seniority dates. Whe…Suchayan_Garai 162 views 25 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Salary Amount Fast Formula Compilation ErrorSummary: Fast Formula for getting Salary Amount is giving compilation error saying: the assignment uses inconsistent data types Content (please ensure you mask any confi…
-
Unable to extract learning course rating and link it to the related courseSummary: Hi, I can extract learning course rating data, by course participants, from OTBI subject area 'Workforce Learning: Learning Records Realtime' but I am unable to…Paul Morrissey 21 views 4 comments 0 points Most recent by Paul Morrissey Reporting and Analytics for HCM
-
User System Usage ReportSummary: User System Usage Report Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking to get the data for the periodic or d…Parag Hiremath 132 views 2 comments 0 points Most recent by Parag Hiremath Fusion Applications Administration -
Solutioning Data Archival for US(United States) and CA(Canada) Legislations.Summary: My Client has a requirement to archive complete fusion data and I want to understand how could we preserve anything and everything from Fusion HCM Cloud's Criti…SAHILVASYANI 41 views 5 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
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 287 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 32 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 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service