Category 81
Discussion List
-
Where can I find the infolets on the purchase order pageSummary Where can I find the infolets on the purchase order pageContent Where can I find the infolets on the purchase order page, I would like to copy the infotes to cre…Leandro Vasconcelos 117 views 8 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
Cumulative totals in OTBISummary: We want to create cumulative Actual costs in OTBI. Please advise how to do this? SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Proj… -
OTBI report to display program and projects under itSummary: We are trying to prepare a report to display the program and list of projects under the program. We tried adding below two subject areas Projects - Program Perf…
-
How to fetch the manager and assignment for a userSummary: Hi Experts I'm looking to create a BIP report in Fusion cloud where I can pass the users email address and fetch the manager email address and assignment detail…
-
Payload is required for the SOAP web service - BIP scheduled job historySummary: We require the payloads of BIP scheduled job history SOAP web service. Please find the following web service details and share the appropriate payloads to get t…Lakshmana Rao Bandaru-Oracle 202 views 4 comments 0 points Most recent by Lakshmana Rao Bandaru-Oracle Reporting & Analytics for Fusion Service
-
OTBI analysis not returning results in Spanish even though it does in EnglishSummary: I built an OTBI analysis to show results of performance documents, specifically the manager ratings. I have found that the reports is not returning results when… -
TERMINATION EMPLOYEES DATA NOT FETCHING POST 2018 IN OTBI REPORTSummary: With the help of OTBI tried to create report containing Person number, Name, Job code, Job Name, Grade Code, Grade Name, Termination data and Salary Basis, wher…Kavya Veluri-Oracle 31 views 2 comments 0 points Most recent by Kavya Veluri-Oracle Reporting and Analytics for HCM
-
Prompt does not work in dashboard for different analysis using different subject areasSummary: Content (required): I have a Dashboard with the following analysis (tabs) called: 1. Requisitions (SA:Recruiting Real Time) 2. Applications (SA:Recruiting Real …Maria Xydopoulou 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Changing Fetch First 250001 Rows Only to another valueSummary: How do you change the Fetch First 250001 Rows Only to another value or remove it entirely. Content (required): I need to remove the Fetch First 250001 Rows Only…
-
OTBI subject area for health of the project detailSummary: Please provide me OTBI subject area that gives health of the project. Content (required): Version (include the version you are using, if applicable): 23A Code S…
-
Reporting Sales within HCM OTBISummary: Content (required): I have a requirement that is asking to report Sales by Organization, but also housing infomation that you would find In workforce management…Yamalia Roberts 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to get the OldValue and NewValue by using per_bipntf_utilitySummary: Unable to get the OldValue and NewValue if any change on the Employeement level by using per_bipntf_utility Content (required): We did few changes on the Emplom…
-
Layer filters?Summary: Looking to be able to layer filters. An example would be that I want to only pull department names that start with a specific sequence of numbers AND have/don't…Jessica D 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Large number value pushing out as scientific E numberSummary: I have a rtf template that must show opening balance, total invoices, total credit memos, etc and a closing balance. My amount coluns are pushing out values lik…
-
BI Admin role revokation not workingSummary: Hello Everyone, We have assigned a BI admin role to user and it worked fine. It has all the admin privileges. So far so good. We have realized that the user sho…Oracletechnofunctional 31 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Check BI role as part of standard user rolesSummary: Hello Everyone, Is there a way or query to check which user roles have enherited the BI Admin/BI auther role ? Please help. Thanks in advance. Content (required…Oracletechnofunctional 41 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Ethnicity values question in Recruiting Subject AreaSummary: Asking for assistance in understanding the difference between 2 Ethnicity fields Content (required): Hello. Can anyone advise on the difference between the 2 fi… -
OTBI - Calculate Tenure using Presentation VariableSummary: I need show Tenure calculation by subtracting the Work Relation Start Date of a person from the Date passed by the user against the presentation variable (Promp…Harpreet Shergill Oracle 102 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to pull invoice distribution lines in PayablesSummary: I am trying to pull a report of invoice posting date vs. accounting date. I also need to show all the distributions. In OTBI I am only receiving the invoice inv…MELISSA V 155 views 2 comments 0 points Most recent by MELISSA V Payables, Payments & Cash Management -
BI Publisher AverageHI, I need support to calc an average in this table rtf. I need to see in the red circle the average of 3 and 2 (the blue box). How do it? In zip I've attached rtf and x…gdegenna 11 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI analysis column content does not wrap when added to dashboardSummary: OTBI analysis column content does not wrap when added to dashboard. Content (required): Standalone OTBI wraps text but when added on dashboard text is not wrapp…Adil Muhammad 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Does oracle has any table that give us Users Signin and signout details for the past few weeksFor auditing purpose we want a report to extract the users who login and logout in the past 7 days login datetime logout datetime if any table or pre-build tables please…Chandra Thangavelu 71 views 5 comments 0 points Most recent by Chandra Thangavelu BI Publisher Learning Center
-
Unable to scroll Subject Areas with UnionSummary: When trying to use the "Combine results based on union intersection and difference operations" I'm unable to scroll past the initial list of Subject Areas to th…