OTBI
Discussion List
-
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o…Volodymyr Faranosov 31 views 3 comments 0 points Most recent by Anil Sangwan Reporting and Analytics for HCM -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.6K views 31 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to report on Unsubmitted Timecards?Content Has anyone been able to produce a report showing which employees haven't yet submitted a time card in a given period? Any help would be much appreciatedUser_2025-01-28-05-35-00-925 141 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Use order date for order pricing not available in OTBI subject areaSummary: Looking for 'Use order date for order pricing' flag in OTBI Analysis Content (please ensure you mask any confidential information): We have recently enabled fea… -
Position trend real time Subject Area - how to find Position Incumbent?Summary: Hello. I'm trying to build a report of open positions and their previous position incumbents. Is it possible to create this report using a new subject area 'Pos… -
Different vision in OTBI than in UISummary: Hello We have moved to a Redwood theme in our UI but then our OTBI report look at change. It now looks very old school. Also please note that when we open it in…
-
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 121 views 4 comments 0 points Most recent by Nicolas-Vahman Reporting and Analytics for HCM -
Does transfer order line DFF appear on OTBI reports, BI enabled flag is not available on SegmentSummary: Does transfer order line DFF appear on OTBI reports, BI enabled flag is not available on Segment configuration Content (please ensure you mask any confidential …
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…Saher 97 views 3 comments 0 points Most recent by YashaswaniSrivastava Reporting and Analytics for HCM
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives …MandeepGupta 403 views 5 comments 14 points Most recent by Sudeep Doke Reporting and Analytics for HCM -
Procurement - Requisitions Real Time not display requistion requesterSummary: OTBI to cannot show requester name Content (please ensure you mask any confidential information): I am trying to create an OTBI report for Purchase Requisition …
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 121 views 8 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM -
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting…
-
Only access seeded reports and subject areas in OTBISummary: Client wants a role to allow them to access seeded reports and OTBI subject areas but not any fusion tasks. Is it possible? Can you please guide us?Amit Dey 11 views 2 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
Unable to create report using Workforce Management - Assignment Action Occurrence Real TimeWe have a custom role mapped to the Human Resource Specialist role, with a new requirement to grant access for creating reports using the Workforce Management – Assignme…Rica Cruzado 21 views 3 comments 0 points Most recent by Rica Cruzado Reporting and Analytics for HCM
-
Rational for the 14day record retention limit on successful HCM AlertsSummary: What is the rational why successful Alert records are saved to the tables for only 14 days? Content (please ensure you mask any confidential information): We wo… -
List of UI Labels effected with User Interface Text tool - renaming of labelsCustomer needs a list of effected UI labels (on pages/modules) when using the User Interface Text tool for renaming labels in Fusion environment. Is there SQL for me to …
-
INVALID_VENDOR for an Expense ReportSummary: INVALID_VENDOR is the reject reason for an Expense Report which includes in the ESS program(Process Expense Reimbursements and Cash Advances) . The employee for… -
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr…User_2025-02-10-16-28-01-402 40 views 7 comments 0 points Most recent by Anil Sangwan Reporting and Analytics for HCM
-
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…
-
How can we customize a learn role by giving access only to Learn OTBI reportsSummary: We have a requirement to create a learn administrator role along with country specific Area of responsibility which is working fine, but we need to restrict the…
-
How to give access to Learning reports onlyHello, Do you know if there are any privileges/ duties for Learning reports? We have couple of users (HRBPs) who need to see how many employees completed a specific cour…
-
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 2 views 3 comments 0 points Most recent by Sandeep_Hebbar Reporting and Analytics for SCM
-
Disciplinary and GrievanceSummary: I have a report meant to capture both active and inactive records for a specific value in the subject area of personal real time. Because the criteria is set to…
-
AP invoice specialist cannot access to OTBI analysisSummary: Hi Guru, We have following two roles for our AP users, The users who is assigned specialist role where not able to see any record from our AP analysis report 1)…CatCatY 11 views 5 comments 0 points Most recent by Niraj Kumar Payables, Payments & Cash Management
-
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …Rohan Fernandes 241 views 9 comments 2 points Most recent by Juan C. Reporting and Analytics for HCM