OTBI
Discussion List
-
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 61 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…
-
Learning Initiative not using most recent version of analysisHi, We have had an issue with initiative assignments based on analyses not running correctly since our golive in June 2024. Today we did a large batch training assignmen…
-
Where can we get the History of the Position for a report.Summary: I am trying to do a report for Position Details and trying to find the 'History' changes which can be found in the Position "Details" page just below the "Grade…
-
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 11 views 0 comments 0 points Started 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 …
-
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 …
-
PDF and doc / docx document types not supported as attachments to Expense ReportsSummary The expense report printed from the system using “Print Preview with Attachments” shows blank pages in place of the so called “unsupported” attachment formats (P…
-
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 11 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.… -
Is there any table which stores last email notification sent date for Requisition approvalwe need to display Last email notification date in our report so we wanted to check is there any workflow table which stores the details. we trayed to query this below t…Basavaraj Navalagi 41 views 3 comments 0 points Most recent by Basavaraj Navalagi Self Service Procurement
-
Few Absence records missing for an Employee in OTBISummary: Some of the scheduled absences are not showing up in the report. We cannot find June absence record but can see August absence record for the same person. Ran t…