OTBI
Discussion List
-
OTBI report does not display data for a day because TC timezoneSummary: As per the Oracle white paper on Transaction Console, you can get up to 500 transactions in the downloaded csv file. It is a technical limitation that download …AmitSM 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Pending Action Items ReportSummary: I am attempting to create a report of all current pending action items in our system in OTBI. However, I seem to only be receiving completed action items and no…User_2025-02-11-20-55-10-551 51 views 8 comments 0 points Most recent by Sanskriti Gupta Reporting and Analytics for HCM -
Payroll - Calculation Cards Real Time FieldsSummary Trying to find two specific fields withing Calculation Cards Subject Area: Issuing Authority and Order Amount Payee.Content I am working on building a report for…
-
How to enable line of business users to search and view purchase agreements informationSummary: Content (please ensure you mask any confidential information): Customer is asking for how non procurement agents can search for POs, Agreements and Suppliers. T… -
I need help on my SQL for With and Without Goals ReportSummary: Hi, I hope someone can help me with my query. Only the employees "With Goals" are showing up. The employees "Without Goals" is not showing up in the report. I n…
-
How to Filter a Date Column by Another Date ColumnSummary: I have an OTBI analysis that is 3 subject areas. The goal is to show specific actions in Workforce Management - Worker Assignment Event Real Time, and then show…
-
Error Codes: OAMP2OPY:U9KP7Q94 - OTBI AnalysisSummary: We have a weekly Analysis that runs via Agent. After running many times without issue each week, we are getting these errors: OAMP2OPY:U9KP7Q94 - "An Unexpected…User_2025-03-07-06-07-08-189 1.4K views 8 comments 0 points Most recent by User_U5PJ2 Reporting and Analytics for HCM
-
OTBI reporting errors after 25B release - Error generating view. Error getting cursor in GenerateSummary: After the 25B release on May 17th 2025, many of our reports are now failing to run, and presents error below. Reports which are run return a mixture of differen…Ray727 479 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Benefits OTBI Subject Area for Plan ID, Coverage Amount and Age Grade Rate.Summary: Hi Team, I am working on the OTBI reports for benefits module. Kindly suggest me the subject area for below mentioned columns. Benefits Plan ID Coverage Amount …D.Ashok 11 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Competency proficiency reporting - employee and manager ratingSummary: Hi there, I need help where to find the Employee rating for Competencies. The Manager rating is located in this folder "Workforce Performance - Performance Rati…
-
Looking for PO line quantity column in Purchasing Subject AreasSummary: I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing R…
-
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 292 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 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…
-
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 12 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 …