OTBI
Discussion List
-
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 123 views 8 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM -
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…
-
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 14 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 18 views 3 comments 0 points Most recent by Rica Cruzado 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 …Elaine Tsoi 7 views 2 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
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…Pinky Noel 5 views 1 comment 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
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… -
INVALID_VENDORSummary Expense report invoices rejected due to reason INVALID_VENDORContent Hi Team, I am unable to create invoices for expense report which are Approved and Audited, s…
-
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 44 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…
-
SQL query or table for Project Cost Transaction AccountingSummary: Hello, Please help to have query or table to get the accounting details from Project Cost Transaction where we know the transaction number. Content (please ensu…
-
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 7 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 15 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 242 views 9 comments 2 points Most recent by Juan C. Reporting and Analytics for HCM
-
What subject area has this pricing error data in OTBI reportI want to fetch this pricing error data in OTBI report and could not find the sales order errors in any subject area.
-
Due date not showing up for specific learning items in Workforce Learning - Learning ManagementI'm creating a custom report and I'm able to find all data. However, for some specific records the due date is not populated. I think this has to do with the fact that t… -
dashboard for CXOSummary: is there any dashboard available by delivered for HR basis of AOR, they can data trends for all modules including core HR , Absence , Talent including learning …Anil Sangwan 13 views 3 comments 0 points Most recent by Anil Sangwan Reporting and Analytics for HCM -
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…Aloka Bhattacharya 1.9K views 9 comments 1 point Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Fetch competency catalog from subject area "Workforce profiles – Library objects Real time”Summary: Hi experts, we're trying to fetch the whole competency catalog using an OTBI analysis in the subject area "Workforce profiles – Library objects Real time". The …
-
Report to compare Supplier encumbrance + spend?Summary: Has anyone had luck creating a report of total encumbrance (PO amount) against supplier + total spend against supplier? I tried utilizing OTBI Purchasing Real t… -
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 209 views 5 comments 5 points Most recent by UchihaItachi Reporting and Analytics for ERP
-
Using Filtered lists in User GroupsSummary: As part of the transition to Redwood Admin experience, we are working on cleaning up and "copying" our Access Groups over to User Groups (UG). It has been sugge…