OTBI
Discussion List
-
Issue: Fully Paid invoices need re-validationSummary cXML invoice are fully paid but in needs re-validation status.Content Hi All, Need help to understand what could be the possible reasons to have some of the cXML…Jain, Ankur 43 views 9 comments 0 points Most recent by JOEL DSILVA-Oracle Payables, Payments & Cash Management
-
Oracle Fusion-Manage Allocation Formulas- Complex formulas to allocate fees calculated based on reveSummary I want to know what the most effective approach would be for automating fee/royalty calculations for different contract agreements.Content I am trying to help st…User_2025-02-10-23-58-22-465 101 views 2 comments 0 points Most recent by Rohan Kamat Reporting and Analytics for ERP -
Can I enable guest access to OTBI AnalysisSummary I have an OTBI analysis and I would like to access that analysis using a guest login in OTBIVersion 20CV Pandalai 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Conditional formatting in Logical SQL OTBI reportSummary Conditional formatting does not reflect in OTBI report where Logical SQL is usedContent We have a requirement where we had to write a logical SQL query to show p…Akash Kiran Jana 62 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTL Approved time cards details with Reported hours and Calculated Hours BI Report QuerySummary OTL Approved time cards details with Reported hours and Calculated Hours BI Report QueryContent Dear Team, We need Oracle Fusion OTL Approved time cards details …VenkatReddy Pulichintha 879 views 4 comments 0 points Most recent by VenkatReddy Pulichintha Reporting and Analytics for HCM -
I need to get sysdate-effective_start_date in OTBI reportSummary I need to get sysdate-effective_start_date in OTBI reportContent I need to get sysdate-effective_start_date in OTBI report which function should we use? Thanks, …Pradvin Prabhakar 32 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
In which Subject Area/ Table holds Vertex Local Withholding Tax Rates Tables informationContent Hi All, Oracle provided Vertex Payroll Tax Series document. In that we need to fetch "Vertex Local Withholding Tax Rates Tables" information. Can you please sugg… -
Scheduling Report to Respective Line ManagersSummary Scheduling Report to Respective Line ManagersContent Hi Team, We have a requirement that respective line managers should receive a report on weekly basis about p… -
Exporting attachments and completion certificatesSummary Exporting attachments and completion certificatesContent We are moving from Taleo Learn to OLC and we need to export the attachments from external trainings and … -
Need inputs to hold the Received Date (Benefits)Content Hi All, In which Subject area/Table holds "Received date" value. Navigation: Benefit Administration-->Enrollment-->Query an employee-->Pending action Items-->sel… -
Risk Management Users with Access Violations by Control ReportSummary Lists users that have violated a specified control.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and pdf example o…Stephanie Golly-Oracle 122 views 1 comment 2 points Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Loaded Forecast for star items in CTO flow, but in supply planning the forecast was not getting consSummary Customer wants to load the forecast for star item in demand management and validate the forecast consumption happening at Model.Content Customer wants to load th…Sreelekha P-Oracle 66 views 2 comments 0 points Most recent by Sreelekha P-Oracle Supply Chain Planning and Collaboration -
Performance Tasks measures by top departement display wrong valuesSummary Create an Analysis to display measures for performance tasks/Top level DepartementContent Hi gurus, I would like to build an analysis that will allow me to displ…User_2025-01-28-23-51-35-873 18 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Risk Management Intra-Role Violations by Control ReportSummary List of roles that contain violations within itself for a specified control.Content * Download the zip file attached to this post * Unzip and you'll find 2 catal…Stephanie Golly-Oracle 76 views 1 comment 1 point Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Risk Management Access Violations within a Single Role (Intra-Role) ReportSummary List of roles, users and conflicting access points with conflicts by control. Only roles that contain violations within itself are listed.Content * Download the …Stephanie Golly-Oracle 129 views 1 comment 2 points Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Performance Dashbord to ManagerSummary Add deep link of employee's performance form to a reportContent Hello Is there an option to add to a report (BIP or OBIE) to add to each employee deeplink to his… -
Reporting Folder StructureSummary People in the business keep dragging and dropping the folders by accidentContent Good afternoon all We have an ongoing problem with people within our wider busin…Dawn Cawston - CPS 32 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM -
Bar graph drill down filtered on dateSummary Bar graph drill down filtered on dateContent I have built a bar graph that captures disclaimer status by action date. The drill down takes to a different OTBI re…User_2025-02-10-08-27-16-805 27 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Prior manager issue in OTBISummary Prior manager issue in OTBIContent I have created analysis with Assignment Event Real Time subject area and manager name' in assignment event details folder i ha…Reddykrishna Chidella-Oracle 35 views 2 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM -
How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DaSummary How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DashboardContent Hi Team, I want to move OTBI Report options (Ex…Mahendra 58 views 8 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
A parent for this record wasn't found. Use any of the four supported key-resolution systems to supplSummary While importing a Worker.dat file via HDL i'm getting the error : A parent for this record wasn't found. Use any of the four supported key-resolution systems to … -
OTBI help with a Performance ReportSummary OTBI help with a Performance ReportContent Hello, I have built a custom OTBI report with Performance Task Status and Performance Task. For the Final Feedback, si…Tony Puentes 68 views 3 comments 0 points Most recent by Tony Puentes Reporting and Analytics for HCM -
Which subject area has the SUI Employee Rate in Oracle HCM?Summary Please see the navigation for getting this rate in UI.Others > Setup and Maintenance -> Tasks Icon on righthand side > Search -> Define Legal Entities for Human …pratyushak 46 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
ORC analysis - Time to Approve?Summary I am looking for a way to report on the time to approve a job requisition in ORC using OTBIContent Hello, I have a need to report on the Time to Approve an ORC j…User_2025-02-04-23-22-13-274 84 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Worker Age in Workforce TrendsSummary What to use to calculate age in Workforce TrendsContent Hello! I've been calculating the Age Bands by using a formula to gather the difference between the date o…