OTBI
Discussion List
-
How to create OTBI analysis that will display Assets with their source lines details?Summary: Need to create an analysis that will display Asset info (number, description) with its source lines details (project, invoice info) Content (required): When cre… -
Fiscal calendar in OTBIHas anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year starts in November (October 28th for 2020). We have a lot of reports that we end up …SM-Oracle 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
GL Audit Data export from SAASContent We are in the process of GL Auditing with Audit agency, Any body could share the template of DM and REPORT from Oracle SAAS environment to EY. Version 21CNarenInova 25 views 2 comments 1 point Most recent by Jeff Hare CPA CISA CIA General Ledger & Intercompany -
Pass parameter to embedded report in pageSummary Pass person id as parameter to embedded report.Content We need to display some employee information on the Public Info page for any employee. Since personalizati…Varkey George-Oracle 166 views 3 comments 1 point Most recent by User_XHDBT Reporting and Analytics for HCM -
Random Sampling of EmployeesContent I am trying to pull 50% of the employee population at random. Is there a report or formula I can use to pull this information?Riti Malhotra 36 views 13 comments 0 points Most recent by Caleb Pingelton Reporting and Analytics for HCM -
Work structure reports for Oracle HCMSummary Work structure reports for Oracle HCMContent Do anyone have list of reports which can help pulling the work structure details from the configuration tables - JOB…Prabhu Krishnamoorthy 35 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Drilldown to a RMCS Contract from a OTBI Report.Summary Am trying to create a OTBI report which allows drilldown to a RMCS Contract by clicking on Contract Number Column.Content Has anyone tried creating a OTBI report… -
21C Content counts are duplicatingSummary 21C Content counts are duplicatingContent Dear Experts, Please advise why the content counts seem to be duplicated. The course has only 4 contents after I update…
-
HCM Integration Real TimeSummary HCM Integration Real TimeContent Hi Experts, I am trying to build an OTBI report based on "HCM Integration Real Time" subject area to fetch HCM Extract definitio… -
Course Publish End Date in OTBISummary Is it possible to report on the Publish End Date of a course in OTBI?Content Hi All Is it possible to report on the Publish End Date of a course in OTBI? I've us… -
Candidate Address and Other - IRC_JobOffer_Accepted_External - Alert/NotificationContent Hi, Using Alert: IRC_JobOffer_Accepted_External, added template. Whereas Procurement Department need to be informed that Candidate accepted offer. Procurement ne… -
Use TIMESTAMPADD in SQL PrefixSummary What is the correct syntax for using TIMESTAMPADD in a SQL prefix without using a presentation variable prompt?Content Hello - I am creating an analysis that wil…User_2025-02-08-04-27-03-855 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Calculate Time at grade, location, time in role (not position) using Assignment Event Real Time in HContent Hello, I am trying to use OTBI to look at an employee's assignment history and derive new calculated fields for the following: * Grade Effective Start Date and t…RebeccaAult1799 99 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Issue in Turn Over ReportSummary I have built Turn Over Report with 2 subject areas workforce Management-Assignment Event Real Time and Workforce Management- Trend Real Time .Content The Columns…User_2025-02-08-08-08-53-292 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to report on the Short Description field from the course page in OTBI?Summary Is it possible to report on the Short Description field from the course page in OTBI?Content Hi All Is it possible to report on the Short Description field from … -
How dependent parameter works in OTBI Report, BI Report and DashboardSummary How dependent parameter works in OTBI Report, BI Report and DashboardContent Hi Experts, Can someone explain how the following thing works in OTBI Report, Dashbo… -
Sample snapshots of OOTB Reports and AnalyticsContent Hi Everyone, Client need sample snapshots of all OOTB report and analytics, Let me know where can i get all snapshots of OOTB report and analytics. Please let me…Reddykrishna Chidella-Oracle 38 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to open User Defined report in the Demand ManagementContent Hi Gurus, According the user guide we should be able to add user defined reports once user defined report is placed on into the Reports Components subfolder with…Venkatesh Periketi 29 views 1 comment 1 point Most recent by Yogesh_P-Oracle Supply Chain Planning and Collaboration -
OTBI to Fetch Shopping List details.Summary OTBI to Fetch Shopping List details.Content Dear Team - Our Client is from the health care industry and they are heavily dependent on Shopping List. As of now cl… -
Multiple Dashboards to oneContent I have created 2 separate dashboards one for Headcount and one for Performance Document. I want to now add the performance dashboard as a separate tab on the hea…