OTBI
Discussion List
-
What table holds partial time entries from the Web Clock?In summary, if a web clock entry is incomplete AND it has no time type attached, then where is that stored on the backend tables. You're welcome to read more for details…ElijahHopkin 21 views 1 comment 0 points Most recent by ASHOKKUMARFUSION-Oracle Workforce Management -
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 64 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting & Analytics for Fusion Service -
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 43 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 34 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
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 24 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
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
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…Raj_540 2 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
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
-
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 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 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-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
-
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 12 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
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 19 views 1 comment 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service
-
Learning Completion date of a course under specializationHi All, I am not able to get courses under a specialization to get its completion date. Any help is appreciated? Thanks-Praveen
-
Functions/Query in OTBI report to seperate concatenated segmentsHi, I'm trying to separate the concatenated segments into individual segments. I would like to separate 6 segments. I found a few Oracle documents which have solutions f…Varalakshmi 11 views 1 comment 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service -
Amee Patel 61 views 10 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Functional area for allocated to prepare OTBI ReportIs anyone aware of the functional area where we can find the quantity allocated.Umesh Nayak 11 views 1 comment 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service
-
Joining Two Standard Subject AreasHi team, We are joining two subject areas "Costing - Receipt Accounting Real Time" and "Costing - Landed Costs Real Time". Bu not getting data. Can anybody help me under…
-
Is any currently using NACHA File Format with more than one addenda record?I am trying to implement a NACHA CTX Format for my eText bank file using the US NACHA CCDP template. I have tried other templates as well. The closest I have come is to …Keith Doucet 32 views 0 comments 0 points Started by Keith Doucet Payables, Payments & Cash Management
-
Oracle BI Catalog ReorganizationWe are planning a reorganisation of the Oracle BI Catalog folder structures and will much appreciate knowing about any standard processes or best practices that are in p…ks1075 14 views 2 comments 1 point Most recent by Clare Murtagh - new Reporting & Analytics for Fusion Service
-
how to display latest message in reportSummary: We are building a Service Request Dashboard , in that want to display the messages also. When we combine the SR subject Area and SR Messages Subject are , it is…Anusha716 25 views 1 comment 0 points Most recent by Clare Murtagh - new Reporting & Analytics for Fusion Service
-
how to make goals dashboard embedded on the goals screen in fusion to take parameters from the goalsCustomer has created OTBI Analysis report based on the Workforce Goals - Goal Status Overview Real Time subject area. A graph has been created based on this analysis. Th…ElTawil 32 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting & Analytics for Fusion Service
-
OTBI Subject Area Security IssueSummary: For the subject area Workforce Management - Person Real Time, we have a user "Mark Eliot" who can view employee's personal information (eg: address) even though…suamanch-Oracle 1 view 1 comment 0 points Most recent by suamanch-Oracle Reporting & Analytics for Fusion Service
-
Security of custom reports to be only appear to specific rolesHello, we made custom reports with specific details which should only appeared to specific roles, For example Report A only appear to employees with roles HR Specialist …mshehab 14 views 1 comment 0 points Most recent by Saurabh Poddar-Oracle Reporting & Analytics for Fusion Service
-
OTBI Partner Resource RoleSummary: Hi, I need to create a simple report showing Partners and all the Partner Resources (First Name, Last Name) with their Resource Role. Can someone point me to th…AparajitMalliJawaharBapu 23 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
workflow notification customizationHi, We have business requirement to change the layout of Approval notification related to Global Transfer & Global Temporary assignment, The standard forms as shown belo…mshehab 14 views 1 comment 0 points Most recent by Sahil Kathuria Reporting & Analytics for Fusion Service
-
How to use phone numbers (Work phone, Mobile phone and home phone) in OTBIHi Oracle Community, The customer needs to report the Contact (Person) phone numbers (Work phone, Mobile phone and home phone) in OTBI, but these atributtes are not avai…Daniel Pérez Acevedo 95 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
Financial Reporting Web Studio Save button not saving changesThroughout Web Studio Workspace. For example, I originally had a text box in a header which contains the "" function on the first line and a "" function on the second. T…Keith Doucet 11 views 1 comment 0 points Most recent by Daniel14337-Oracle Reporting & Analytics for Fusion Service