OTBI
Discussion List
-
OCI: Infrastructure utilization statsHello Team, Please guide on how to generate the following reports Infrastructure utilization stats Including for the peak times - store opening and closing We want to ma…Wale Odusanya 11 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration -
Transpose rows to columns for RatingsSummary: I want to show the ratings of two specific performance document section names in columns. I named the header like the section name. I used a "CASE WHEN" stateme…
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …Noelle Bartlam-Oracle 6.5K views 24 comments 5 points Most recent by Prosenjeet Bit Reporting and Analytics for ERP
-
Purchase Orders Number and Requester NameSummary: What subject area to be used to create a report showing PO number and the requester name from the PO line. Content (please ensure you mask any confidential info…Ahmed Maher Kadeh 163 views 2 comments 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM -
Is it possible to create an OTBI report that will show payment details by payment date and employee?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Chris West 41 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Rows repeating with different values though it's not available in the Front end under Customer SiteSummary: Hi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a …Rahul Kumar Gupta.-Oracle 21 views 2 comments 1 point Most recent by Daniel S.-Oracle Receivables & Collections -
Multiple Values in PIVOT tableSummary How to have multiple values in Pivot tableContent Hi I want to have a pivot table where i want to show the Competencies in measure with competency type as Column…Jagdish Varadraj 55 views 3 comments 0 points Most recent by Krishna_Vellela525 Reporting and Analytics for HCM -
Requisition Line DFF segments not populating in the Purchase Requisition PDF reportRequisition Line (DFF) not populating in the Purchase Requisition PDF Report layout (without datamodel report) We are using investment segment number under attribute19 a…
-
Does anyone have the SQL tables that define the BPM Journal Approval Workflows?Summary: We're trying to track the setting within the Journal Approval Workflow that disallows the JE creator from being an approver to support SOX audit controls Conten…Patrick Bonahoom 82 views 5 comments 0 points Most recent by Patrick Bonahoom General Ledger & Intercompany -
Upload mt942 file format importing bank statements in Oracle Fusion??Summary: Upload mt942 file format importing bank statements in Oracle Fusion Simple question If we can to upload this file format MT942 ??? Now we need to implment the 2…Christian Leon 131 views 2 comments 0 points Most recent by Christian Leon Payables, Payments & Cash Management -
Fusion HCM Table Column to fetch "New Hire Status"Please guide us with Table.Column to fetch "New Hire Status" information for an employee. PFA image for UI screenshot.Ranganatha_CV 41 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Not possible to use the phase/state name joining other subject area in OTBI analysisHi all, We are trying to create an Analysis in OTBI with Recruiting data. For this, we are joining the "Recruiting - Recruiting Events Real Time" and the "Recruiting - R…
-
Not receiving email notifications for Invoice approvalsSummary Not receiving email notifications for Invoice approvalsContent Hi All, Not receiving email notifications for Invoice approvals Thanks, Dev Thota. Version 20CDevendra Thota 47 views 3 comments 3 points Most recent by Unnati Mandhare Payables, Payments & Cash Management
-
Pre-Active and Post-Active Details OTBI subject areaSummary: Pre-Active and Post-Active Details OTBI subject area Content (please ensure you mask any confidential information): Hello Experts, I'm currently using the OTBI … -
How to duplicate a DashboardI need to duplicate and modify an out of the box dashboard: CIP Account Analysis. How do I duplicate it and save it, when I try to do so, I am unable to edit components.erpexpert03 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
'Sort Column' doesn't workI created this pivot table but seems like function 'Sort Column' only works for 'Person Number' column which is all numbers. I'm looking for sorting report by 'District'…Yiming Xiong 11 views 4 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
Is it possible to use CASE to replace 4712/12/31 with CURRENT_DATEContent (please ensure you mask any confidential information): I'm using the Compensation - Salary History Details Real Time to return the "Salary Details"."To Date" fie…Joe Dorrian 103 views 3 comments 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM -
Custom ESS Audit ReportSummary: I am trying to find instructions on how to build a report that will contain all ESS transaction history (before and after data). Could someone please assist on …Pamela_Diaz 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Tabla de Oracle Cloud para sacar el bill-to y ship-to location del proveedorDears , Please help me with the Oracle Cloud Table to get the bill-to and ship-to location from the supplier.
-
Specializations not pulling in Enrollment typeSummary: I pulled a report for Learning Assignments (To match the Learning Assignments Screen that summarizes a Team Members Learning Assignments) The screen shows the s…THawkins_LGI 21 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Ljava.lang.Object; is passed when multiple values are seleted in parameter in oracle BIP reportSummary: Hi Everyone, We have created a custom BIP report that will trigger the OIC integration from the Data model. We are passing a few parameters to the report. One o…
-
OLC - Completion Certificate Defaults allow only single templateSummary: Existing Completion Certificate Defaults allow only single Certificate template for the all course,and we don't have any option to set Completion Certificate at…
-
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi…Andy Gough 2.4K views 19 comments 14 points Most recent by Khalid Mahmood Reporting and Analytics for ERP -
Embedding Dashboard onto Tile - Application Role list incompleteSummary: Hi all, I am embedding some BIP reports onto tiles and have a couple of questions regarding the application roles in this step - This list is incomplete e.g. Ac…Ian.Gooderham 11 views 1 comment 1 point Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
All AR transactions excluding vat and remaining balanceSummary: We need a report showing all AR transactions excluding vat and remaining balance including vat as at a date. If there is no remaining balance no need to be in t…
-
Supplier Invoice Attachment Downloadable Link in BIP Reports to User with No AP AccessHi All, We have a client requirement where limited Users can have AP Access (Edit and View) but there n number of Users(Purchase Requisition Requester) will be running t…Abhijeet Tamoli 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Seeded data models renewal /shared/Human Capital Management/Workflow NotificationsSummary: We have compared with demo environment that we have old DM and templates in /shared/Human Capital Management/Workflow Notifications. How we can get latest /shar…
-
OTBI Report that includes oustanding BalanceI am trying to build an OTBI report for customer ATR transactions including outstanding balances (Remaining Balance). But I couldn't find out the customer Outstanding Ba…jgrahamavanti 81 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections