OTBI
Discussion List
-
How to get Questionnaire Answers on a Single Row in OTBISummary: Create an analysis with Checklist questionnaire answers/responses on a single row in the analysis Content (required): I have created an analysis using the Workf…Denise Izzi 1K views 24 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
PVOSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
How to modify the 'Action Required: XX Expenses Need your Attention Email' from Expense DigestSummary: We are looking at implementing the Expense Digest functionality to remind users that they need to create/complete their expense reports. We are trying to locate…
-
Why are some column headers clickable links in my OTBI report? What is the functionality of these liContent Hi, I would like to know why some of the column headers in my OTBI report are clickable links and others are not. I would also like to know the purpose of these …
-
How to fetch the contract end date of a future contract extension using OTBI?Summary: Hi All, We have a requirement to fetch the Contract End Dates of contract extensions that have a start date in the future. OTBI only seems to fetch the Contract…User_2025-02-11-06-38-03-841 311 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
Payroll administrator is unable to see records updated by Fusion HCMWe have an analysis created using subject area Payroll - Personal Payment Details Real Time. I can see all records having been updated by any user but our Payroll Admini…Deana Wittman 23 views 3 comments 0 points Most recent by Nathan CCC 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.7K views 8 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
How to identify hires as Internal or ExternalSummary: Using OTBI, I would appreciate recommendations on how to identify hires as either an Internal or an External hire. Thanks! Content (please ensure you mask any c…
-
Manage Production Calendar Exceptions Calendar TablesI am trying to find the table that saves the registries for shifts exceptions on maintenance production calendars in Oracle Fusion in order to use it for reporting in OT…
-
OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget DataSummary: OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget Data Content (required): Having successfully loaded budget data into Financials fro…User_2025-02-10-15-12-48-631 296 views 4 comments 0 points Most recent by Global Customer Support | ASE-Oracle Reporting and Analytics for ERP
-
End User gets the option of EDIT for custom OTBI reportSummary: Hi Team, We created and OTBI report using General Ledger -Journals real time subject area, In the permissions window we have given full access only to BI admini…Naga Hari Krishna P-Oracle 21 views 7 comments 0 points Most recent by Naga Hari Krishna P-Oracle Reporting and Analytics for ERP
-
Update of Invoice Landing Page to add custom infolet/infotileHello, The requirement is to update the Invoice Landing Page to add custom infolet/infotile. We would like to verify if this is feasible. Navigation: Payables > Invoice …Mark Llasos 21 views 4 comments 0 points Most recent by Vasu Gurunarayana Chinni Payables, Payments & Cash Management
-
Filter OTBI prompts to only certain criteriaI created a Dashboard for our Learning team, which includes a Course tab, as well as a Specialization tab. The analyses used in each tab filter for the appropriate Learn…
-
Does BICC query returns live data?Using the 'EXTERNAL" keyword, does the following BICC query returns live data from Oracle ERP? or uses an offline extracted source? select distinct TransactionEntitySour…SHAHRAM SALAMI 12 views 0 comments 0 points Started by SHAHRAM SALAMI Reporting and Analytics for ERP
-
HR Analyst/Specialist - OTBI Report w EarningsSummary: HR Analyst/Specialist - OTBI Report w Earnings Content (please ensure you mask any confidential information): We have HR Analyst/Specialists that need the abili… -
Need report answers to an assessment that has both single choice and open ended questions?We created an assessment in Oracle Learning as a survey and needing to pull the data out. I am having trouble getting a report to pull all the answers in mass. Here is a… -
User Preferences in OTBISummary: Is there a subject area to report on user preferences under "My Account" in OTBI? Would this area report the same data as the user's "Correspondence Language" u…
-
Procure To Pay real time Subject Area issuesSummary: Need help to triage Procure To Pay real time Subject Area issues Content (please ensure you mask any confidential information): I am currently validating the da…
-
OTBI Dashboard to search purchase orders and drill down to view purchase order detailsSummary OTBI Dashboard for Line of Business Users or AP Specialists to search purchase orders and drill down to view purchase orders using deep linksContent Purchasing h…
-
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl…Julian Challenger-Oracle 42.8K views 95 comments 120 points Most recent by Dave Chudzik Reporting and Analytics for HCM -
How to report on previous person name in OTBI?Summary: I want to create a report in OTBI, that will show changes of person name - current name and previous name. Content (required): I tried Person Names/Person Names…
-
Issue with Retrieving "Workforce Scheduling - Workforce Schedule Real Time" subject area in OTBIHi , We have a client requirement to identify the scheduled number of working days using OTBI. For this purpose, we are utilizing the subject area: Workforce Scheduling …Nithin Nannuri 13 views 0 comments 0 points Started by Nithin Nannuri Reporting and Analytics for HCM
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…Nithin Nannuri 26 views 2 comments 0 points Most recent by Nithin Nannuri Reporting and Analytics for HCM
-
What is the SA to use for Goals' Published Flag ?Summary: Hello, We need to display in an OTBI report the Performance Goals along with their Shared and Published flags. We are using Workforce Goals - Goal Status Overvi…MariaStanciu 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
RVIE Report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) Not Showing Any InvoicesHello everyone, I’m currently facing an issue with the RVIE report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) in OTBI. When executing the report for… -
OTBI Dashboard passing prompts with url link.Hi, I am creating a OTBI dashboard and i want to generate a link with an url which would be passed through tthe prompt directly. i tried this link but it did not work…MYassikaya 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
R13.x CX OTBI Subject Area to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX OTBI subject areas to database lineage mapping and security roles. Content This spreadsheet is published by Oracle OTBI Development.…Noelle Bartlam-Oracle 3.7K views 15 comments 11 points Most recent by Sachin Bhadange Reporting & Analytics for Sales
-
Pick Confirmation by Work Order - Trying to locate the pick time on WO'sSummary: Work Order Release Date: KnownExisting Report Location Date/ Time Stamp of PickConfirmation by Work Order: Unknown Report Location ???? Date/ Time Stamp of PO C…
-
Standard functionality to check Purchasing staff workloadSummary: Standard functionality to check Purchasing staff workload Content (please ensure you mask any confidential information): Do we have any seeded Oracle purchasing…