OTBI
Discussion List
-
How to use the Min aggregate function along with group by clause in OTBI analysisSummary: I have a requirement to build analysis to fetch all the benefit enrollment data for a participant as well as dependent. I need to fetch the actual enrollment da… -
Learning Initiative Automated AssignmentsContent We currently have a Learning Initiative programmed with analysis criteria for each of our required courses. We selected in the initiative how many days each new …
-
Turnover for a Certain PeriodSummary: Is it possible to report on period start headcount and period end headcount for anytime period instead of month start and month end from the Workforce Trend Rea…Anita 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Bulk upload/edit fixed asset location segment values "descriptions"Summary: Updating the location value description in fixed assets in bulk Content (required): There is a requirement in order to update the asset location segment values … -
Year to Date Turnover FilterSummary How to return Year to Date (YTD) this year vs. YTD previous years for turnover metrics.Content I'm trying to return year to date turnover and compare it against …Ryan_Sullivan 35 views 3 comments 0 points Most recent by Ryan_Sullivan Reporting and Analytics for HCM -
Reporting on Area of ExpertiseSummary Reporting on Area of ExpertiseContent The Talent Profile - Me > Career Performance > Skills and Qualifications Includes an Area of Expertise section and we would…User_2025-01-23-21-24-21-434 87 views 2 comments 0 points Most recent by dwi Lestari-Oracle Reporting and Analytics for HCM -
how to auto run an analysis with promptSummary: I have created an analysis with prompts. I want that when an analysis is run, it should display the output with default prompt option 'All Column Values'. Curre…Dilpreet Kaur 33 views 5 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Embedded Reports and the environmentSummary: Every time we take a release, I have to relink all of our embedded reports to point to our TEST environment. Content (required): Is there any way that we can ha…User_2025-02-04-08-51-08-912 1 view 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Reporting Requisition Detail with Pending Worker DetailSummary: We have a requirement to report all Pending Workers which works fine, but we also need to include some basic Requisition detail such as Req Number and Title. Wh…Emily Robinson 97 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report for tracking duration of TerminationsSummary: We have a need to report on the duration of termination, in specific, how long was the time period between when the termination request/workflow was initiated a…Adil_R 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you create custom subject areas for a SAAS implementation?Summary: It appears that custom subject areas can be created - but I am not able to find if this is available for standard SAAS HCM Cloud implementations or if any addit…Karen Long 21 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Query to get sales order details plus transaction detailsContent Hi all, I need a query to get the sales_order_number,sales_order_header_id,inventory_transaction_id for the sales order. Please do guide me. RegardsSushan Peris -
How to embed custom reports into supplier pages using page composerSummary How to embed custom reports into supplier pages using page composerContent The Supplier Overview page has a set of reports which helps the Supplier Administrator…
-
Building a report that shows Activities within an Offering?Summary: I am need of building a report that shows the learn activities within an offering. Content (required): Version (include the version you are using, if applicable…User_2025-02-11-00-58-38-371 21 views 6 comments 0 points Most recent by Jamie Rancourt-Oracle Learning
-
Gross Pay Balance for full Fiscal Year for all EmployeesSummary: I need to create or run a report for all employees to get the Gross Pay for each employee for our full Fiscal Year. Format of data needed Person Number Display …Andrew_Schmitz 195 views 1 comment 1 point Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM