OTBI
Discussion List
-
Agentic AI Usage tokens consumption reportsSummary: Hello. Any advice on where to find the catalog contents for the Agentic AI Usage tokens consumption reports? I believe there are some catalog files in customer … -
Currency conversion in OTBIContent When using the Expenses - Expenses Transactions Real Time subject area, is it possible to get the currency conversion of an expense report to the users default/p…
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…Yaniv 765 views 12 comments 1 point Most recent by Naryman Ismail-Oracle Reporting and Analytics for HCM
-
Which privilege will allow to view PO and BPA information without license triggerSummary: Please let us know Which privilege will allow to view PO and BPA information without license trigger. We had a custom procurement inquiry role having PO_VIEW_PU…
-
Customize / add new options to Selection Process Diversity delivered reportSummary: I'm hoping someone can help me understand how to modify delivered Selection Process Diversity analysis (I know I have to make my own copy to edit) that is part …
-
Fixed Assets – Asset Description Real Time report OTBIHi, We have identified an issue in the Fixed Assets – Asset Description Real Time report. It appears that the asset number is not being correctly mapped to the asset boo…
-
How to clear Data in Budgetary Control Application before loading data from EPM PlanningSummary How to clear Data in Budgetary Control Application before loading data from EPM PlanningContent We are running into an issue, we have pushed Budget data from Ora…
-
Report Name Change ImpactsSummary: We have some reports in OTBI & BI which have a prefix of a Company and the name is changed - just a letter - XYZ to XY1 - so can anyone advice on the below Do w…Sailajad 11 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
MISC code in OTBISummary: Is it possible to get the MISC code in OTBI? We need to build a report for 1099 since Oracle's 1099 capability is severely limited. Content (please ensure you m… -
Person Number column is blank when creating an analysis using Project Costing Subject AreaSummary: Wehave created a report using the Project Costing Actual Costs Real Time subjectarea. In that report we have selected the Person Number and Person Name fields,b…anandg465_cshs 1 view 3 comments 0 points Most recent by anandg465_cshs Reporting and Analytics for ERP
-
View-only access to Purchase Agreements in Redwood without PO_VIEW_PURCHASE_AGREEMENT_WORKAREA_PRIV?Summary: Hi everyone, Has anyone successfully set up view-only access to Purchase Agreements in Redwood without granting the “View Purchase Agreement Work Area” privileg…
-
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera…
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
Extract the transaction console comment in OTBIHello, I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console. Specifically for the termination quick action, in which …Sara Suleiman 21 views 3 comments 0 points Most recent by Sara Suleiman Reporting and Analytics for HCM
-
Is it possible to switch the display of an OTBI report to the Redwood view?Summary: I want the reports we create in OTBI to be displayed in the Redwood format. Content (please ensure you mask any confidential information): I want the reports de… -
DFF created in EXM_CASH_ADVANCES are not shown in OTBISummary: I created a Date DFF in Global Segments of Manage Descriptive Flexfields for Expense Reports , Flexfields=EXM_CASH_ADVANCES. I deployed the Flexfields and ran t…
-
OTBI - values turning to blank after more columns are addedSummary: I have built a report that combines two subject areas: Compensation - Salary Details Real Time and Payroll - Element Entries History Real Time The report is sho…Julia Kiszelewska1234 41 views 7 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
OTBI AP Invoice real time is not bringing information when it is the second subject areaSummary: I tried to merge 2 subject areas (Fixed asset and Payables transaction real time). The Fixed Asset information is bringing the right data, but when added the se…Pablo Schenquerman 21 views 3 comments 0 points Most recent by User_Q63UG Payables, Payments & Cash Management
-
Clicked metric is not available for reporting or data extraction in ORC CampaignsSummary of the Issue In Oracle Recruiting Cloud, the “Clicked” metric is visible and functions correctly at the campaign level in the user interface. However, this metri…alfredreyes1809 21 views 4 comments 2 points Most recent by alfredreyes1809 Reporting and Analytics for HCM -
Reporting on Roles and PrivilegesSummary: I want to report which employees have two custom roles in OTBI. When I report person number, name and role name column it reports out the correct data. However,…
-
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 44.3K views 96 comments 120 points Most recent by Jessica D Reporting and Analytics for HCM -
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives … -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 369 views 6 comments 0 points Most recent by Neha Thakre 2023 Reporting and Analytics for HCM -
cant show HR Representative in Otbi reportHello , I want to create a otbi report where i want to see my subordinates which is i am HR representative. I am the line manager of some employee and HR Representative …Mirza_Adeel 31 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to Fetch the PO Revised Amount in oracle fusionSummary: Hi Kindly Suggest the tables or provide any sample query to fetch the PO Revised Amount in Oracle Fusion Content (please ensure you mask any confidential inform…
-
Does Oracle Fusion Maintenance Cloud support offline mobile functionality for technicians?Summary: Does Oracle Fusion Maintenance Cloud provides any native mobile application with offline capability for technicians. Specifically: Is there any mobile app avail…
-
Payable Invoice lifecycleSummary: looking for any OTBI Analysis which provides AP Invoice lifecycle view. Content (please ensure you mask any confidential information): Version (include the vers…Anirban.sensarma 2 views 0 comments 0 points Started by Anirban.sensarma Reporting and Analytics for ERP
-
Tools>>Reports and Analytics Page is still not available in RedwoodSummary: Reports and Analytics Page is still not available in Redwood . By when this page will available in redwood ? Content (please ensure you mask any confidential in…NaveenBellam 2 views 1 comment 0 points Most recent by Dhilipkumaar-Oracle Reporting and Analytics for SCM
-
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…Sreeram V 6.2K views 11 comments 0 points Most recent by Nazir Hossain Reporting and Analytics for HCM