Category 81
Discussion List
-
OTBI Dashboard Prompt based on "Trading Partner Item Details" is not returning valuesSummary: We have. a dashboard that contains an analysis and a prompt. The prompt is based on the following sql query: SELECT 0 s_0, "Product Management - Trading Partner…Hassan El Bouihi-Oracle 51 views 3 comments 0 points Most recent by Wim Bos [MLE] Product Master Data Management -
Tenure in Job FamilySummary: Content (required): I am looking for time in job family. I have reports already for overall tenure and time in current assignment/job but need something for job…Riti Malhotra 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Filter by results of another analysis is slowSummary: The 'Filter by results of another analysis is extremely slow' Content (required): I have an, admittedly heavy, analysis with a significant number of calculated …DanielHarley 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to properly address P2T ERP missing subject areas when support remains unresolved after a week?Summary: Missing OTBI subject areas after every clone, support unresolved Content (required): Every clone has same issues with OTBI subject areas missing. We follow SR g…Melissa Goodrich 21 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
IDR for PrepaymentsSummary: Content (required): Hi, Does IDR support scanning of Invoices with the Invoice Type of "Prepayment"? Version (include the version you are using, if applicable):…Sheneli98 226 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Payables, Payments & Cash Management
-
OTBI - Count FunctionSummary: Content (required): I have the below requirement, A report to capture all transaction details and the entry users has already been created. (The format is attac…Sheneli98 1.6K views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Report to fetch the timecard approver detailsSummary: Content (required): We have a client requirement to build a report to fetch the timecard approver details. Does anyone know whether it is possible to fetch the …Prajna Hegde 141 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Is there an attribute in PPM that shows the Return on Investment (ROI) of a Project or Program?Summary: In Project Performance or Program Analisys or OTBI, is there a collumn that represents the return of investiments? I didn't find this field. ROI = (Gain from In…Wilromar Benevides 31 views 2 comments 0 points Most recent by Wilromar Benevides Project Management
-
Will RTF template support gif files?Summary: Will RTF template support gif files? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that su…GTS Narayanen 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Secure OTBI so user can see only 1 folderSummary: We are implementing EHS and want the safety managers to only see the EHS folder under the custom folder. Content (required): Do we need to apply permissions to … -
Issue with Performance Annual Review analysisSummary: Need an analysis that crosses two subject areas with the Rating Numeric Rating column added We are trying to build an analysis that involves two subject areas (…User_2025-03-07-01-17-51-586 31 views 6 comments 0 points Most recent by User_2025-03-07-01-17-51-586 Reporting and Analytics for HCM
-
Is there an alternative to using Use Allow Expansion and Suppress Missing Blocks in FR reports?Summary: We have a FR report for payroll with one column called Other Compensation in which one of the grid POV is an alternate hierarchy for Earn Code which is set to A… -
OTBI does not show accrual/absence balance dataSummary: I'm trying to create a report which shows an employee's accrual. However it does not show any data in OTBI. Content (required): I want to create a report in OTB…Nicolas Vahman 355 views 8 comments 0 points Most recent by Sandeep001rp Reporting and Analytics for HCM
-
A report for print options for AR customers - Missing FieldSummary: A report is required to detail the print options for AR customers The issue I am having is location the tables that hold Statement Preferred Delivery Methods fr…User_2025-02-11-10-53-01-866 51 views 2 comments 0 points Most recent by User_2025-02-11-10-53-01-866 Reporting and Analytics for ERP -
Does a CLOB column supported by Advanced SQL Tab in OTBI when combining two subject areas?Summary: I always get an error when I tried combining two subject areas in OTBI under Advanced tab which consist of a CLOB column such as comments. Does anyone know how …Hazel De Castro 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Folder Security in Question LibrarySummary: Hi Experts, In our project there is a requirement to secure the folders created in Question library under Task name : Define Questionnaires. We have capability … -
OTBI Subject Area or Query to retrieve Job Profile informationSummary: Content (required): Hello experts, is there an OTBI subject area to retrieve Job Profile information such as: ProfileItemId, ProfileId, ProfileCode, ContentType… -
Reporting issue - How to show sickness days vs actual worked daysSummary: Reporting issue - How to show sickness days vs actual worked days Content (required): I am trying to write a report to show the number of days a person is contr…User_2025-03-07-06-11-23-192 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Adding Department to existing report - Employee Absence CalendarSummary: We are using the report - Employee Absence Calendar - from here - https://community.oracle.com/customerconnect/discussion/70219/employee-absence-calendar/p1 it …Ian.Gooderham 61 views 6 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Payroll Element QuestionnaireSummary: Looking for a query to Fetch the Payroll Element Questionnaire Details Can any body Please share a query to Fetch the Payroll Element Questionnaire details Cont…MilanMohanty 380 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Displaying a report on certain pages but not othersSummary: We are looking for a way to display a report on some of the HCM pages - but not others. We are displaying an OTBI analysis as a web component and passing the pa… -
Why do I keep getting an error when trying save an agentSummary: I am creating a new agent, when I save I get the below error? Any ideas why. Thanks! Content (required): Version (include the version you are using, if applicab…Lisa_R 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Performance Document RatingsSummary: Performance Ratings from 2 different performance documents on the same row. Content (required): I'm reporting on End of Year Review ratings but need to pull in …David McLellan 51 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM