OTBI
Discussion List
-
Worker Assignment Event - Created ByContent Hi, I am interested in finding out which user created the assignment event. I get the user "FUSION_APPS_HCM_ESS_LOADER_APPID" created this. How would I find out …User_2025-02-01-04-05-22-904 55 views 9 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM -
OTBI Reporting of the new Onboarding FeaturesContent We are looking at alternative designs for OTBI support for the new Onboarding feature and we'd appreciate your input. The existing Workforce Management - Checkli…Julian Challenger-Oracle 137 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject Area for Onboarding TaskContent Hi All, Is there a subject area to pull the data from the Me-->Quick Actions-->Onboarding Tasks for the pending workers. I tried using the subject area: Workforc… -
Missing Talent Profiles on ReportsContent We are doing an HDL for License and Certifications and we are missing about 1200 employees when we try and pull the profile report attached. When we pull up one …User_2025-01-31-00-25-12-234 91 views 7 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Unable to use 2 Subject Areas in the OTBI reportSummary OTBI error while using Payables Payments - Disbursements Real Time and Payables Invoices - Transactions Real TimeContent Team, We have created an OTBI report usi…Sathyaseelan Chandran 99 views 7 comments 1 point Most recent by Sathyaseelan Chandran Reporting and Analytics for ERP -
MOAC in BIP ReportsSummary Implementing MOAC in BIP ReportsContent Hello,Trying to implement security based on the role assigned to a user. Following below note, however, have not been abl… -
Link to most recent scheduleContent All - In BI Publisher reporting, is it possible that we are able to provide a static link to the most recent scheduled report? I have a report that is run daily …Prudence K 32 views 2 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Embedding BI Publisher Report on DashboardSummary Embedding BI Publisher Report on DashboardContent Hello, Looking for a better way to display an embedded BI Publisher report in a Dashboard. The views between BI…User_2025-01-28-20-36-10-715 135 views 7 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM -
Citizenship FieldContent Hi Guys, I don't able to find the field "Citizenship", some one know in which subject area can I find it? Best Regards GiuseppeGiuseppe Iacono 40 views 4 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
My Team Tab - Adding BI Catalog to PageSummary Adding BI Catalog to PageContent Background: We are planning to only use infolets as the primary channel for managers to access "reports" in HCM. We also want ma…User_2025-02-04-10-47-55-876 81 views 5 comments 2 points Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM -
DISTINCT NOT WORKSSummary DISTINCT NOT WORKSContent Hello everyone, Does anyone have any idea why my query does not work? I'm using DISTINCT but I get repeated rows. Also, we have 8500+ e…User_2025-01-25-01-17-59-580 51 views 9 comments 1 point Most recent by MandeepKGupta Reporting and Analytics for HCM -
Person running report not showing up on reportSummary Inaccurate dataContent I've created a few different report and I've found that when I run the report my data is not on present. This causes issues for our payrol…User_2025-01-31-00-25-12-234 47 views 10 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Reporting on Employee Schedule ChangesContent Hi, Has anyone built reports around employee schedule changes? For example, if a manager goes into Time Management > Manage Planned Schedule and changes the sche…Dishti Malhotra-Oracle 54 views 1 comment 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM -
Merged ColumnsSummary How to prevent merged columns in reports?Content Hi Everyone, I noticed that some of our reports come out with merged columns, which always throw off our sorting…User_2025-01-29-23-59-58-976 60 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Required Information on the OTBI FiltersSummary I have created a OTBI analysis and facing some problem while applying filtersContent Hi All, I have created a OTBI analysis using 2 subject areas 'Workforce Mana… -
CASE Statement Future Termination DatesSummary Trying to show future termination dates as blank in active reportContent I have an all ee report. One of the fields is termination date. if someone has a future …Mike Borghoff 51 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Assignment Name vs Job NameSummary Report comparing Assignment Name and Job Name to list differencesContent The Oracle bug where Assignment Name and Job Title (Name) are different causes our downs…User_2025-01-23-21-24-21-434 63 views 10 comments 0 points Most recent by Debo Reporting and Analytics for HCM -
column information for PAY_ACTION_INFORMATIONSummary PAY_ACTION_INFORMATION Developer DFF Columns detailsContent I am looking for details on action_information1...300 columns in pay_aciton_information. what data is…Rakesh Lathiya 2018 126 views 2 comments 0 points Most recent by Rakesh Lathiya 2018 Reporting and Analytics for HCM -
Individual certificates of completion per learning itemSummary Possible to create individual certificates of completion per learning item on learning transcriptContent Hello, I'm wondering if it's possible to create an indiv… -
Nesting Case statements?Summary Is it possible to nest Case statements in otbi?Content I am working on a recurring report that requires me to classify people based on certain characteristics. I…Cheryl Burwell 66 views 3 comments 0 points Most recent by User_2025-02-04-18-47-48-634 Reporting and Analytics for HCM -
HCM CLOUD BENEFITS (OTBI) Open Enrollment DashboardSummary The goal of this dashboard is to assist the benefits department management of their employee benefits data and the downstream actionable benefits data throughout…Adam Gates-Oracle 546 views 25 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Active User Name Flag (Terminated Employee or Active Employee)Summary Does OTBI provide an Activated User Flag?Content We have a requirement to provide an audit report in HCM that shows any active HCM user accounts for terminated e…User_2025-01-28-08-17-22-037 167 views 2 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM -
Is it possible to get Previous/Prior Salary Frequency from OTBI Subject areas?Summary Is it possible to get Previous/Prior Salary Frequency from OTBI Subject areas?Content Hi Team, Is it possible to get Previous/Prior Salary Frequency like Annuall…Harish Kumar Kovi 54 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Create performance titleContent Hi Guys, How i can realize a performance title that show the Learn Count for each plan cycle name? Best Regards GiuseppeGiuseppe Iacono 13 views 1 comment 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM -
Invoice Line Level Account Combination (Distribution) ReportSummary Invoice Line Level Account Combination (Distribution) ReportContent Can someone tell me what Subject Area and specific Subject in Reports and Analytics should be…racheltx 109 views 4 comments 1 point Most recent by Sridhar Tumati-55392 Reporting and Analytics for ERP -
Loading item transactions via FBDI templateSummary Can't see accounting details of the item transactions passing in FBDI templateContent Hello Team, Item transactions loading done successfully with item cost, how…