OTBI
Discussion List
-
How to add prompt to OTBI Dashboard built on Logical SQL AssemblerSummary: How to add prompt to OTBI Dashboard built on Logical SQL Assembler Content (please ensure you mask any confidential information): Hi All, We have created OTBI r… -
Looking for Table for Issue Description & Resolution in Transaction ConsoleSummary: Hi Team, I am looking for the table which store the 'Issue Description' & 'Resolution' details captures. I have tried in this table "HRC_CONSOLE_FAULT_DETAILS_V…Mohan Murali P-Oracle 314 views 13 comments 0 points Most recent by Venkat5678 Reporting and Analytics for HCM
-
Adding BIP report to OTBI dashboardSummary: I am adding BIP report to OTBI dashboard. The BIP report runs fine individually, but when I add it to a dashboard and preview the dashboard. Nothing shows up. P…
-
customize standard reportSummary: Hello everyone, Can you tell me how I can find out which standard report is associated with this view in the purchasing module > purchase requisitions? I've tri… -
Default moduleSummary: I'd like to know if it's possible to change the home page when entering the ERP from the Welcome Home page to a different one. For example, I want to display th…
-
Purchase order pre-processing days in OTBISummary: Content (please ensure you mask any confidential information): We are using the Purchase Order Pre-processing days metric in my OTBI report. We are using this c…
-
How do I convert the field Time.Month from CCYY / MM to just show the month?Summary: The Time.Year fields just displays the year The Time.DayofMonth fields just displays the day The Time.Month field displays the year and month. I need the Time.M…Mark Stoker 62 views 11 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM -
OTBI - Job Application direct URL in OTBIHi Team How to get the candidate's job application URL in OTBI?
-
Service Account not able to report on FeedbackSummary: We have a service account that we use for reporting purposes in OTBI. Typically, this account is able to pull accurate data across all Business Units. We discov…Megan Obiedzinski 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Which subject area.column or BIP column is for rate name in benefitsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 14 views 0 comments 0 points Most recent by desirae_coleman Reporting and Analytics for HCM
-
Records missing in OTBI Report for Purchase RequisitionsSummary: We in the process of creating a OTBI report for a customer and when we try to query all requisition data irrespective to the type( external/Internal) , all stat… -
Generate data on OTBI report using Costing - Cost Accounting Real TimeWe have a requirement for a custom OTBI report that uses Costing - Cost Accounting Real Time. This report should be executed only by a specific custom role - XYZ that is…
-
How can we add Rehire column status in OTBI report? Is there any filed is there ?Summary: In a report we need to add rehire column status but there is no field to add this in OTBI report Content (please ensure you mask any confidential information): …
-
AD_APPLIED_Patches Patch TypeSummary: The AD_APPLIED_Patches "Patch Type" column has three different types - 'Maintenance-Pack', 'Patch-Set', and 'Snowball'. What are the differences between these t…
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …Sheetal VBCS 21 views 0 comments 0 points Most recent by Sheetal VBCS Reporting and Analytics for ERP
-
Shipment Details To Costing JoinsSummary: Hello Team, i need to join the wsh_delivery_details with cst_cogs_details table but could not find any joins. Can some one please help on this? Content (please …
-
Navigate to the Connections Web Page from OTBIHi, is it possible to create an interaction in an OTBI column to link to the Connections page of a specific employee? I've tried passing the Profile ID parameter but doe…Francesco Cerioni 21 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there any SQL to help me identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
Workforce Performance - Performance Rating Real Time is not fetching ex-employeesSummary: "Workforce Performance - Performance Rating Real Time" subject area is not showing any ex-employees when i try to see their performance document info. When i ch…
-
otbi calculation only displaying whole numberSummary: Calculation is not showing the correct actual number (incl. decimals) Content (please ensure you mask any confidential information): Hi All Unless I'm doing som… -
Oracle FDI: Predictive Analytics for attritionsSummary: In FAW/FDI , any examples for predictive analytics for exit risk using HR Core subject areas? We see diversity analysis in demos but there is no catalog exists …
-
Need help finding OTBI Reports in Oracle Financials. List of report names provided in Summary.Trend indicator DSO(day’s outstanding) o Average days outstanding by month Average Invoice Day’s Current Average Invoice Days Overdue Average Invoice Dollars Current Ave…
-
AbsenceTimeEntryPVO - AncAbsenceType missing some valuesSummary: AbsenceTimeEntryPVO - AncAbsenceType missing some values that exists in base table HWM_TM_REP_M_ANC_ATRBS_V Content (please ensure you mask any confidential inf…Prakash Maram 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Does the oracle supports the Asset depreciation calculation based on Original cost as well?Hi Team, Business has a requirement to have the Depreciation calculated based on Current Cost as well as Original Cost so as to show them as comparison in their Annual R…
-
Shipment Details To Costing JoinsHello Team, i need to join the wsh_delivery_details with cst_cogs_details table but could not find a
-
Query to get Requisition and Standard PO details for the respective BPASummary: Query to get Requisition and Standard PO details for the respective BPA Content (please ensure you mask any confidential information): We are developing report.…