OTBI
Discussion List
-
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 22 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 85 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
-
Subledger Accounting - Journals Real TimeHi, We're experiencing an issue in an OTBI Analysis where we are unable to pull back data from any columns relating to Supplier, Purchase Orders, and Receipt Numbers at …John Aitken 11 views 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 11 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 22 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 22 views 4 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Cant use the Oracle Analytics Publisher error "menu2007.logon"Hi installed in my machine the Oracle Analytics Publisher for word, but after install showing in tab "Publisher" in login "Menu2007.logon". I used this link to download …Felipe S. Rocha 174 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
how to find source to disable autorun for an OTBI report?Customer is getting a delivery report but now they don't want to use it further, We are trying to find a way to disable the autorun of the report. FYI: We were not able …Sushant95-Oracle 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
Dashboard prompt not applying to linked analysisSummary: The Dashboard prompt for 'Name' is accurately returning the number of Employees for our 'Headcount' tile, but when navigating to the link analysis for Headcount… -
Can I use output from one BI report as input to another BI report?Summary: Content (required): I know that I can create multiple templates for my output, but that would require me to run the data model again. I'm looking for a way to p…Scott Paulin 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Compensation History tables and dataHi All, I am unable to get the Compensation History data using below query. Can you please advise if anyone has the query or table accordingly. SELECT hth.transaction_id…Sai Shyam 41 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service