OTBI
Discussion List
-
Can we report on users with no work schedule using OTBI analysis?Summary: Users with no work schedule not showing on OTBI analysis of work schedules by user. Content (please ensure you mask any confidential information): I have an OTB… -
Date Calculation formulaHi, I've a requirement where I have to show some data based on future dates and also print dates like First Calendar Date of Next Month, Last Calendar Date of Next to Ne…Ninja 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Track changes to Primary National Identifier (social)Summary: Track changes to social (Primary National Identifier) Content (required): Have a requirement to identify changes (within the last 30 days) to a person's Primary… -
How to fix the incorrect sorting of Purchasing documents?Summary: When going to manage agreements, our clients like to do a massive search of all of their agreements. Upon doing so, they like to sort the agreement numbers asce…
-
xmlpserver: RTF Template for quick action Change AssignmentWe were able to locate RTF templates for Person Management changes on the xmlpserver, but we were unable to locate quick actions like Change Assignment RTF templates. Th…Ashok Kumar Sharma 11 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
Quick Action Employment Start DatesSummary: Report to identify details when Quick Action Employment Start Dates is used Content (required): Need a report that shows when a Hire Date is changed when using …JHaden3 41 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get previous experience of employee plus current company experience in OTBI or BISummary: Hi Team, we have requirement to get the previous experience of employee in OTBI is possible. In BI , we used (ff_user_column_instances_f fucif.value as experien…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Is there a way to report on the 'Work Category' field on the Timecard?Summary: I am trying to report on the 'Work Category' field from the Timecard but I can't find it in any of the subject areas relating to Timecards Content (required): I…Debbie Kilgallon 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Error while using Evaluate functionSummary: Error while using Evaluate function in OTBI. Content (please ensure you mask any confidential information): Hi, I'm getting error if I use the Evaluate function… -
Issues in syncronization of Columns in OTBI analysisSummary: Hello, I was trying to make a simple analysis with one subject area for which I added my Business Unit column and then added my Bank Account name in another. Th… -
OTBI Unit Transfers ColumnSummary: OTBI Columns to correctly display current unit assignment Content (required): We're looking for a column or columns in the Fixed Asset Subject Area "Asset Trans… -
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report? -
Unable to fetch the Session User\Logged in User RankSummary: Hi Team, We are trying to build an OTBI report to fetch the Person Number, Display Name, Max Expected Effort, and RANK. When I'm fetching all employee details w… -
Showing assignments without data entries?Summary: Using subject areas to create an analysis, we have issue showing assignments without data entries. Content (required): We are creating a number of analyses usin…Matti Bugge 51 views 22 comments 0 points Most recent by Matti Bugge Reporting and Analytics for HCM -
Seeded Roles allowing to open Workforce Compensation Budgets seeded reportSummary: Content (please ensure you mask any confidential information): Hello experts, I cannot successfully open the seeded dashboard in screen (screen 1). The user has…Valerio Curzi 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Where are calculated measures housed in the catalog for OTBI ?I've created measures for different reports (not sure which ones), but want to re-use them. Where can I locate them in the catalog? -
How to create BI analysis for Sales Product and Product GroupsSummary: How to create BI analysis for Sales Product and Product Groups Content (required): Hi, We want to create a couple of analysis to show a list of product groups a…Max Prestes 31 views 2 comments 0 points Most recent by jiweiss-Oracle Reporting & Analytics for Sales -
Is There Way to Join Subledger to Payables Invoices via Query?Summary: Is there a way to join Payables Invoices - Transactions Real Time to Subledger Accounting - Journals Real Time via a SQL query? Content (please ensure you mask …hannah_barry 171 views 0 comments 0 points Started by hannah_barry Payables, Payments & Cash Management -
Scheduling OTBI report with a conditionSummary: I'd like to be able to schedule an OTBI report but restrict the data that is sent to the recipient using a condition. Content (required): Our OTBI employee stru… -
Line Managers reporting on terminated workersSummary This post provides customers a work around in OTBI to report on the terminated workers when logged in as a line manager.Content The attached document provides a …Raghavendra Raghunath-Oracle 996 views 10 comments 12 points Most recent by Sonia Canumay Reporting and Analytics for HCM -
How to fetch actual score and mastery score of the learner for assessment which has been completedSummary: How to fetch the actual score and mastery score of the learner in OTBI report. Content (required): Version (include the version you are using, if applicable): C… -
Aggregate all notifications from Oracle HCM Cloud into single daily email/ report.Hi all, We have a requirement in which we are looking for a way to a aggregate all notifications from Oracle HCM Cloud into a single daily email or a report, sort of lik…Ioannis Adamou 61 views 2 comments 2 points Most recent by Ioannis Adamou Reporting and Analytics for HCM