OTBI
Discussion List
-
'Critical component' attribute not found in OTBI, how can we enable this to report on?Summary: we need the ability to create reports/analysis and search for items and the critical component attribute, however i cant see this field in any subject area Cont… -
Payment details are missing using OTBI Payables Invoices - Transactions Real Time & Payables PaymenSummary: Payment details are missing using OTBI ( Payables Invoices - Transactions Real Time & Payables Payments - Payables Payments - Disbursements Real Time" ) the bel…
-
Transaction Console Subject AreaGood Day Experts, May I know what subject area to use to get processes from Transaction Console? The following are the process name: - Manage Salary - Change Personal In…JMLMIII 111 views 8 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for HCM
-
How to add filter to obtain prior financial period transactions?How do we create a filter on an OTBI analysis to return the prior financial period's transactions based on current date? Requirement: We need to schedule a report to del…Elaine Hendry 21 views 3 comments 0 points Most recent by Elaine Hendry Reporting and Analytics for ERP
-
Display Latest Approver in Custom Payables InfoletSummary: Hi All, Currently, I have created a custom Payables Infolet, in which I added the "Approval Status" and "Approver" information. However, the application display…Ucup Maulana 31 views 1 comment 0 points Most recent by Cosmin Nadolu-Oracle Payables, Payments & Cash Management
-
Access BIP Report from Oracle AI Agent Studio using Rest APISummary: Hi I want to get requisition approval history of pending requisition in Oracle AI Agent Studio. and for that i created BIP report from workflow tables and tryin…Mayank Agrawal 608 107 views 2 comments 0 points Most recent by Mayank Agrawal 608 Self Service Procurement
-
OTBI error when running reportSummary: Hi all, Is anyone able to help me understand why this error message is being displayed when a HR user tries to run this report showing details of a particular e…
-
APISummary: Hi Expert, How to get the ( additionalInformationDetailsUniqID)? I have only URL and Offer ID how shall i get the additionalInformationDetailsUniqID? /hcmRestAp…
-
Help Needed: REST API Endpoint for Retrieving OTBI Reports in Oracle Analytics Cloud CRM DemoI am working with an Oracle Analytics Cloud environment integrated with Oracle CRM SaaS (demo instance at fa-etaq-dev13-saasfademo1.ds-fa.oraclepdemos.com). I want to us…srikanth gollapally 31 views 0 comments 0 points Started by srikanth gollapally Reporting and Analytics for ERP
-
Drill Down Functionality in OTBI DashboadSummary: Hi Team, We have a requirement to create an OTBI dashboard with two sections 1. Account balances of YTD,MTD Vs Budgets of group of accounts where the balances s…
-
Enrollment Coverage Through Date in the Benefits subject area is showing 12.31.4712Summary: When creating a open enrollment report for 2026 using Benefits - Enrollments Real time, Enrollment Coverage Through Date is 12/31/4712. Because of that it's sho…
-
How to identify records in ASSIGNMENTNODE PVO that do not appear in Employee's History?Summary: When using the ASSIGNMENTNODEPVO, I see records for employees that I do not see in their history in HCM. For example, an employee resigned and this was entered … -
Report Output data getting spit in two rows in excel file due to line breakageSummary: We have an OTBI report based on an Analysis where the Data Model is also using Analysis. In the data, there are line breaks within certain fields. When exportin…Nikhil Kubba 123 views 5 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to add a URL on the Sales Order page in Fusion to open a BI report?Summary: We need to add a clickable URL on the Sales Order creation page in Oracle Fusion Order Management that opens a BI report in a new webpage allowing them to run t…
-
Duplicated records on OTBI Report linked to different assignments on Person dataSummary Duplicated records on OTBI Report linked to different assignments on Person dataContent Duplicated records on OTBI Report linked to different assignments on Pers… -
OTBI report for role , Security Context & Security context Value access assigned to userSummary: Creation of OTBI report for role , Security Context & Security context Value access assigned to user Content (required): HI Team, We have one requirement to cre…Rohit Kumar Singh 472 views 9 comments 1 point Most recent by Nathan CCC Reporting and Analytics for HCM
-
Job Change Report - Assistance Adding Two new AttributesSummary: I have a Job Change Report but I am having trouble adding columns to looking for changes in The Full-Time/Part-Time Status and the Salaried/Hourly status. Any i…Darrin N 13 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Process learning records is not fetching the OTBI analysis reportSummary: Created learning initiative with analysis report and scheduled the Process learning records. But it is not assigning the specialization to the new hires. Showin…
-
OTBI Column to fetch change Order Amount on Procurement - Pending Change Orders Real TimeSummary: OTBI Column to fetch change Order Amount on Procurement - Pending Change Orders Real Time Content (please ensure you mask any confidential information): Hi Team…
-
Date format in OTBI PromptSummary: How to change prompt values from datetime to date. Instead of "11/12/2024 00:00:00" I want "11/12/2024" Content (please ensure you mask any confidential informa…
-
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 22 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…