OTBI
Discussion List
-
OTBI:I need to pull the carryover limit of persons enrolled in an absence planSummary: I need to pull the carryover limit of persons enrolled in an absence plan Content (required): I need to create a BI Publisher report that pulls the carryover li…Jose Lorenzo Amarado 52 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM -
Best subject area for pulling "Worker"."Work Email" into OTBI?Summary: Current Subject Area Used: Workforce Management - Worker Assignment Real Time Columns: "Worker"."Work Email" OR "Worker"."Employee Email Address" Content (requi…William_Johnson 47 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
Getting an error while running OTBI reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Sidhartha Wadhwa 28 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to create an As of Date field into a Dashboard to sort the Effective Employee at a specific dateSummary: Hi Community! Hope to find you well. Our client ask us to add into a Dashboard's Page an As of Date field that can make possible to extract all the effective em…Luca9797 24 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI report not fetching data while using columns from Comp manager / Comp worksheet manager foldersOTBI report built using "Workforce Compensation Budget Real Time Details " subject area is not fetching any results. Hello there, We have a requirement to build a Countr…Gudupu, Jaswanth Sai 327 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can we restrict the creation of OTBI Report only the BI AdministratorSummary: Can we restrict the creation of OTBI Report only the BI Administrator Content (required): Currently any user with BI Author role can able to create the OTBI Rep…HarishVummidi 84 views 5 comments 1 point Most recent by HarishVummidi Reporting and Analytics for HCM -
Annualized Salary for terminated employeesSummary: I wanted to create an analysis to get terminated employees annualized salary. Content (required): I used compensation salary history details real time object an…Ayesha Iroshani 46 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to Report on General Talent Review Meeting Notes in OTBISummary Unable to Report on Talent Review Meeting Notes in OTBIContent All, In developing OTBI reports to view general notes associated with a Talent Review, I am unable…User_2025-02-08-03-57-26-191 14 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
Need to create a single report for the following fields in OTBI Or OBIEE.Summary: can we able to create a single report with this fields in OTBI Or OBIEE. Education details ( highest one ), Previous Experience ( last worked ), probation statu…Jebarsan Thangam John Durai Raj 25 views 4 comments 0 points Most recent by Jebarsan Thangam John Durai Raj Reporting and Analytics for HCM -
Audit Report for inactive bank account associated with employee payment methodSummary: Audit Report for inactive bank account associated with employee payment method Content (required): Hi Team, Greetings! Is there any existing Audit Report for in…Parag Hiremath 169 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Post Conversion validation reports for Core HR moduleHi Team, Could you please help us with the Post Conversion validation reports for the Core HR module? We need the following reports. Please share with us if you have eit… -
Need Help with Permissions Required for HCM Subject AreasSummary: I've got a service account that we use to pull extracts into Casabase. We are getting access to all of the ERP and accounting subject areas. However, we are now… -
Updating RTF for Element Register ReportSummary: There is an error on the Element Result Report that produces split lines for Person Number. I need to update the rtf to correct this. Content (required): When s… -
Monthly scheduled hoursSummary: Content (required): Is there a way in HCM to find the monthly scheduled hours for an employee? Does anyone how if this information is stored in a table? For exa…Nicolas Vahman 57 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM -
HowThere is aCansel Karasoy 47 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM -
we have OTBI Report skills and certfications but it showing unparallely ?Summary: HI Team, We have report facing this is how can sorted Content (required): Version (include the version you are using, if applicable): How it looks in the report…AjayKumar Maddipati 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Tree Name Criteria Dropping out International & Non-EmployeesSummary: Hi - I am creating a report with a number of different fields pulling from the following subject areas: When I have all of my criteria EXCEPT for the tree name,…Kyle Norris 26 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Prepare Review Content example reportsSummary: Prepare Review Content Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to better engage our e…William_Johnson 26 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way in OTBI not BIP to combine a "Security" with a "Workforce Management" Subject AreaSummary: Trying to combine Security Subject Area to a WFM Subject Area so we can see role on a user and which department they are in Content (required): There is an inte… -
Termination Date for ManagersSummary: We are looking to create a report with employees with a manager who has a future termination date. How would I include the managers termination date? Content (r…Jo Black 15 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Personal Payment method DetailSummary: I need Employee's Personal Payment method Details like IBAN and bank account info. My client wants to add these fields to the existing OTBI report. Currently, I…Saher 441 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject Areas - Seniority Dates and Per Periods of ServiceSummary Subject Areas - Seniority Dates and Per Periods of ServiceContent We are wondering if there is a subject area, or an enhancement to allow for analysis to retriev…Dustin Puchalla 417 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How should I write multiple data returned from a column separated by commas next to each other?Hi, I actually have a pretty simple little query. More than one data is returning from this column and I want to write it on the same line separated by commas. SELECT YY…Cansel Karasoy 47 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Performance Document Ratings - Dashboard - Prompt QuestionSummary: OTBI - can a prompt be used to define which column to be used in a filter Content (required): I'm trying to generate a dashboard prompt which will define which …David McLellan 46 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report to view workflow configuration in Fusion HCMSummary Report to view workflow configuration in Fusion HCMContent In Fusion HCM, we navigate to 'setup and maintenance' > 'Manage approvals for Human Capital Management…User_2025-01-25-04-02-13-126 385 views 12 comments 0 points Most recent by SanjayC Reporting and Analytics for HCM -
Workforce Talent Review - Talent Review Tasks Real Time reporting bug?Summary: How can we pull a report using this subject area to provide an administrative overview of all existing tasks in a Talent Reviews within the system? Content (req…William_Johnson 26 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
OTBI Analysis transaction report giving wrong result.Summary: Hi Everyone!. I have created an OTBI Report which fetches the Document of Records Transaction. Context: If anyone modifies something in the Document type called…ShawShankk 65 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Date of Birth less than 16 yearsSummary: Employees with Date of Birth less than 16 years. Content (required): I need to create a list of employees with a Date of Birth recorded that would make their ag… -
HOW TO PASS AsOfDate TO OTBI AGENT OUTPUTSummary: We have created a OTBI report with AsOfDate prompt which is getting passed . This report will be scheduled monthly through agent. Our requirement is send the ag…Aathimoolam R 33 views 2 comments 0 points Most recent by Aathimoolam R Reporting and Analytics for HCM -
Report on specific Manager and his/her actions with employeesSummary: Content (required): Good afternoon. We have a request to identify any employees that one specific manager either Supervised (their direct supervisor), Hired (th…