OTBI
Discussion List
-
Retirement Target AssetSummary Retirement Target AssetContent Hello Team, Has any one worked on "Retirement of Asset" from Projects. I've gone thur few documents on Oracle Support and on Oracl… -
Expense MileageSummary: Expense Mileage Missing Fields Content (required): I am not seeing some of these fields when creating expense mileage on my expense Item page. Not seeing; Locat… -
Email From Address for Transportation IntelligenceSummary: Is there any way to configure the From Address for schedule reports/analysis sent from Transportation Intelligence? Content: We configured an Agent in the Trans… -
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D…
-
OTBI - Withdrawn Sickness output not displaying in Absence Real TimeI have built an OTBI report in Workforce Management - Absence Real Time, that I intend to use to report on sickness absence with a 'withdrawn' status. However, nothing i…
-
Financials Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Anand DN-Oracle 394 views 6 comments 3 points Most recent by Ajay Hareesh Reporting and Analytics for ERP
-
Red Flag indicator to display Failed Preventive maintenance Inspection ResultsSummary: We have a requirement for users to be able to identify which Preventive Maintenance failed an Inspection result. This information should be accessible either th…
-
SQL Query to Retrieve based on Customer ShipTo Site NumberSummary: Hi, I need SQL Query to Retrieve below data from Ship to Site Number OrigSysShipPartyId OrigSysShipPartySiteId Original System Ship-to Customer Reference Origin…Mahmoud9308 810 views 3 comments 0 points Most recent by Karun Jain-Oracle Receivables & Collections
-
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…Bernadette Dorris 163 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to convert bip report out format into JSON format by using e-Text templateDear Experts, I need to convert Bip report out format into JSON format by using e-Text template. Please send me the e-Text template and how to use that template with XML…Ravindr-Oracle 491 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Supplier AgingSummary: We want to develop a custom report basis on the payables aging as on date Content (please ensure you mask any confidential information): Is there any specific t…V.Bharath 41 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
OOTB Subject Area Partner does not OOTB field Preferred Contact NameSummary: Hi Experts, I am trying to create a simple OTBI Analysis report within Oracle Sales Cloud (CX Sales) SaaS. The OTBI Analysis report should show all Partner Orga…AparajitMalliJawaharBapu 11 views 2 comments 0 points Most recent by AparajitMalliJawaharBapu Reporting & Analytics for Sales
-
Inventory Reservations Query/ReportSummary: Need a report of the information seen in Manage Reservations and Picks (Item, Reserved Quantity, Document Number, Document Line Number) Content (please ensure y…
-
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
Condtional formating not working for standard fieldsSummary: Adding a conditional formating criteria does not work on standard fields but works fine for flex fields Content (please ensure you mask any confidential informa… -
Where can you find the meaning for the ASSIGNMENT_STATUS_TYPE_ID number?Hi, When running the below query, the table contains ASSIGNMENT_STATUS_TYPE_ID. This is a NUMBER value. Does anyone know where I could find the meaning of the value retu…
-
Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject areaSummary: Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject area Content (required): We have payroll balance data for an employ…
-
AOR Areas of Responsibilities in OTBIContent Hi All, Can someone help, which Subject area I can find Assigned Areas of Responsibility details in OTBI? Thanks, VijayUser_2025-02-07-19-03-14-525 1.2K views 11 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
How to pass Business Unit for Customer Site while creating Customers using Customer FBDI UploadSummary: We are trying to load Customers using FBDI (CustomerImportTemplate.xlsm) Content (please ensure you mask any confidential information): We are not able to find …Abhishek Sinha 131 views 3 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Permission - BI ReportSummary: We need an audit report with information about which user made the changes to the report's permissions in analytics.Mayara Fulquim 21 views 1 comment 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Is there any documentation available on using AND, OR, and groups in OTBI report filters?Summary: I am trying to set up filters in an OTBI report to pull a subset of employees for an assignment in Oracle Learn. I need to select a group of employees and then … -
OTBI does not show attributes standar that were created in Oracle CxSummary: Hello community! When creating an analyst in OTBI, and located in the object "Lead" missing the field "ExpirationDate", this field is standard, however, does no…XUM TECHNOLOGIES 41 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Filter to get the earliest date in the OTBI Analysis.Summary: Content (please ensure you mask any confidential information): Hi, kindly asking for your help. I am trying to get the earliest date per account/activity within…Ivony Ann Paula Salango 31 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 61 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Mutiple conditions applied at the same time in conditional formatSummary: I am trying to use color code for one column, where two conditions need to apply for the conditional format, meaning that both conditions have to be met at the …JohanneAM 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Goal Plan ReportSummary Cannot get individuals to show 0 goalsContent Hello all, I am at an interesting place. Using OTBI I am attempting to create a report that shows me how many goals…Nicolas Trojack-24006 301 views 33 comments 2 points Most recent by Nikhila Reporting and Analytics for HCM -
Customer requires a quantity based blanket purchase agreement at header (commodity centric business)Summary: Looking for a solution to track BPAs where the deliverable is gross weight is spread (not-equally/not known) across multiple items. Need to be able to track the…