OTBI
Discussion List
-
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 39 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 1 view 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 244 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 11 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 2K 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 211 views 5 comments 5 points Most recent by Naveen_CCC 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… -
SQL to fetch learning catalog profileSummary: In which database table(s) can I find the learning catalog profile ID and learning catalog profile number Content : Background information: In version 25D Oracl… -
Need to print the User Name on a Template; Need UserName from Global, HCM, or ASCMSummary: Need to print the User Name on a Template Content (please ensure you mask any confidential information): I am new to Oracle Fusion and FDI. I need to print the …SQLWrangler 2 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
AR seeded deferred revenue report without RMCS being used or how are you doing it?Summary: Is anyone aware of an AR seeded deferred revenue report without RMCS module being used. Content (please ensure you mask any confidential information): As we hav…
-
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b…Elizabeth Docherty 360 views 28 comments 0 points Most recent by Elizabeth Docherty Reporting and Analytics for HCM -
Annualized TurnoverSummary: Does anyone have a report for annualized turnover? I see questions from the past on this same topic and have not found one in the shared reports. The seeded fie…
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …Noelle Bartlam-Oracle 7K views 26 comments 5 points Most recent by User_DHINS Reporting and Analytics for ERP
-
Unable to find Employee and Manager comments in OTBI for Performance documentUnable to find Employee and Manager comments for Performance document in oracle fusion HCM. We are using Subject Area - " Workforce Performance - Performance Rating Real…priyanka_kumbhar2 31 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
table for address purpose and site related to customer in oracle fusionHi, table for address purpose and site related to customer in oracle fusion Regards C Rao