OTBI
Discussion List
-
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 21 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 101 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 38 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 34 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 41 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 26 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 -
Random Sampling of EmployeesContent I am trying to pull 50% of the employee population at random. Is there a report or formula I can use to pull this information?Riti Malhotra 36 views 13 comments 0 points Most recent by Caleb Pingelton Reporting and Analytics for HCM -
Work structure reports for Oracle HCMSummary Work structure reports for Oracle HCMContent Do anyone have list of reports which can help pulling the work structure details from the configuration tables - JOB…Prabhu Krishnamoorthy 35 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Drilldown to a RMCS Contract from a OTBI Report.Summary Am trying to create a OTBI report which allows drilldown to a RMCS Contract by clicking on Contract Number Column.Content Has anyone tried creating a OTBI report… -
21C Content counts are duplicatingSummary 21C Content counts are duplicatingContent Dear Experts, Please advise why the content counts seem to be duplicated. The course has only 4 contents after I update…
-
HCM Integration Real TimeSummary HCM Integration Real TimeContent Hi Experts, I am trying to build an OTBI report based on "HCM Integration Real Time" subject area to fetch HCM Extract definitio… -
Course Publish End Date in OTBISummary Is it possible to report on the Publish End Date of a course in OTBI?Content Hi All Is it possible to report on the Publish End Date of a course in OTBI? I've us…