OTBI
Discussion List
-
I need help with creating New Hires report with some Requsition & Assignment & Offer detailsHello, Could you please let me know what Subject Area/Tables I should use to build a report that shows basically the info on the offer screen under: My Client Groups > H…Ramy Atia 31 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
getting duplicate seniority dates in OTBI report FusionSummary: Oracle Fusion OTBI report is there giving duplicate records for one of the employee. It showing two seniority date records out of it we need earliest seniority …SauluriR 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report with manager details and Counts of Direct and Indirect ReporteesSummary: OTBI Report with manager details and Counts of Direct and Indirect Reportees Content (please ensure you mask any confidential information): We are able to get c…MadhuLekkala 61 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report - Direct and Indirect ReportsSummary: Does anyone know how to fetch direct and indirect reports of manager using OTBI? Content (required): Hello, Does anyone know how to fetch direct and indirect re…Hazel De Castro 111 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Number of Direct Reports that are ManagersSummary Need to generate a report that shows, for a manager, which one of their direct reports is also a manager.Content * There is a requirement to get, for a manager, …Bradley Gray 58 views 23 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Line Manager Dashboard Direct/Indirect ReportingSummary: Is there a way to filter the line manager dashboard analysis by direct/indirect reports? Let's say a Manager has 10 direct reports and 30 indirect reports, is t…Vasco 251 views 3 comments 6 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How to enable check in and check out in Quality Corrective action Attachment Tab?Any specific privilege or custom role or seeded role is required to enable this? -
How to query the Effective Start and End dates of job on job profileSummary: How to query the Effective Start Date and Effective End Date of Job Name/Code added to a Job Profile in OTBI. Content (please ensure you mask any confidential i…Vis Perera 74 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Ability to report on auto provisioning rules?Summary: Is there a way to report on all the auto provision rules we have set up within the Manage HCM Role Provisioning Rules task? Or some way to report on all securit…Karlie Backman 133 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
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 811 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 161 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 503 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 42 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 135 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