OTBI
Discussion List
-
Report on Role MappingsSummary: I'm looking for a way to pull all Role Mappings currently set up. Is there a delivered one I'm missing? Or, does someone have a sample to share, please? Content… -
OLC: is LIKE (pattern match) operator usageSummary How does is LIKE (pattern match) work?Content Hi, Has any one worked on the operator is LIKE (pattern match) in OTBI Analysis? If yes, can someone explain how th… -
How to Filter for Calculation Component Details in OTBISummary: Business requires a report to pull all current information on the Reporting Information Calculation Card where the Calculation Component Detail = Third-Party In… -
For impact analysis on BIP data models which meta data table is used in Fusion HCMSummary: As a part of impact analysis how can we find particular field is getting used in which BIP data models. Content (please ensure you mask any confidential informa…Siddhesh Nisal 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Report Tagged to OTBI Dashboard is taking long time and error outSummary: BIP Report is developed and tagged to OTBI Dashboard. Taking longtime more than 10 minutesand then error out Content (please ensure you mask any confidential in…Anjan Polimera 42 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
COUNT in a CASE statement for a calculated field in OTBISummary: Need to create a calculated field using COUNT and CASE statement Content (please ensure you mask any confidential information): I am using this Subject Area: Wo…Pradnya_Pampatwar 171 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to print pick splip to a printerSummary: Print Pick Slip report is ending in error while running with Printer as an output. Below are the details of error message from ESS jobs: Document delivery faile… -
How can we add multiple columns in an OTBI report for project team member rolesSummary: We are building an OTBI report using Projects subject areas. In this report we need to show project wise details of team members assigned to that project in mul… -
Query to get assessment questionnaire responses for an employee from learn moduleSummary: Query to get assessment questionnaire responses for an employee from learn module Content (please ensure you mask any confidential information): Hello, I'm tryi…Manisha Rajupeta 378 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit …Parag Hiremath 43 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card… -
Education Levels in OTBISummary: I'm not able to locate School name shown in the Education Levels section on Person Profile in OTBI. I don't see the Education Levels section under Person Profil…Gala Meyerovich 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Unable to get the data from Workforce Management - Worker Assignment Real Time in OTBISummary Unable to get the data if we include Assignment Manager, Assignment Manager (Unsecured), Assignment Manager List, or Assignment Manager List (Unsecured) foldersC…Visu 342 views 10 comments 4 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 535 views 2 comments 1 point Most recent by Yves Chanel Reporting and Analytics for ERP -
We are using Assignment Event Real Time and do not see correct Termination headcount in BI reportsSummary: We are using assignment event real time subject area and reporting annual turnover for previous 5 years. We are not seeing the correct turnover headcount when w…David Boudreau 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How do I stop my OTBI screen from going Null when the user leaves and comes backSummary: We need to keep the values in the dashboard when the user moves from tab to tab. Content (please ensure you mask any confidential information): Version (include…Larry Sherrod 1 view 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Blank lines while printing success criterion in OTBIWhen I printing success criterion in OTBI reports, it is giving blank lines before and after text of success criterion. Probably, the reason is that it is defined as HTM… -
what is the subject area that retrieve learning initiative informationSummary: Hi, I need to retrieve Learning initiative details from OTBI analysis, but I am not able to find it. Please suggest which subject are will be used. Content (req… -
Resource planning currency in budget doesn't appear in analysisI'm using a budget in two different currencies, but when I create an analysis I can't get the planned amount in the planned currency , only I get the currency code but t… -
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
Can I have a link for data lineage for 24 A versionSummary: Can I have a link for data lineage for 24 A version Content (please ensure you mask any confidential information): Version (include the version you are using, i…Prateek Dhawan 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Combine Two or more subject areasSummary: I tried to add a new subject area to my report - all I need from the below subject area is the Employees Name which is not in the first subject area for Payroll…THawkins_LGI 251 views 19 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Account Cube UpdateSummary Account Cube UpdateContent I did an update to Account Hierarchy and generate the "Publish Chart of Accounts Dimension Members and Hierarchies" not publishing Hie… -
Top Of Stack Assignment Records - in OTBISummary Top of Stack Assignment Records - in OTBIContent Hello, How do you determine the "top of stack" assignment record? That is, the assignment record that is current…Daniel McMillian 228 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Check Digits field in Payroll - Personal Payment Details Real Time subject areaSummary: The Check Digits field cannot seem to be found in the Payroll - Personal Payment Details Real Time subject area. Content (required): The Check Digits field cann…Calvin Tam 52 views 4 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Results to be displayed vertically instead of horizontallySummary: Whenever I create a new OTBI Analysis it displays horizontally Content (please ensure you mask any confidential information): How do I change this to show verti…Anna-MariaP 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 11 views 1 comment 0 points Most recent by Saurabh Poddar-Oracle Reporting & Analytics for Fusion Service