OTBI
Discussion List
-
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 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 213 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 1 view 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 352 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
-
How to set the Manufacturing Plant Parameter for Default Label Template?Summary: How does one set the Manufacturing Plant Parameter for the Default Label Template? In other words, what value specifically does one enter into that field? Is it… -
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…ndryden 359 views 9 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
What is the impact of not Assign Financial Categories to the Natural AccountsOne of the prerequisites for implenting a reporting tool such as OTBI and FDI , is to assign financail categories to the natural accounts. What is the impact on not doin…Omran Zeaiter 31 views 4 comments 0 points Most recent by Rafa Gutierrez-Oracle General Ledger & Intercompany
-
Report to extract initiatives associated to Learning ItemsHello all, We're trying to create a report which should extract for each learning item (specialization, course, offer etc) the initiative(s) created and its status (acti… -
per_personSummary: We could see lot of system users are exists in oracle fusion. We would like to build a report to identify only the actual users in oracle fusion. FUSION_APPS_AM…Alexander W 51 views 10 comments 0 points Most recent by Alexander W Reporting and Analytics for HCM -
How to add Reports shortcuts in Redwood UI?Summary: How to add Reports shortcuts in Redwood UI? In the classic UIs we had a drawer to provide quick access to reports on each functional area, such function is not …