OTBI
Discussion List
-
How to create a custom Infolet using a query example?Summary: Hi, we need to create a custom infolet by a query example Content (please ensure you mask any confidential information): There is a away to create a custom info…Alex Pagliarini - Ninecon 21 views 4 comments 0 points Most recent by Alex Pagliarini - Ninecon Order Management -
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…MAHESH TALWADE 42 views 4 comments 0 points Most recent by Erica Williams Reporting and Analytics for SCM -
How can we enable visibility on OTBI Absences for a user?Summary: Hi all, We have a user who as per their profile can access Absence Records, but cannot view Absence reports in OTBI - any idea how to get round that? Any privil…Cora_Stanciu 11 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
cant show HR Representative in Otbi reportHello , I want to create a otbi report where i want to see my subordinates which is i am HR representative. I am the line manager of some employee and HR Representative …Mirza_Adeel 32 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Measuring the Completeness of Onboarding Task by EmployeeSummary: Measuring the Completeness of Onboarding Task by Employee Content (please ensure you mask any confidential information): In the Onboarding report use the Checkl…Thulasi Ram 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
We have to create an Custom field in sales order page.Summary: We need to create a custom column in Sales Order, That can be updatable at any point of time. Content (please ensure you mask any confidential information): Ver…KOTTHURI ASHOKBABU 11 views 1 comment 0 points Most recent by Sandeep Kurur-Oracle SCM Product Management-Oracle Order Management
-
Report to get the list of employees with change in payroll groupSummary: Report to get the list of employees with change in payroll group Content (required): Hi Team, Greetings! The change in payroll group, especially from weekly to …Parag Hiremath 31 views 5 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Subject area changesSummary: Advanced notice of SA Changes. Content (please ensure you mask any confidential information): Document 2431130.1 provides guidance on subject areas that can be …Ms_Oracle 31 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Returning information from the middle of the valueSummary: Hi our work location fields are in the format "UK-[city]-[street address]", but when I run an analysis I only want to return the city name. Is this possible? Is… -
Subject area joinsHello all, I am trying to create an analytic using two different subject areas. I found this; USER GUIDE: How to join data from different subject areas using union — Clo…Peter Downer 41 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Manager Name not updating in AnalysisContent Hi, I have an OTBI analysis that display incorrect information from regional and resource managers. For some reason a manager change is not coming through despit…Javier Quiñones 155 views 6 comments 1 point Most recent by Mirza_Adeel Reporting and Analytics for HCM -
Create an OTBI Analysis with information about all transactionsSummary: Hi all, I'm trying to extract information from the transactions subject area "Human Capital Management - Transaction Administration Real Time". The customer wou…teresa.marciano 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to extract BPM Approval Groups InformationHi, I cannot see any data when querying the tables below. Could it be due to the role? What could be the reason? I think it should be recorded in these tables. fa_fusion…Cansel Karasoy 21 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
User should have Inquire access for one Bu and Transactional access for other BuSummary: User should have both Inquiry and Transactional role for one business unit but they should have only inquiry access for another business unit. For example user …
-
Adding two person types into one OTBI analysisSummary: According to our current practice when employees are retiring we change their person type into "retiree" in the system. I need to create an analysis to capture …Ayesha Iroshani 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Stock Value AgingSummary: Stock Value Aging Content (please ensure you mask any confidential information): Hi, Can someone please inform me the query or tables/fields involve in calculat…
-
Advice on Printed Transaction in OTBI subject areaSummary: OTBI Receivables subject area is there a field which is a result of 'DELIVERY_METHOD_CODE' from ra_customer_trx_all data table as "Receivables - Transactions Re…Jesús Vega-Oracle 1 view 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections -
Supplier Analysis Prompt not displaying from ReportsSummary: I created Supplier ACH Verification Analysis with prompt for user to select Supplier Name prior to displaying results, however when user opens analysis from Rep…Eybrown 1 view 1 comment 0 points Most recent by Veronique Gagnon Payables, Payments & Cash Management
-
how to enable https://www.google.com/jsapi'></script> at otbiSummary: I took from sharing center report for org char it is not working because I don't know how to enable the sceipt Content (required): window.onload = function(){…Yechiel 41 views 16 comments 0 points Most recent by Charles Egegbara Reporting and Analytics for HCM
-
Supervisor Hierarchy (Top/Down) Managed departmentsSummary: Supervisor Hierarchy (Top/Down) spanning multiple departments Content (required): We are trying to develop an OTBI report displaying reportees spanning multiple…Manoj.Gupta 71 views 3 comments 6 points Most recent by Gloria Brewster Reporting and Analytics for HCM -
OTBI - change field from text to numberSummary Changing text format fields, which include number values, to number formatContent Hi :) I have a report which shows information on Element Entries. The input val…
-
OTBI Union Report Data IssueSummary: I have created OTBI UNION Report with below subject areas and applied all mandatory filters but did not see any data in the report. 1. Subledger Accounting - Jo…FirozahamedSK 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Working days lostSummary: Has anyone managed to do a comparison between, a work schedule that holds a person's work patten eg Mon to Friday 9-5 and days taken as sick eg Tuesday and Wedn…
-
'The outgoing inventory transaction could not be costed because there is no layer cost for the item.Summary: For the errors with the message of 'The outgoing inventory transaction could not be costed because there is no layer cost for the item.' in 'Review Cost Account…
-
Best practice for AR Aging to TB ReconciliationSummary: Best practice for AR Aging to TB Reconciliation Content (please ensure you mask any confidential information): Currently we see huge difference between AR Aging…Ajay Hareesh 31 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
OTBI subject area for Job responsibilitiesSummary: Looking for the subject area to report on job responsibilities and weights associated. From the job profile Content (please ensure you mask any confidential inf…
-
Operating time calculation of an Asset in OrganizationSummary: We have created a Maintenance Management report that calculates the operating time ( latest meter reading - first meter reading) of assets within an organizatio… -
Age Formulas using SQLSummary Need age as of the current date and when someone will be a certain ageContent Hello, I am needing a formula to calculate age in Years that does NOT round. For ex…Rebekah Gilday 109 views 9 comments 0 points Most recent by Diane G123 Reporting and Analytics for HCM