OTBI
Discussion List
-
Item extract issueSummary: We want to extract Item master data which is more than 4 million. Currently i have prepared BIP Report for extracting data but it seems due to huge count its no… -
Employees With or Without Goals Report - Missing dataSummary: Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With…
-
Guidance to optimize OTBI HCM Cross-SA Reports having static report filters1- Some Cross subject area reports may be costly in terms of response time, if they are not designed correctly. It is always recommended to use (i) at least one common d…Abhishek Dixit-Oracle 151 views 2 comments 4 points Most recent by UdayrajSingh Reporting and Analytics for HCM -
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH… -
Clarification on OTM transition from OAS to OAC and impact on integration usersSummary: Clarification on OTM transition from OAS to OAC and impact on integration users Content (please ensure you mask any confidential information): According to the …Stefano Di Nolfo 261 views 6 comments 0 points Most recent by Stefano Di Nolfo Transportation Management -
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
No results if no filter is appliedSummary: Hi, We have an HR role with access to a compensation OTBI report. In order for the results to be displayed, HR must filter by at least one BU. However, if I ass…
-
Seeking Solution: Account Hierarchy Roll-up Report for Leads, Opportunities, and Service RequestsSummary: Hello Community, We have a business requirement to build a comprehensive dashboard or report in Oracle Sales Cloud that provides a consolidated view of Accounts…Sudheer V-Oracle 12 views 3 comments 0 points Most recent by Sudheer V-Oracle Reporting & Analytics for Sales
-
Getting an error when trying to add another column in OTBI Rep for a DFFSummary: There is a custom field (DFF) on the Customer Sites (Receivables) which we are trying to add to an existing OTBI Report. After adding it to the report, getting …
-
Ship-to Site Number field is missing in the Receivables Transactions Real Time subject area for OTBISummary: I need to add *Ship-To Site Number field and I don't see it available under Receivables Transactions Real Time subject area. Please suggest if it's available in…Rahul Kumar Gupta.-Oracle 42 views 4 comments 0 points Most recent by Matt Lennon - Terillium Receivables & Collections -
OTBI not having any data for subject area Order Management - Price Adjustments Real TimeSummary: OTBI not having any data for subject area Order Management - Price Adjustments Real Time We do have discounts implemented but this subject area not fetching any…
-
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe… -
How to pass login user name dynamically in the OTBI Report nameSummary How to pass login user name dynamically in the OTBI Report nameContent Hi Team, We have an OTBI report called Direct Reportees of Manager and it's working as exp…Mahendra 500 views 11 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Review Item`s Perpetual Average CostGreetings everyone, Perpetual Average cost of an item can be reviewed through Review Item Costs⇒Review Transaction Costs. However, to review the Item`s cost for a longer…
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 92 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
Looking for the Checklist Task Sequence in the Workforce management Checklist Real TimeSummary: Looking for the Checklist Task Sequence field in the Subject Area Workforce Management - Checklist Real Time Content (required): We are looking to add the Check… -
Is it possible to add custom Tab in Analytics Infolet sectionHi All, We would like to verify if it is possible to add custom Tab in Analytics Infolet section. Our question is trigger because its not possible to add custom infolet …
-
How to control or restrict OTBI access?Summary: We need to control OTBI access from accidental deletion of a folder/report and moving reports from one folder to another from business users? Content (please en…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…Noelle Bartlam-Oracle 36.7K views 94 comments 56 points Most recent by JayanthP Reporting and Analytics for ERP
-
Building an OTBI report using OTL data. Can't find Project RoleSummary: We are building an OTBI report to show all timecard entered for the week. We are project based company so our timecards include Project and task information, in…Anjula Mittal 35 views 3 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
How to get output of Schedule child request "Create Accounting Execution Report"Summary: How to get output of Schedule child request "Create Accounting Execution Report" Content (please ensure you mask any confidential information): Ran Create accou… -
Audit Data for Custom Fields on Service RequestsHi, we currently have the following query: SELECT DISTINCT SR.SR_NUMBER, CATEGORIES.CATEGORY_NAME AS CATEGORIA_ATTUALE, OLD_CATEGORIES.CATEGORY_NAME AS CATEGORIA_PRECEDE…Martina Di Battista 1 view 2 comments 0 points Most recent by Martina Di Battista Reporting & Analytics for Fusion Service
-
How to create Cost List with List Price = Item Cost + X%Summary: We have a requirement to create a Cost list with List Price = Item Cost + X% dynamically. Content (please ensure you mask any confidential information): How to …
-
OTBI Subject area to get Project cost and accounting entriesSummary: Unable to get details of view accounting page from Project Costing - Actual Costs Real Time. Wanted to pull the Project cost transactions which are enabled for …Kalyani-Oracle 32 views 4 comments 0 points Most recent by Klaus Dimitri Zuidwijk Project Management
-
Required sql query or tables sales order approval rules under Manage Order Approval Rules task.We required SQL query or back end tables where the information of Order management workflow Approval rules stored. Task name: Manage Order Approval Rules. For example Ru…
-
OTBI display duplicates while query don'tHi everyone, We use OTBI to extract some data in Excel to feed an home-made FBDI requisition process. The report included 11 queties, linked by their record_number to ge…Francois Robineau 13 views 1 comment 0 points Most recent by Francois Robineau Reporting and Analytics for ERP
-
Print Talent ProfileContent I am creating a custom print of talent profile RTF Template and there are some sections that are only available to line managers but when an employee prints it s…Misbahul Khair 51 views 3 comments 2 points Most recent by Rishitha sravanya Reporting and Analytics for HCM -
Oracle fusion FDI in data actions How to provide the authentication for REST APII'm trying to get the invoice attchemnt url in FDI using data actions type HTTP API by call the REST API. but facing an issue to authenticate the REST API. We have enabl… -
Copied/Renamed OTBI Report Not Showing in Scheduled Process ListI copied an out-of-the-box OTBI report to my custom folder and renamed it. However, when I try to run it from Scheduled Processes, the report doesn’t appear in the list …