OTBI
Discussion List
-
Supervisor Hierarchy (Top/Down) Managed departmentsSummary: Supervisor Hierarchy (Top/Down) spanning multiple departments Content (required): We are trying to develop an OTBI report displaying reportees spanning multiple…Manoj.Gupta 71 views 3 comments 6 points Most recent by Gloria Brewster Reporting and Analytics for HCM -
OTBI - change field from text to numberSummary Changing text format fields, which include number values, to number formatContent Hi :) I have a report which shows information on Element Entries. The input val… -
OTBI Union Report Data IssueSummary: I have created OTBI UNION Report with below subject areas and applied all mandatory filters but did not see any data in the report. 1. Subledger Accounting - Jo…FirozahamedSK 32 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Working days lostSummary: Has anyone managed to do a comparison between, a work schedule that holds a person's work patten eg Mon to Friday 9-5 and days taken as sick eg Tuesday and Wedn…
-
'The outgoing inventory transaction could not be costed because there is no layer cost for the item.Summary: For the errors with the message of 'The outgoing inventory transaction could not be costed because there is no layer cost for the item.' in 'Review Cost Account…
-
Best practice for AR Aging to TB ReconciliationSummary: Best practice for AR Aging to TB Reconciliation Content (please ensure you mask any confidential information): Currently we see huge difference between AR Aging…Ajay Hareesh 33 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
OTBI subject area for Job responsibilitiesSummary: Looking for the subject area to report on job responsibilities and weights associated. From the job profile Content (please ensure you mask any confidential inf…
-
Operating time calculation of an Asset in OrganizationSummary: We have created a Maintenance Management report that calculates the operating time ( latest meter reading - first meter reading) of assets within an organizatio… -
Age Formulas using SQLSummary Need age as of the current date and when someone will be a certain ageContent Hello, I am needing a formula to calculate age in Years that does NOT round. For ex…Rebekah Gilday 109 views 9 comments 0 points Most recent by Diane G123 Reporting and Analytics for HCM -
Will selecting Application Role within Report Agent set up secure the rows based on AORs?Summary: Hi all We want to create an agent that sends the results of an OTBI analysis to our HR Business Partner population. If I add our application role for them will …
-
Actionable Dashboard for AP Invoice Approval in Oracle Fusion CloudSummary: To approve bulk invoice all columns are not available in the worklist where the approver can view the columns and select and approve. So can we create a actiona…Jagjit Singh Arora 121 views 0 comments 0 points Started by Jagjit Singh Arora Payables, Payments & Cash Management
-
We have a requirement to fetch salary component calculation columns in OTBI and a stat graph.Summary: We have a requirement to fetch all these calculation columns in OTBI as we have partially developed the solution in BIP, but client want this in OTBI so can we …Kumar Rajgeet 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Grade MidpointSummary Joining Worker Assignment Real Time to Grade Rate Real TimeContent Hi, we're currently building reports for use in UAT ahead of upgrade to Cloud next year. I've …User_2025-02-08-05-56-00-229 18 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Grade Step DetailsContent Good Day, Within Report creation in OTBI we are trying to report on all Grade Step Levels from Grade to Step to Ceiling etc. But we are unable to find the "code"…User_2025-01-28-07-12-45-467 130 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …User_2025-01-31-00-03-33-089 305 views 25 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to get results when pulling Grade data in with Job Structure dataSummary Report fails when fields from Grade Rate Real Time are pulled inContent Using two subject areas: Workforce Profiles - Model Profile Real Time and Workforce Manag…User_2025-01-28-20-43-56-568 37 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Comparing columns from two different Analysis areas.Summary Comparing columns from two different Analysis areas.Content I am attempting to grab Job Codes for employees and the grades for the jobs. In the analysis i am usi…User_2025-02-10-19-21-48-801 36 views 14 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue with Grade Rate Real Time Subject AreaSummary Grade Rate value is not returnedContent We had a requirement to display all workers who has a current salary not equal to the current grade step rate value i.e, …Akash Kiran Jana 26 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Newly Created Supporting References not showing up in OTBI ReportSummary: I created two non-balance carrying supporting references - see steps I followed below. After creating these, I ran the following query within Reports & Analytic…Akbar Ahmed 131 views 1 comment 0 points Most recent by Akbar Ahmed Subledger Accounting & Accounting Hub
-
How to report on missing Costing of Positions?Summary: Content (please ensure you mask any confidential information): I'm trying to find a way to report on Position Costing that is missing. In the 'costing of positi…Leanne W 132 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is there a way to pull service accounts into user admin reports?Summary: Currently our existing user lists only pulls users who are employees in the system. We need to be able to pull a list of all accounts as we have service/generic…
-
Parameter definition in reportI will use the last_update_date parameter in the report I prepare. But I want to use the last_update_date column in more than one table in a single parameter. For Ex: pe…Cansel Karasoy 21 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
manager hierarchy analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Bhagyashri_Bhoge 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SCM – PRC: Finally Close POs Using Oracle Integration, 20 August 2020, 9 a.m PT - Submit QuestionsContent Submit your questions for the SCM – PRC: Finally Close POs Using Oracle Integration session to have them answered during the live event. Post your questions by p…
-
Standard template Compensation Change statements notificationContent Hello experts, I need to change the notification template the employee receive when Compensation Change Statements is available in Person Information> My Compens… -
How to use Listagg functionality in OTBI AnalysisSummary Listagg in OTBI reportsContent Hi Team, Listagg function in OBIEE reports is used to display multiple lov's in a a single row with (,)separator. How can we achie…
-
Only display the row with the earliest seniority dateSummary: Hi I'm creating a basic staff list which has seniority date on (some of our staff have protected service from a previous company) and I need to be able to show …HRJon 42 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to get latest anniversary seniorSummary: How to get the most recent date to show on an employee transaction Content (please ensure you mask any confidential information): In OTBI, using the subject 'Wo…EllieG 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to automatically trigger a scheduled job if it encounters failure on scheduled run?Summary: We have one file that was not sent to SFTP location as there is a connection issue in the SFTP as there is an emergency change in SFTP. In Oracle BI Publisher, …Cristelle Rose Sampang 81 views 3 comments 0 points Most recent by Narula Shray Reporting & Analytics for Sales