Category 81
Discussion List
-
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 11 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 321 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 -
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 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 591 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 112 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 41 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 414 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 31 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 42 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Privilege to Perform Location Changes from Manage in SpreadsheetWould there be a way to run a report of all active/inactive locations in Location Details? And would there be a way (with a privilege, AOR, or role) to download the loca… -
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.9K views 9 comments 0 points Most recent by Naveen kumar 99 Reporting and Analytics for HCM -
Is there any process to clear absences with withdrawn status?Summary: I would like to clear the absences with the status withdrawn, is it possible? Or do you need to apply HDL to do this cleaning? Version (include the version you … -
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 81 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 2 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM -
Tax Reporting Unit field on OfferSummary: Where can I pull the Tax Reporting Unit that is listed on a candidate's offer. Understand that the TRU name is on the hr_organization_units_f_tl, however, how c…Juan C. 21 views 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. 1 view 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM