OTBI
Discussion List
-
Consolidated List of OTBI and BI Publisher Reports Posted (10 February 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * Bradford Factor * Extract Manager Hierarchy…Julian Challenger-Oracle 319 views 8 comments 5 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to calculate Age in BI AnalysisSummary What is the formula needed to calculate age within a BI Analysis?Content I am trying to complete a report to calculate the age levels of employees. I pulled in h…User_2025-01-28-20-43-56-568 207 views 6 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 331 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
source table for last acceptable promised dateSummary: Unable to find details of last acceptable promised date (change from data) for PO schedule line . Content We have a requirement to present last acceptable promi… -
Export entire dashboard from a custom pageContent Hi Guys, I see that is possible export the entire dashboard from the OTBI by clicking on the Option export to excel. But, my question is: Is it possible export t…Giuseppe Iacono 216 views 18 comments 3 points Most recent by User_VLBBP Reporting and Analytics for HCM -
Can we display DFF value in OTBI, Expense Transactions Real Time subject area?Summary: Display DFF value in OTBI Content (required): Hi, We have defined a contextual DFF segment in the standard Expenses DFF. This was setup as "BI enabled" (checkbo… -
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…Kalyan Reddy 46 views 3 comments 0 points Most recent by Fabiana De Arruda Reporting and Analytics for SCM
-
Customers real time not giving correct outputSummary: Not able to create Customer Master Report. Customer and accounts are not mapped. Is this correct subject area to get customer info? Single Customer to joined to…
-
BI Publisher Bursting Email from Company Domain IDSummary: Hello Experts, We have a requirement to trigger emails from our company domain ID (@companyname.com) while triggering emails from BI Bursting. We don't want the…Gourabh Choudhary 151 views 3 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
Reporting the Career Development screenHi, I want to generate the data sql report on the My Team>>>Career Development screen. But I can't find the table where this information is kept. Can you help and share?…Cansel Karasoy 61 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Schedule Report to Run Prior Month/QuarterSummary: Currently, only a few HR members can run reports, no one outside of HR can. If they need a headcount roster or turnover, I would run the report for them. There …Ratha Sun 151 views 11 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Compensation Approval Chain in OTBI ReportSummary: How to view all managers who approved a compensation change? Content (required): On the front end I can see for each compensation change, a list of managers who…s_b 67 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is it possible to approve an order from a OTBI analysis?All orders are created directly in OM and they have a simple approval workflow. For the approval is critical to review the price components of each item. The problem tha…
-
Extracting Bookings History in Demand Mgmt - Customer Info requiredSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 52 views 8 comments 0 points Most recent by Avinash Erande Supply Chain Planning and Collaboration
-
Dashboard screen customizationI have a dashboard report that I have prepared with parameters and I want the parameters to look like the screenshot. I couldn't find how to make the background visually…Cansel Karasoy 21 views 7 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Overhead accounting rule at LOT levelSummary Overhead accounting rule at LOT levelContent Hi, We have overhead accounting rules at LOT level to include additional charges in the work order cost. We didn't h… -
Regular Temporary column from Workforce Management - Worker Assignment Event Real TimeSummary: There is no "Regular Temporary" column in the "Assignment Event Details" folder from the Subject Area "Workforce Management - Worker Assignment Event Real Time"…Chan Jun Yu 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Duplicate Departments when using Goal Status Overview Real Time Subject AreaSummary Duplicate Departments when using Goal Status Overview Real Time Subject AreaContent Hi Experts! Good day! We are having issues with duplicate departments. Is the…Raymund Jerome 44 views 5 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM
-
What can we do so that OIC applications do not use license limits?Hi, What should be done to prevent the versions created for the live and test environment from using license limits in the applications we develop in the OIC environment…Cansel Karasoy 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to extract Tax Classification (Party Tax Profile Controls) for all Customers?Summary: We need to update the Tax Classification of multiple customers, so we would like to first extract all existing data (which were uploaded using TaxImplWorkbookTe…Francine Gemora 92 views 2 comments 0 points Most recent by Ashwin M-Oracle Receivables & Collections
-
How to align 63 Report Fields in RTF Report TemplateSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 101 views 7 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Budgetary Control - Balances Real Time acting differently between two user with the same accessSummary: Two users with the same access are having different results using the Budgetary Control - Balances Real Time subject area. Content (required): We have two users…
-
Position hierarchy report prepared from Oracle AnalysisHi, I am preparing a position hierarchy report using an analysis report. How can I find the person in the next position of a position? RegardsCansel Karasoy 51 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Agent - would like to see why it failed to runSummary: Is there a way to see the reason for an Agent's failure? Content (required): When an Agent fails to run and deliver an Analysis, we can see that it Failed (unde… -
Control Infolet visibility on HCM Home page based on person GenderSummary: Control Infolet visibility on HCM Home page based on person Gender Content (required): how to control Infolet visibility on HCM Home page based on logged in per…Nirmal Ignatius 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Cloud Plan outputSummary Any inputs on how to pull the entire plan output in SCM cloudVersion 20 cuser10955442 41 views 4 comments 0 points Most recent by Shivanagowda Sannagowdar Supply Chain Planning and Collaboration
-
Query to get Error Message display on the report from Fulfillment Lines for Fulfillment ReportSummary: We have business requirement to get this Error Message into the existing fulfillment report (Order management can't schedule the item because supply isn't avail…kalyan gade 222 views 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Valid Grade Report-Multiple Grades on jobs auditSummary: We are trying to run a report on all the active valid grades associated with a job, to audit and clean up any that may have multiple grades associated with the …Tammy Hemmingson 41 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM