OTBI
Discussion List
-
DRILL DOWN TO EXPENSE REPORTS AND EXPENSE ITEMS FROM OTBISummary DRILL DOWN TO EXPENSE REPORTS AND EXPENSE ITEMS FROM OTBIContent Do we have a deep link which we will use in OTBI Report, this is new feature in 20C https://www.… -
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 111 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How to Add Two Entries in one Criteria from the same Subject AreaSummary: Hi Team, We are trying to add two Entries in to one Criteria in the same Subject Area. Kindly help us how to add. 1. Document Review Cycle Info->Business Proces…Srinivasa Rao Pavuluri 61 views 0 comments 0 points Started by Srinivasa Rao Pavuluri Product Development
-
Copy and Modify the Seeded Recruit to Hire DashboardSummary: We want to make modifications to the analysis tied seeded Recruit To Hire Dashboard. I've read various posts and documentation on how to achieve this, but none …Alex Tellez 161 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to update the Item Cost to the last Receipt CostSummary: How to update the Item Cost to the last Receipt Cost Content (required): As per the business, they maintain the cost on the basis on the basis of last received …
-
Are there downloadable dashboards for Supply Chain Management modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu…
-
Pulling Comments from Resignation/Termination ActionSummary: Content (required): We are implementing employee self-service and manager self-service on submitting resignation/termination. There is an Comments and Attachmen…Kathleen Nguyen 31 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
REST Service for Item EFFSummary unable to get it workingContent Can some one help with below payload to make it working. I am creating Item EFF. My URL is…
-
Dynamic assignment of a course does not workSummary: Dynamic assignment of a course does not work Content (required): Hi, we are encountering an issue with the assignment of a course in LMS. We set a dynamic rule …
-
Dynamic Regular Date Earned Formula RequiredSummary: Need a formula to get the last two regular dates earned to update each month. Content (required): I have a Payroll Net Pay Variance report which compares the Ne…
-
Annual Leave Buy / Sell - ReportSummary: A Report to identify those Employees who Bought / Sold Annual Leaves Content (required): Hi, Can you please help me to develop a report which will give details … -
HR self-service reporting in Oracle HCMSummary: Content (required): Hello everyone, I wanted to ask about the possibility to have HR self-service reporting in Oracle HCM, i.e. the possibility for HR users to …Maria Xydopoulou 61 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Deeplinks in OTBI and BI ReportsContent Is there a way we can use the Deeplinks in the OTBI and BI reports dynamically. Suppose I have a column for 'Person Number' and I click on a particular person nu…Amrit 121 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Properties Attribute "Read Only" - what does it do?Summary: Properties dialog box -> Attributes section -> Read Only Content (required): Hi All, If I adjust the attributes section to "read only" in the properties dialog …William_Johnson 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Parameter not working when embedding OTBI AnalysisSummary: Embedded an analysis on HCM page but it seems that the binding variable is not being received by the analysis because the report is not being filtered Content (…Jezreel Furagganan 61 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM
-
How to get courses to deploy in 6 months from a learner's enterprise hire date?Summary: All our courses are deployed via OTBI analysis reports and functions off the learner's profile data such as pending worker, employee. position movement, etc. Wh… -
Why OTBI Analysis not giving correct manager details in output ?Summary: OTBI analysis not giving correct output in one environment but working on other environment Subject Area : Workforce Management - Worker Assignment Real Time Co… -
Ability to drill down to transactions from Trial Balance Report Account balancesSummary: Ability to drill down to transactions from Trial Balance Report Account balances Content (required): We have a requirement to drill down to see transactions per…Ajay Hareesh 473 views 9 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Seeded line manager dashboards for executive leadershipSummary Dashboards for executive leadershipContent We have made a copy the of seeded line manager dashboard and modified it to work with our system configuration and req…User_2025-02-10-08-27-16-805 101 views 12 comments 0 points Most recent by Deborah A Reporting and Analytics for HCM -
How to get Home email and business email addresses in OTBI reportingSummary: How to get Home email and business email addresses in OTBI reporting? Content (required): We are trying to get employees home email and business email addresses…Abhishek Jois 586 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
COUNT IF in a columnSummary: Replicate the COUNT IF condition in a column Content (required): Hi All, I need to replicate this KPI in a column of analysis: In details, I don't find the corr…Andrea Rubino 82 views 2 comments 0 points Most recent by Andrea Rubino Reporting and Analytics for HCM
-
Transaction Detail - TerminationSummary: Terminations used to pick up in our transaction detail report but it seem to had stopped working from 22D. Content (required): Is there another way to create a …Ratha Sun 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How should I calculate the employee's seniority?Hi, I have a query where I calculate the seniority of the employee and I want to sort by the highest seniority. The query works like this if the 'Seniority Reference Dat…Cansel Karasoy 42 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
how do I define datesSummary: I am trying to fun an agent weekly and want to have it select a date range Content (required): the job will run every Friday morning and needs to include employ…
-
Open/filled position management reportingSummary Delivered Position Incumbents report returns terminated employeesContent Hello - There's a requirement to create a report of all current filled/open positions wi…
-
Please can someone share a catalog file for an analysis representing the catalog items?Summary: I am struggling with preparing an analysis containing a representation of the learning catalog. Probably due to a lack of knowledge with OTBI. Content (required… -
Request for Email Alert Setup: Task Status Change NotificationsSummary: We need to have an email alert to the task owner and project manager whenever the task status changes from "not started" to "Started" and "Started" to "Closed".…
-
OTBI:Market Data: No data in report when columns from Global HR dimensions are usedSummary: Guidance to ensure that Market Data reports return data when Global HR dimensions are used. Content (required): 1- Subject Area: "Compensation - Market Data Rea…Abhishek Dixit-Oracle 61 views 3 comments 1 point Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Combining fields into one field or cell in OTBIIs it possible to combine all the columns and rows (per person) under Question Text, Response Answer and Response Text in one field? From this To thisEm-Jay 11 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Need to know Progress Summary Reason Table/Subject area nameSummary: Need to know Progress Summary Reason Table/Subject area name Content (required): We are unable to find Progress Summary Reason field either in the Recruiting - …Visu 41 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM