Category 81
Discussion List
-
OTBI Report to get Candidate Education Start date and end dateHi Everyone, I have requirement of get candidate education start date and end date in OTBI report. Navigation : My Client Groups > Hiring > Job requisition> Applications…Rajdeep Chavda 22 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
as of date birthdaySummary: Hello, Please assist on the following... We were able to calculate person ‘Age’ based on presentation variable @{asofdate} for the Headcount page on LM dashboar…
-
Report on questionaire details tagged to a courseHi, I have requirement to fetch Questionaire name, question text and answer text tagged to activity of a course but I am facing an issue while joining the learning item …User_2025-11-14-00-02-48-758 1 view 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
How to create an OTBT analysis to get results if the benefit plan got declined?Summary: We need to create an analysis to get employee results when they selected the decline option for a specific benefit plan. Which subject area I need to use ? Cont…Ayesha Iroshani 23 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Email Correspondences/System Notifications ReportSummary: Looking for report(s) which would list all email correspondences we currently have set up, the status, frequency and recipients. As well as a listing all system…GMV 22 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration
-
query to get details of Potential assessment in talent review which is completed by the Managerneed to know the tables and links between the tables where to get the Manager Assessed Avg Performance, Manager Assessed Risk of Loss, Manager Assessed Potential, Manage…Sanduni Pathirathne 330 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
How to create analysis for Check-in Documents Created vs. Not Created?I need an analysis to get a list of employees who haven't created their Check-in Documents yet. I'm currently using Workforce Performance - Performance Check-In Real Tim…Welsey 32 views 2 comments 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM -
OTBI Dashboard Design - Export ButtonHi all, I'm currently working on an OTBI Dashboard that certain groups across the business will use. We're using a mixture of Performance Tiles, Graphs and Tables and I …
-
OTBI Report for Document Records Descriptive FlexfieldsHello Experts Step 1 : I Have Created a Document (Eg: External Training Request) using Task Document type. Step 2: Using Task: Document Records Descriptive Flexfields, I…
-
ESS and MSS ReportSummary: How can I report the number of transactions that were done through ESS and MSS? We want to check which countries are using the self-service the most against the…
-
Is there a way to use environment-aware variables for dashboard action links?Summary: Instead of hardcoding urls for dashboard action links, is there an environment-aware variable that can be used? For example, instead of https://sample-dev2.xx.x… -
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…Swati U 941 views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM
-
Assignment Manager Prompt - Direct and Indirect ManagersHi all, Does anyone know if its possible to use Assignment Manager as a prompt for a dashboard and also include the full direct and indirect managers for the user? At th…
-
Footer is not displaying when data of custom report is output in WordSummary: Footer is not displaying when custom report is exported to Word. What is causing the footer to disappear when report is exported to Word? I can see the footer w…Consultant Ian 13 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
ORA-20001:An internal assertion test couldnt be completed at location pay_balance_pkg.chk_rel_actionSummary: Custom BIP report is developed and It is not working from ESS job. Note: When it directly run from BI Publisher is working. Error: Waiting Time: 2 seconds Trigg…Bejoylin 292 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Custom Schedule Reports,BICC extract and Custom HCM Extension also impacted on emps to workers apiSummary: I have concerns regarding emps to workers api change, Below objects also impacted or not Custom scheduled reports? BICC extracts? Custom HCM Extensions? Content…mohityagyik 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
address purpose Filed and table locationSummary: Looking to add the address purpose field into a previous BI report Content (required): I have a previous supply report i had built in BI publisher, a recent req…RJ Blankenship 116 views 6 comments 0 points Most recent by H.Chauhan Reporting and Analytics for HCM -
OTBI > Ability to AggregateSummary: OTBI > Ability to Aggregate Content (please ensure you mask any confidential information): Hello All, In order to prevent the repetition of the Time Card Commen…
-
Data Model for Report on the Learning Alerts sent with detailsSummary: Content (please ensure you mask any confidential information): Hi there, how can I get a BI report (Data model) that will give me details on these alerts? I hav…Bobby Jourdan 22 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat…Mike.Myers.CDIPRODUCTS.COM 578 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…GJ79 41 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Write a BIP report query in which termination records should be picked only once in output fileSummary: My requirement is: I have to write a query in BIP report to fetch the current and future hire employees, and termination records should be picked only once. The…Anuroopa Sahoo 95 views 1 comment 0 points Most recent by Serban Nicolae-Oracle Reporting and Analytics for HCM
-
Report footer not showing completely in report outputSummary: Report footer not showing completely in report output. My client wants to display this footer on all the reports. When I run the report then everything in the f…Consultant Ian 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. …Dara Nagasai 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
I have made changes to emps to workers from our integration urls but unable to find AssignmentDffId"Summary: I have made changes to emps to workers from our integration urls for testing one url need this "AssignmentDffId" but i have checked frontend as well as backend …
-
Learning Access Group Organization Chart Selection Method Details -BIP Table mappingSummary: We have a requirement to develop BIP report for all learning items where we need to fetch the name of selection method for Organization Chart Criteria. We have …Kamini Kaushik-Oracle 12 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
How to add Calendar chart in OTBI Analysis under Learning Module?Summary: Hi Everyone, I have a requirement to implement a Calendar Dashboard that has an identifier if an activity is scheduled for that date - e.g. turns green if class…Prashanth Sangram-Oracle 36 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Number of attempts by each learner are not showingHello, I need to get the number of attempts that a learner did on a course. Example below: Offering Title: JV Test 01/18_SP Person number: 001670007 1st attempt - 50 2nd…
-
Recruitment questions in all blocksSummary: Hi , I would like to report on all questions in the pre-screening form for a candidate. The questions for the job requisition appear but not the questions in ot…Neena S 22 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM
-
IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and viewsSummary: Need to build Onboarding - Overdue Tasks Report Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Pradnya_Pampatwar 401 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM