OTBI
Discussion List
-
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
-
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 171 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
-
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…
-
Information about Report and its linked data modelSummary: looking for any table or Subject area where we can get information about Report and its linked Data model. to ensure that every report linked with report after …Amit_Ekbote 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Dashboard Filter in IST but results in ESTI have a dashboard filter that is run off IST time. Is there a way to modify the time zone in the dashboard filter? For Example: When entering a date range of 5/29/23 to…
-
Incomplete information in the dashboard Customer Listing ReportSummary: Site Purpose Source Reference field does not always display record information Content (please ensure you mask any confidential information): In the dashboard C…SERGIO BARRETO 11 views 0 comments 1 point Started by SERGIO BARRETO Reporting and Analytics for ERP -
Changes or new journals not reflecting immediately in OTBI reportWe have OTBI GL drill down report built on General Ledger - Journals Real Time subject area. But any new journals are not reflecting in this report immediately. How we c…Narasimha Raju 21 views 4 comments 0 points Most recent by Narasimha Raju General Ledger & Intercompany
-
how can I create a aging OTBI report of negotiation by status.Summary: how can I create a aging OTBI report of negotiation by status. the columns i expected is status, count, days count (rage created date ie,0-5 days, 5-10 days). C…
-
How to Create Planned Order Report from Supply Planning DetailsSummary: Currently, user will go to supply planning screen and export planned order details manually to get the report. We need help for query to write this report and s…AISYAH ATHIRAH 95 views 2 comments 0 points Most recent by AISYAH ATHIRAH Supply Chain Planning and Collaboration
-
How to add Batch quanity in Work DefinitionHi, We have more than 3000 work definitions in our application. means that for each and every work definition, we must add the batch quantity. is there any methods or sp…
-
Need column mapping of With this note in learning assignment in OTBI Subject areaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…