OTBI
Discussion List
-
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 21 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Two initiatives - One with Expiry and the other one WithoutContent Hi there please share your experiences for the next case I have a course that is with Default assignment rules - Never Expires. I want to have two initiatives On… -
In Supply Chain Planning Real Time Subject area, can I fetch non functional catalogs values?Summary: I am creating an OTBI with Subject area Supply Chain Planning Real Time, I am only able to see the values getting populated for Functional area catalogs and we …Vatsala Bharadwaj-Oracle 21 views 1 comment 0 points Most recent by Cherry Bruns-Oracle Supply Chain Planning and Collaboration -
Accessing OTBI analysis using a linkSummary: Just like we can access the BI report using the link to the report where we can use _xmode to hide all the BI page buttons. Can we also access OTBI analysis usi…Abhishek Nigam 51 views 2 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Applying filter for the analysis report with in the dashboard.Summary: Content (required): Currently we are building a dashboard with number of analysis/reports on Headcount using 'Workforce Management - Workforce Trend Real Time' …Su Ma 51 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Position/Incumbent Report - by FTEContent I am trying to create an analysis that lists the current active positions, by department, the position FTE and all employees assigned to the position and their F…Annette M 607 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Extract the Report Name and Description (Audit Report)Summary: Extract the Report Name and Description (Audit Report) Content (required): Hi Team, We have requirement to export all the report name, report path and report de…[Deleted User] 11 views 4 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Recruiting - Need to show Offers made that were Declined and the reason givenSummary: Does anyone have a report or dashboard built that will return this? The business needs to review the reasons given for recruiting offers made to candidates that…Rich R 23 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
Quotes and Quote Line - Sample ReportsOracle CX Sales has proactively provided pre-configured quote and quote line reports and dashboards in OTBI, referencing Sales - CRM Quote Lines subject area. A set of p…User938840-Oracle 102 views 0 comments 3 points Started by User938840-Oracle Reporting & Analytics for Sales -
OTBI report for scored SCORMs/eLearnsContent Hi Just wondering if anyone has built an OTBI report for SCORMs which have scoring. What we are looking for is something that shows a learner's name, the Course … -
Administration-->Bi Publisher/Manage BI Publisher-->Runtime Configuration/Properties Refreshed?Content Hi there, I searched My Oracle Support and the Community, but wasn't able to find any documentation regarding the following: Any knowledge/documentation regardin…Karen Long 18 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for HCM
-
SCM roles to create OTBI reportSummary list of roles is requiredContent Hi All, Kindly, I want to use OTBI to create reports specifically in SCM. I need the list of roles that facilitate this kind of …Morad Alshammari 37 views 5 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM -
Budget Vs Actual in GL Account Group & SmartViewContent We have received requirement from user that need to generate a report through smart view tool to see the Budget Vs Actual under Fusion COA instance. Note: we got… -
AR Cash Receipt ReportingSummary: AR Cash Receipt Reporting Content (required): I am looking for information on when cash receipts are applied (and the application timestamp). Is there a subject… -
BPM expense tablesSummary: BPM expense tables, I need to know which tables are stored BPM screen information. I found only the approval rules for the procurement Content (required): Hi, c… -
Payroll element entries costingSummary OTBI Subject Area and fields for data.Content Under the payroll element entries - Cost Account are the fields Fund___ Purpose__ Prc__ Object___ Location___ CostC…User_2025-02-08-08-49-19-186 33 views 3 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reportsSummary: Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest. Content (requi…User_ENPUR 211 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to create OTBI analysis that will display Assets with their source lines details?Summary: Need to create an analysis that will display Asset info (number, description) with its source lines details (project, invoice info) Content (required): When cre… -
Fiscal calendar in OTBIHas anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year starts in November (October 28th for 2020). We have a lot of reports that we end up …SM-Oracle 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
GL Audit Data export from SAASContent We are in the process of GL Auditing with Audit agency, Any body could share the template of DM and REPORT from Oracle SAAS environment to EY. Version 21CNarenInova 25 views 2 comments 1 point Most recent by Jeff Hare CPA CISA CIA General Ledger & Intercompany -
Pass parameter to embedded report in pageSummary Pass person id as parameter to embedded report.Content We need to display some employee information on the Public Info page for any employee. Since personalizati…Varkey George-Oracle 171 views 3 comments 1 point Most recent by User_XHDBT Reporting and Analytics for HCM