OTBI
Discussion List
-
how to build OTBI report that give grade rate name by citySummary: Content (required): how to build OTBI report that give grade rate name by city. I am encountering a situation wherin I see multiple salary plans or grade rate n… -
OTBI Report as on effective dateSummary: Want to generate OTBI report as on effective date other than sysdate Content (required): We have a requirement to fetch data as on 1 day before the current date…
-
How to fetch details from Worker Assignment Real Time Subject area as of (current_date - 7)Summary: Hi All, In an OTBI Analysis, I'm trying to fetch all the employees who has their Assignment Category changed to "Leader" in the past week. But I don't see a sub…Akhila 61 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Current HTML Markup values are not working after 23B updateSummary: I've added BIP report to the UI using the HTML Markup. However, when I entered its HTML Markup values, the dashboard is not working as expected. Upon checking, … -
Audit Report for all tax code changes received from HMRCSummary: Need a report showing tax code changes from HMRC Content (required): Can anyone help with suggesting how do I go about building a report based on tax code chang…Isabela Radivoi 61 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI) -
Workforce Compensation Real Time issue in production vs test podsWe created a report in our test environment and vetted it fully. Everything is being pulled from the Workforce Compensation Real Time subject area, we are not using more… -
How to capture Movement Request Requested Quantity in OTBISummary: Need to capture Movement Request Requested Quantity to OTBI, we have tried with original transaction quantity column in Inventory - Inventory Transaction Real T…Navindu Amarasinghe 51 views 3 comments 0 points Most recent by Navindu Amarasinghe Inventory Management -
Where to find Deal Size (Sales Lead) in Subject Area of OTBISummary: I'm trying to find the Deal Size field of Sales Lead object in any Subject Area in OTBI for a report but I can't find it. Content (required): I'm trying to find…User_2025-07-18-06-07-44-367 51 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Ability to Report on Talent Profile Strength Indicator (Content Section Completion)Summary Ability to Report on Talent Profile Strength IndicatorContent Hi All, I am searching for some information on how I can report on employee talent profile completi…User_2025-02-08-03-57-26-191 81 views 2 comments 0 points Most recent by Revanth.Rondla Reporting and Analytics for HCM -
Adding Worker Payroll Name to Custom Timecard ReportI have multiple custom timecard reports being developed. In these reports, I need to include the Pay Frequency (Payroll Name/Worker Payroll Name). The reports are develo…
-
Add a data into a domain - direct accessContent (required): I would like to be able to integrate the data "Group contract type" (see enclosed picture) directly through the domain "Workforce management - Assign…Jacqueline GRANDIN 1 view 2 comments 0 points Most recent by Jacqueline GRANDIN Reporting and Analytics for HCM
-
how to join subject area work relationship real time with worker assignment real timeHello, I have an otbi report in there already have subject area (WorkForce Management Worker assignment Real Time) and (WorkForce Management Worker Person Real Time) and…Mirza_Adeel 413 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Payables OTBI Subject Area - Account Coding Intiated DateHi All, We are developing an AP KPI dashboard using OTBI . Wanted to check if the following field available in Payables OTBI subject area? 1. Invoice Account Coding Init…Devashish Saun 31 views 0 comments 0 points Started by Devashish Saun Payables, Payments & Cash Management -
Cannot find Operations for Work Order TransactionsSummary: In querying the data found in WIE_OPERATION_TRANSACTIONS, I'm noticing that there are WO_OPERATION_ID values that cannot be found in WIE_WO_OPERATIONS_TL. It is…
-
Not able to run Transaction register for the duation of one monthSummary: We have 300K transactions per month and OTBI transaction register is not able to pull the data when we execute the report for one month. We are able to get the …Subbareddy Kandala 41 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
Deeplink to Approve Adjustment Page or Billing Landing pageSummary: In the absence of a notification to alert Receivables Adjustments approvers to approve an adjustment, is there a deeplink or shortcut that can take a user direc…Jonathan Adejokun 21 views 2 comments 0 points Most recent by Jonathan Adejokun Receivables & Collections
-
Report showing employees not enrolled in benefitsSummary: Identify active employees not enrolled in medical that can be run at any time. This is not related to Open Enrollment. Content (required): Does anyone have a re…JHaden3 21 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Edit in Oracle standard absence approval notificationsHi, I want to make edits to the standard notifications in Oracle, such as changing the mail's to and cc information or the title of the mail.and I don't know how and whe…Cansel Karasoy 41 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Supplier Balance Aging Report - the prompt lacks some ledgersSummary: When scheduling a Supplier Balance Aging Report (seeded) I cannot find all ledgers to which I have access. Content (required): When scheduling a Supplier Balanc…Wojciech Krzyczkowski 41 views 2 comments 0 points Most recent by Wojciech Krzyczkowski Supplier Management
-
OTBI - View employee hierarchy vs manager hierarchySummary: I am trying to write an analysis in OTBI which would provide a managers Level 2,3,4,5 Department vs an employee's Level 2,3,4,5 Department. I want to ensure tha…Scott_Turner_ 51 views 0 comments 0 points Started by Scott_Turner_ Payables, Payments & Cash Management -
Mapping Oracle eBS (12.2.8) tot Oracle CloudContent We are currently investigating moving from Oracle eBS on premise (12.2.8) to Oracle cloud. We have quite some customizations and reports build on the old datamod…Pam Koertshuis 407 views 3 comments 2 points Most recent by Manju Chugani Reporting and Analytics for ERP -
Formula for NOT Current Year ("Worker"."Employee Hire Date")Summary: OTBI report - Filtering on YEAR for field name "Worker"."Employee Hire Date" Content (required): I have an OTBI report where the data returned should be for emp…
-
How to create Budget vs Actual and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…
-
Sub Analysis & Activity Hierarchy Info not available in General Ledger Subject area (OTBI)Summary: Sub Analysis & Activity Hierarchy Info not available in General Ledger Subject area (OTBI) Content (required): We are working on OTBI Customization reports on G…Sreedhar Reddy palle 41 views 3 comments 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Can we create OTBI report using multiple subject areas ?Summary: Can we create OTBI report using multiple subject areas ? Content (required): Is there any confirmed dimension in below given GL subject areas in OTBI, can you p…Sreedhar Reddy palle 41 views 3 comments 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Need to pass real time binding parameter dynamically to OTBI Reports.Summary: I have created OTBI Analysis report based on the Compensation -Workforce Compensation Real Time subject area. I have attached my OTBI report to View report sect…
-
Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Mallikarjuna 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Count number of employees submitted response in PERSON EFF (OTBI Count)Hi All, We have developed a Person EFF, and we require an OTBI report that can count the number of employees who submitted their response in the Person EFF (Self Identif…Ashok Kumar Sharma 102 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Prompts are not currently supported for analysis that combine criteria.Summary: Combined two SA i.e Projects Billing - Revenue Real Time + Project Performance Reporting Real time and want to have 'Project name' as Prompt Value and it is not…