BI Publisher
Discussion List
-
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 79 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 -
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 -
SQL Query for Time Card Data and Absence DetailsSummary: Content (please ensure you mask any confidential information): Dear All We have requirement to create OTL Time Card Punch in and Punch out Report if the Employe…Shameer Muhammed P M 397 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
'The page has no content' error messageSummary: Hi All, We have a reports dashboard that is generated by clicking on a custom tile as per the below screenshot. For new users (sometimes even for repeat users),…Anne Fonseca 11 views 2 comments 0 points Most recent by Anne Fonseca Reporting and Analytics for HCM -
Better alternative for not like operatorSummary: Better alternative for not like operator Content (please ensure you mask any confidential information): Hello , I am trying to exclude certain checklist names f…Nikhila 23 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
feasibility check of triggering Manager's direct and indirect reportees dataHi Team, Requirement: I have a requirement to trigger the report to managers as an attachment. The report should include data from both direct and indirect reporters. Co…Haritha 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to send a report to a network folderSummary: Is there a way to schedule a report or Agent to send directly to a network folder? Content (please ensure you mask any confidential information): Version (inclu…THawkins_LGI 140 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Showing error in BIP report ScheduleSummary: Hi Experts, we are facing following error during report scheduling. Content (please ensure you mask any confidential information): Version (include the version … -
Goal Status Overview Real Time is not reporting Review Period NameSummary: Created a OTBI Report using the Subject area "Workforce Goals - Goal Status Overview Real Time". but not getting the data for "Review Period Name" and we have a… -
BI tables to retrieve employee assignment country and departmentSummary: Content (please ensure you mask any confidential information): Hello experts, we need to configure custom person security profile based on employee assignment c…Valerio Curzi 44 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Report submitted in Scheduled Process going to Error stateSummary: Content (required): Hi All, BI report configured under 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applic…Anil Pillaresetty 122 views 1 comment 0 points Most recent by larachalak Reporting and Analytics for HCM -
Which table holds the HR Representative Data for a particular employee?Summary Which table holds the HR Representative Data for a particular employee?Content Hi, Can anyone please let me know, which table holds the HR Representative Data fo… -
How to Test/preview etext templateSummary Have you ever created etext template to create delimited or fixed length files? Have you faced issues with debugging the template with ????? characters on the ou…Sricharan Monigari 446 views 3 comments 6 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
payroll report with gross pay showing element entry deductionsSummary: I need to create a report (OTIBI or BIP) that shows a person name, person number, pay period, pay period week, gross pay (for the pay period), add-in bonuses, (… -
Seeded Termination Report in HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …Daniel McMillian 79 views 8 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Create Security Report in OTBI with details of roles both past and present with dates and statusI tried submitting this question in the HCM Report Sharing Center that was discussed during yesterdays HCM Customer Connect but was getting an access denied error so pos… -
Run Payroll Costing Report flow relation with Payroll Costing Report Extract?Hi All, I'm trying to understand if there is any relation between Run Payroll Costing Report flow and Payroll Costing Report Extract? My requirement is to modify Payroll… -
What is the BICC PVO (View Object) to extract data for pay_bank_accounts?Summary: I would like to extract bank accounts number from personal payment method. Examples of PVO are HcmTopModelAnalyticsGlobalAM.CompensationAM.PreSalaryPVO, HcmTopM…Babatunde Ayodele 140 views 3 comments 0 points Most recent by Babatunde Ayodele Reporting and Analytics for HCM -
Getting extra employees in BI report those are not direct or indirect reports of logged in managerSummary: Created BIP report to get direct indirect reports of manager however we are getting few extra employee those are not direct or indirect of logged in user (line …Swati U 33 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Table details for My Public Info-->About Me SectionSummary Table details for My Public Info-->About Me SectionContent Hi All, Could you please help me with the table/Column details for employee 'About me' Section. I am a…nitin Sharma 111 views 10 comments 0 points Most recent by Amee Patel Reporting and Analytics for HCM -
Fusion BIP Reports Permissions Changes AuditHi, Is it possible to know the person name/ID/number who updates the permission of various reports/folders in Reports and Analytics for BIP. Thanks!Shilpa Varghese 31 views 5 comments 1 point Most recent by Shilpa Varghese Reporting and Analytics for HCM
-
Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCMSummary: Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCM for fetching employee division. Content (please ensure you mask any…Hitha Harikumar 871 views 16 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to convert data rich text format to plain text in BIP.Summary: Am getting below output for one of Field format,:1. Words: 17Characters (with HTML): 897challa praveen 97 views 3 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM -
Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCMSummary: Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCM like : Hire date Hiring position Hiring grade Current grade Current position End of …Hitha Harikumar 290 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to retrieve the job req status for BIPSummary: How to retrieve the job req status for BIP Content (please ensure you mask any confidential information): Hello experts, we would like to build a BIP report wit…Oriana L. 91 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM