OTBI
Discussion List
-
Oracle HCM Value Sets Rest APIHi, I want to create a record for value set using Oracle Rest Api information.I found this API for this How should I use the ValueSets_Id information, which is the param… -
Report off of Attachments Within Performance ModuleSummary Managers and employees can add attachements to their performance form. I need to know who has an attachment.Content Our managers can use the attachment field at …User_2025-01-25-00-37-41-739 63 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to get the latest record in OTBISummary: Hi , I am just working on very simple requirement . Where i need to get below columns. Employee/ZinZai ID Person full name Person email address Person status ( …Vishnupriya 371 views 6 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM -
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 383 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
OTBI Report to get capacity rule's booked seat from Learning ModuleHello Expert's, Want OTBI Report to get Booked seats from Capacity Rule in HCM Learning Module. Please check below navigation and Image. My Client Groups> Learning Catal…Rajdeep Chavda 61 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Table for BPM - specifically CONFIGURATIONSContent We are looking for tables to be able to look at the workflow rule configuration. For example, we want to be able to create a report that will tell us things like… -
Can you customize Learning Certifications Report and add to specific courses + specializations?Summary: Hi All, We are trying to leverage the 21D functionality that enables learning completion certifications to be printed and displayed by users. The question is th… -
How can give condition Sysdate betwee effective start date and effective end date in OTBI analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Anup Karmankar 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Receivables Aging by General Ledger Account ReportSummary: We are trying to develop a new custom aging report as to ease the reconciliation and make some custom column but we are not able to match the report with the st… -
link between FND_SESSIONS table to country and stateSummary: link between FND_SESSIONS table to country and state Content (please ensure you mask any confidential information): By using FND_SESSIONS table, we can get the … -
Learning Incident - Learning Item Owner No Longer in the CompanyHello! If the course owner/creator is no longer with the company (terminated or resigned), who would receive the notification if the course created by them is reported? … -
Looking for System Usage MetricsSummary Reporting on who/when/how/what users are accessing in HCMContent Need to report on system usage and adoption rates for our HCM system with a focus on Employee an…Becky Stalsby 230 views 13 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Enrollment effective end date meaningSummary: Enrollment effective end date meaning Content (please ensure you mask any confidential information): Hello experts, I've created a report with the Learning Reco…Oriana L. 11 views 3 comments 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Performance Documents Competency Assessment TasksSummary: Looking for the Performance Documents Competency Assessment Tasks assessee and assessor data Content (please ensure you mask any confidential information): Hell… -
how to report learners in waitlist otbiSummary: how to report learners in waitlist otbi Content (please ensure you mask any confidential information): Hello experts, we would like to create an OTBI analysis t… -
Adding Days to DayNameI am trying to calculate the end of a weekly cycle. I have a column with day names and another column with the number of days to add. For example, adding 3 days to Monda…UserAA_2026 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How to fetch SourceRef values loaded via hdl?Summary: We are loading some source reference values while loading allocated checklist to employees. However I am not sure how to fetch this values in an OTBI and BI rep… -
Path to the Instructor Feedback Dashboard in the Demo POD?If I navigate to the mentioned path, there is no Instructor Feedback Dashboard. where can I download the Instructor Feedback Dashboard Path #{EndPointProvider.externalEn… -
How to set in OTBI report the difference between a variable (an input parameter) and a fieldSummary: How to set in OTBI report the difference between a variable (an input parameter) and a field Content (please ensure you mask any confidential information): Hi, …Barile Alberto 101 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
We need fetech the status of Exist survey report how can i get in OTBI May I know subject area?Summary: Hi Team, We need fetech the status of Exist survey report how can i get in OTBI May I know subject area? Thanks, ajay Content (please ensure you mask any confid…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Fetch competency catalog from subject area "Workforce profiles – Library objects Real time”Summary: Hi experts, we're trying to fetch the whole competency catalog using an OTBI analysis in the subject area "Workforce profiles – Library objects Real time". The …Oliviero Riva 21 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…Aahiri_Sarma 19.2K views 22 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
GL Revaluation sources - report to show the invoices/payment (sub-ledger) transactionsSummary: Hello All, We have a requirement where business wants to verify the source transactions (AP invoices/payments) that are considered for the revaluation process d…Subhasish-OC 21 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany