BI Publisher
Discussion List
-
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 298 views 1 comment 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 …
-
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 936 views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM
-
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 12 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 272 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 111 views 6 comments 0 points Most recent by H.Chauhan Reporting and Analytics for HCM -
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 21 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 543 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 83 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 11 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 23 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 21 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
-
Candidate and Job Application Source-TrackingWe drew the statistics from the recruit to hire dashboard, and need clarification on how these are being collected and what those source mean. We inserted a pre-screenin…Radhika Hatwar-Oracle 23 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM
-
how to join pay_tasks_vl table with person number?i wanted to fetch task name from (pay_tasks_vl) for a particular person but not getting how to join this table with person detailsChetana Pawar 11 views 2 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM
-
Using BI Publisher attempting for get Learner - Self Service Setting and if overwrittenSummary: Using BI Publisher tables I am attempting to get default access - learner serf-service setting on a catalog/enrollment and then see if it was overwritten at the…Nicolas Trojack 41 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 1.8K views 9 comments 0 points Most recent by Naveen kumar 99 Reporting and Analytics for HCM -
Option to download multiple file from content serverSummary: Using BI Publisher report, I have extracted multiple files to content server , Whats the way to download all files from content server Content (please ensure yo…ROOPESH MADAN-Oracle 21 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle BI Publisher Learning Center -
How to link an assignment to a requisition or to a job offer?Summary: We are in the need to identify if an internal transfer came from a Requisition Content (please ensure you mask any confidential information): We are trying to b…Sergio Burgos 77 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM
-
Annual Leave Accrual Plan Enrolment dates table values not matching screen. Any ideas ?Summary: Start Date (enrt_st_dt) and End Date (enrt_st_dt) in anc_per_plan_enrollment not matching the screen values. Content (please ensure you mask any confidential in…
-
Requisition Staffing agency fields in OTBI do not show any dataSummary: Requisition Staffing agency fields in OTBI do not show any data Content (please ensure you mask any confidential information): Recruiting Real time Subject area…FuriousSS 1 view 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM
-
Difference between creation_date and submission_date in IRC_SUBMISSIONS tableSummary: Difference between creation_date and submission_date in IRC_SUBMISSIONS table Content (please ensure you mask any confidential information): Hello experts, does…Oriana L. 2 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM