OTBI
Discussion List
-
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 24 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 83 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 2 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 12 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 27 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
-
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 12 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
-
How to join 2 different tables using query builderHi Oracle Community, I m new SQL and took help of query builder to select few columns from payroll tables and would like to join with HR tables. The next few columns I, …
-
BIP report parameter is not working as expectedSummary: Hi All, For BIP report parameters, I have used the below part and it is not working as expected. When a period, CO, and Account parameter is given that time it …AKV27 11 views 1 comment 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service
-
drill down financial reporting and otbiSummary: drill down financial reporting and otbi Content (please ensure you mask any confidential information): is it possibile drill down in accounting hub for financia…
-
We are trying to extract month from a date column in OTBI after we convert it to Mountain Time.Summary: We are trying to extract month from a date column in an OTBI report after we convert it to Mountain Time. However we get the month from UTC only.Any suggestions…
-
How To Print Sales order Line Text Attachments into BIP reportSummary: We have requirement of "Print Sales order Line Text Attachments into BIP report", Please note: We have the same requirement for PO line text attachment which is…
-
Can we add GBPA number as a link in a BI report?Summary: We have a BI report to extract details related to Purchase Agreements. Can we have the Purchase Agreement number as a link in th report , clicking on which woul…