OTBI
Discussion List
-
Talent Review - no results OTBISummary: We have created a custom Talent job/data role which contains the relevant security access to view Talent in My Client Groups. We now want this custom Talent rol…Jo Ord 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Data is not retrieving for not started status in OTBI DashboardsSummary: Hi Team, I hope this message finds you well. We are currently facing an issue retrieving data for the 'not started' status regarding employee feedback. Specific…Sujan Kumar Dash 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Learners cannot view the uploaded videos after enabling redwoodSummary: Content (please ensure you mask any confidential information): Learner is not able to view the approved videos after redwood is enabled. What could be the issue… -
Payroll - Payroll Balances Real Time subject area giving No ResultsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 31 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to access OTBI dashboard for Procurement - PurchasingSummary: An user can not access to a dashboard for Procurement - Purchasing on OTBI, the user has assigned the purchase analysis role Other user with te same role can ac…
-
Opportunity market place report - Self service PUBLICSummary: Do you have any report available that could help me to provide a listing of all jobs available in opportunity marketplace ? The report should be public (linked …Jacqueline GRANDIN 21 views 3 comments 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Sickness Absence ReportingSummary: We have work schedules entered for all employees showing their working days. We need to export this in our absence reports so we can calculate working days lost…Karen Wilson 12 views 4 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
BI Publisher - Object_version_number column in gl_je_headers tableDear All, After creating a journal manually, the object_version_number in gl_je_headers is set directly to the value 3. Can anyone tell me what the purpose of this colum…George Mattar 11 views 1 comment 0 points Most recent by Uddipta Bhaumik-Oracle General Ledger & Intercompany
-
How should I find the full names of the people in the approvers column in the fa_fusion_soainfra.WFTHello, I use the APPROVERS column in the fa_fusion_soainfra.WFTASK table in my report, but the username is included there. I need approvers display name information. Can…Cansel Karasoy 34 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
No Results for Supply Chain Rollup Costed BOM ReportSummary: We are not seeing any results for the new subject area, Costing - Supply Chain Cost Rollup Real Time, that supplies results to the Supply Chain Rollup Costed BO…
-
pivot table/ stacked graphSummary: Hi all, I have created an analysis and used a pivot table to generate the stacked graph. Does anyone know if we can move the totals to the top so that it is not…
-
SUPPLIER BALANCE AGING - SQL QUERY NEEDEDSummary: We have a customer requirment to customize the supplier balance aging to increase the aging buckets than the standard one. So we want the sql query for the unpa…Yara Ibrahim-Oracle 442 views 2 comments 0 points Most recent by Sean Rogers Payables, Payments & Cash Management
-
How to set a As-Of Date Prompt in a Dashboard PromptSummary: How to set a As-Of Date Prompt in a Dashboard Prompt Content (please ensure you mask any confidential information): Hi, we created a dashboard. This dashboard h…Barile Alberto 112 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need inputs to display Payroll Run Results based on JobSummary: Need inputs to display Payroll Run Results based on Job Content (please ensure you mask any confidential information): We need to display Payroll Run Results da…Visu 21 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Is there a Workforce Management - Position Event Real Time Subject Area?Summary: There is currently a Subject Area for Workforce Management - Position Real Time selectable when creating an Analysis in OTBI. This Subject Area shows the max ef…Gloria Brewster 41 views 4 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for ERP -
OTBI Report for collaboration messaging historySummary: User requires an OTBI report scheduled on a daily basis for the errored out Purchase Orders and Invoices to keep him notified. Can you please suggest the subjec…Sumiran Maheswari 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Excel Report Errorummary: Hi experts, we are trying to upload a ready excel file as a Report, but we continue to receive the following error message when trying to view it. We have alread…Marlon Castillo Maliglig 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
What role is required to Grant only Reports and Analytics Catalog in Oracle Cloud ?Summary: We have a requirement from Business. Business wants to Run only the OTBI Reports from Cloud. So, What role is required to Grant only Reports and Analytics Catal…
-
Freezing of Headers in a Pivot TableSummary: We have this analysis showing multiple records. Is there a way to freeze the pivot table header view in this dashboard? We have checked Oracle documentations an…Kelvin Jamil Reyes 21 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
SQL IF Statement for FiltersSummary: I am attempting to create an OTBI report that has both work and personal/home email for new hires. For the work email I have that information from the Worker As…
-
Multi Select field in UI returning Lookup Code in OTBISummary: We have this field in Sales UI having an FCL multi select in Division custom field. We have tried to add DESCRIPTOR_IDOF in this field however it is showing bla…Kelvin Jamil Reyes 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to handle the data which has a new line in it in LOV/BI Reports.Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not han…Sura Yashaswini 11 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM
-
OTBI: manager with at least a direct report both based in the same countryHi everyone, Our customer has the following requirement: To retrieve the list of the manager L1 located in italy with at least a direct report Both manager and direct re…Alessandra T. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Pivot Table limits numbers of rowsHi, I have an OTBI report for Total Comp Deferred Cash Payments year wise. This is a simple report from subject area - Payroll - Element Entries History Real time. We ar…Arnabb 51 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM