OTBI
Discussion List
-
Budget vs. Actual Cost Comparison by Business Unit with sql errorSummary: unable to execute Budget vs. Actual Cost Comparison by Business Unit with the error Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY… -
How to use event triggers to send a reportI created a report in OTBI that returns urgent requisitions that were not processed by the buyer, but I would like to send this report to the buyer when an urgent line r…Mateus Henrique Fetzner 21 views 1 comment 0 points Most recent by Mateus Henrique Fetzner Reporting & Analytics for Fusion Service -
To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submittedSummary: To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted Content (required): We are looking SQL query/OTBI report to …
-
How to Calculate the outstanding balance based on the parameter for receivables invoice in OTBISummary: How to Calculate the outstanding balance based on the parameter for receivables invoice in OTBI Content (required): For example, if invoice is paid in October m…Harshil Tolia 273 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Display multiple emails/phones on one row when there ae multiple records of the same typeSummary Multiple emails/phones with multiple recordsContent Hi All, I have built my query for displaying employee information with their different emails and different p…User_2025-02-04-08-51-08-912 36 views 2 comments 0 points Most recent by Kuldeep Gawali Reporting and Analytics for HCM -
What are tables and views that are storing Pricing Service Mapping?Summary: i need to know which tables or views are storrring the data cerated in the manage service mappings task Content (please ensure you mask any confidential informa… -
Workforce Management - Worker Assignment Event Real Time - Assignment FTESummary: We want to achieve below requirement using OTBI. Can we get FTE and leaving reason from the same SA or need to join other SA to get the data ? Can we get Assign…Jatin_Maru_1 33 views 2 comments 0 points Most recent by Jatin_Maru_1 Reporting and Analytics for HCM -
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