OTBI
Discussion List
-
Hide "Create Bookmark Link" LinkSummary: Dears we are trying to hide the link highlighted in screenshot attached but we dont understand how. OTBI is available to users within a dashboard, we already ch… -
Using OTBI to fetch latest ACTIVE assignmentWe would like to use a filter which we can re-use to fetch the latest active assignment for a person. For 99% of our population, it works to do MAX("Worker"."Assignment … -
Physical Inventory Adjustment ReportHello, Has anyone created a Physical Inventory Adjustment report for Oracle Fusion? We're on version 23A. Any guidance on the query would be appreciated. Thank you, Julia -
Total Actual Effort in Learning by DepartmentSummary: I am trying to write an OTBI analysis where we are able to pull in the total headcount of a department, the total actual effort hours of learning for that depar…KatieH 132 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
VRM_CUSTOMER_CONTRACT_AUDIT Table storing information against each contract createdSummary: We are looking for the information on VRM_CUSTOMER_CONTRACT_AUDIT Business team is mainly looking for a Contract Audit report to show clearly what all changes h…
-
User is not able to run Customer report in OTBI report,Summary: Users is not able to run Customer report in OTBI report, could anyone please let me know which Duty Role or Privilege required to run this report, we have assig…Mohit07071990 31 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
OTBI - How to get all workers who are hired, and transferred to the target department in 30 days?Summary: OTBI - How to get all workers who are hired, and transferred to the target department in 30 days? Content (required): Hi experts, Could you point me in the righ…Volodymyr Faranosov 31 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Hiding Out of The Box Reports - (Human Capital Management)Is it at all possible to hide the folder that contains the out of the box reports (Human Capital Management)? I can see we can remove the 'BI Consumer Role' from our rep…MikeW 51 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbentsSummary: OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbents Content (required): Hello, I'm building a data quality dashboard and would like to ask … -
Column Data to print inline using Logical sqlSummary: We want to print area manager value in single column if there are multiple of them, currently its printing in two separate lines. Content (required): OTBI repor…Praveen D 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Cannot display data on standard analysisSummary: Generic user cannot see data while admin user can Content (required): Standard Analysis "Recruiter Work Load Details" saved under /shared/Human Capital Manageme…Stefano_Mazzocca 31 views 3 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Automatic parameter binding for contextual reportsSummary How to configure R13 functionality "Application Context Passing to Embedded Reports"Content We are trying to configure the solution "Application Context Passing …Gabrielle Ungaro 69 views 2 comments 1 point Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
Reporting on OTBI and its Subject areas in UseSummary: There is requirement to check if there are any existing OTBIs that uses fields identified as sensitive. Is there a way to achieve this? Content (required): refe…Girish_Kulkarni_123 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Reviews for Inactive employeesHi, I am trying to pull a performance review for a terminated employee.When I go into the performance performance goals screen and search for the employee, he iş appear …Cansel Karasoy 41 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
How to get the monthly details of the Asset depreciation while creating an OTBI report?Summary: Hi All, Thank you in advance for your help. Kindly note the below: While creating an OTBI report for the depreciation of the FA, I selected several subjects in …
-
Reporting Comments on Termination/Resignation Quick ActionSummary: Content (required): In classic UI, we were able to pull Employer Comment on OTBI analyses but that field is not available in RUX and is replaced with Comments a…Kathleen Nguyen 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get effective date of analysis so only values with a date greater than a specific date show?We have a report build to view talent ratings and are using the subject area Workforce Profiles - Person Profile Real Time. Our report is currently showing every record …JMora1234 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
FEIN Number in OTBI AnalysisSummary I'm trying to pull in the FEIN Number that my roster of active employees are assigned to. Is that possible?Version Oracle Cloud V20BUser_2025-02-04-18-03-17-329 136 views 18 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How create a column by concatenating multiple columns in otbiSummary How create a column by concatenating multiple columns in otbiContent We have a requirement to concatenate multiple columns and print it as separate column in otb…User_2025-02-05-02-11-29-794 1.7K views 9 comments 1 point Most recent by Ankur Kamboj-Oracle Reporting and Analytics for HCM
-
Need to display terminate records as on Yesterdays dateSummary: Need to display terminate records as on Yesterdays date Content (required): We are referring "Workforce Management - Work Relationship Real Time " subject area.…
-
How to use/review Oracle predefined data models ?Summary: Hi, I am facing an issue which is i am not able to see some of the predefined reports/data models. For instance "Work order material transaction e-record report…
-
How to fetch the Opening and Closing balances(quantity and value)Summary: We are trying to develop a report where we can fetch the Opening and Closing Balance(quantity and value) over a period of time. We are not able to find the requ…
-
Unable to use deep link to navigate to view journal page through OTBI.We want to use Deep links in our OTBI report for journals. By using that deep link we should be able to navigate to view journal page in the application. However we have…KanikaGupta 572 views 1 comment 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How can I see the Goal Tasks details of inactive employees in the Analysis report?Hi, I am preparing an analysis report from the Workforce Goals- Goal Tasks Real Time subject area and I have added 'Display Name' , 'Task Name' and 'Comments' fields to …Cansel Karasoy 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report that shows what OBTI is attached to an InitiativeSummary: We need to run a report that shows what OBTI Analysis is attached to an initiative, so we know which are currently in use. Content (required): Learning Initiati…
-
Reporting on specialization sub statusesSummary Reporting on courses below specialization levelContent Hello We have a number of 'induction' specializations containing a number of courses and we are having two…
-
attachment in bursting not addingSummary: requirement is to add attachment using data model for custom report, in bursting section we have added email bursting and adding attachment but we are receiving…Rehber Hussain 103 views 5 comments 0 points Most recent by Rehber Hussain Reporting and Analytics for HCM
-
Is there a way to pull in current assignments from Person Profile Real Time?Summary: Subject Area: "Workforce Profiles - Person Profile Real Time" Content (required): Hi All, We have been attempting to pull only the current active assignment fro…William_Johnson 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Pull current assignment only from Workforce Profiles - Person Profiles Real Time subject area?Summary: Subject Area: Workforce Profiles - Person Profiles Real Time Pull only most recent, current assignment - NOT past assignment data Content (required): Hi All, *R…William_Johnson 61 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Workforce Talent Review - Talent Review Tasks Real Time administrator view of all tasks in system?Summary: Subject Area: Workforce Talent Review - Talent Review Tasks Real Time HR View All security assigned to report creator Content (required): Hi All, For the Workfo…William_Johnson 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM