BI Publisher
Discussion List
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.3K views 4 comments 5 points Most recent by gclampitt Reporting and Analytics for HCM -
BI tables for standard compensation plan columns regarding salarySummary: Content (please ensure you mask any confidential information): Hello experts, which BI tables store the following standard compensation plan column fields? New …Valerio Curzi 31 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables… -
retrieving timestamp is not giving correct date and timestamp from Table PER_EXT_APP_IDENTIFIERSSummary: retrieving timestamp is not giving correct date and timestamp from Table per_ext_app_identifiers Content (please ensure you mask any confidential information): …
-
Repeating Groups - Excel Template BI PublisherSummary: Hi, I am trying to create a PO History Report and I am wondering if there is an easier way to group the data by a specific PO? Right now I have PO Number and PO…Simranjeet Singh 135 views 2 comments 0 points Most recent by missy_21 Reporting and Analytics for HCM
-
HDL - DeleteSummary We are trying to remove Matrix Managers via HDL; but DELETE removes all historyContent Hello! We are implementing Matrix Managers and I've been tasked with updat…User_2025-01-23-21-24-21-434 117 views 5 comments 0 points Most recent by Jagdish Kolli Reporting and Analytics for HCM -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 62 views 3 comments 1 point Most recent by R Ravichandran Reporting and Analytics for HCM
-
Headerless csv output in oracle fusion BI reportingSummary: Hi Team, We have a requirement to get the extract in CSV format without header fields in the Oracle BI report. Content (please ensure you mask any confidential …
-
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha… -
BIP report, for identifying the missing Time EntriesSummary This will be useful If we are expecting to see missing time entries in report or infolets. This SQL query logic is based on the Working hours of the User.Content…Praveen Chandra-Oracle 637 views 4 comments 5 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
SQL runs in query tool but not Data ModelI need to calculate the number of days a person will work during a pay period. To do this I am calculating the the days from the last day of work through the end of the …Jason Snipes 20 views 6 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM -
Required table to get Ad Hoc resource name in activities under OfferingsSummary: Hi All, We need a table to get Adhoc Resource name, quantity and description in activities under Offerings in fusion HCM Content (please ensure you mask any con…
-
SQL Query for Calculation Cards > Benefits and Pensions for Employees with Multiple AssignmentsHi Navigation: Calculation Cards > Benefits and Pensions I need help to find out how to join the Pension scheme back to the Assignment number/id for a BIP report. If not…Nilesh D Patel 77 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI)
-
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna…
-
Insufficient Privileges FA_FUSION_SOAINFRA.WFUserVacationSummary: Getting Insufficient Privileges Error when running below query SELECT * FROM FA_FUSION_SOAINFRA.WFUserVacation SELECT * FROM FA_FUSION_SOAINFRA.WFUserVacation I…Fazil_Shahid_Khan 53 views 6 comments 0 points Most recent by Fazil_Shahid_Khan Reporting and Analytics for HCM
-
How to get employee's co-worker-style contactsSummary: How to get employee's co-worker-style contacts Content (please ensure you mask any confidential information): Hi Experts, Is there any query/tables to get emplo…
-
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance. -
Employee Assignments Processed in a 'Calculate Payroll' RunHi, does anyone have an SQL/Data Model to list all employees processed through a 'Calculate Payroll' Run or know which tables i would need to use?
-
Tables lock or obsolete statisticsSummary: Hello experts! It's possibile to verify if it's present a lock on a table o the statistics are obsolete? We have a BI query of a scheduled job that times out ra…Gian Luca Triglia 5 views 2 comments 0 points Most recent by Alexandru-Catalin Serban-Oracle Fusion Applications Administration
-
Required table for component group rules setupSummary: Hi Team, Could ypu please provide us the table where payroll component group rules stored in oracle fusion Payroll module Setiup name > Component Group Rule. fo…
-
Query to link between State and component group ruleSummary: what is the link between component group rule and this state through SQL query or backend table. We got one table HZ_GEOGRAPHIES where GEOGRAPHY_TYPE = 'STATE' …
-
Need inputs to get the DFF fields in Worker folder in OTBI analysisSummary: Need inputs to get the DFF fields in Worker folder in OTBI analysis Content (required): We have few DFF fields in Employement and Person UI/Screen. As of now we…
-
SQL query to retrieve additional manager types at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve hierarchies loaded in core hr for additional manager types (no…Valerio Curzi 19 views 1 comment 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
Need to build a BI publisher report on Document of recordsSummary Reporting on Document of record filenameContent Hi, We recently uploaded documents under document of record for all employees. We need to write a query to valida…User_2025-01-31-02-27-22-166 553 views 12 comments 0 points Most recent by Subbarao B-Oracle Reporting and Analytics for HCM
-
Can we use invalid custom 'From email address' for BI Report Notification?Hi Everyone, We are trying to personalize 'Email From Address' for BI Reporting Delivery. We have changed 'Email From Address' by navigating to /xmlpserver → Administrat…BinduTammineni 5 views 0 comments 0 points Started by BinduTammineni Reporting and Analytics for HCM
-
Issues while displaying Calnedar View in OTBISummary: Unable to call https://www.gstatic.com/charts/loader.js using Narrative view in OTBI Content (please ensure you mask any confidential information): We have a re…
-
Burst to Documents of RecordSummary BI publisher report bursting to DoR possible?Content Hey, We would like to create a BIP report (containing the approved notice period and other relevant data) in…Ann Van Roosbroeck 378 views 4 comments 2 points Most recent by Tara Samari-237472 Reporting and Analytics for HCM -
How to create an ER diagram that illustrates the relationship between tables within Oracle Fusion?Summary: How to create an ER diagram that illustrates the relationship between the PER_LOCATION_EXTRA_INFO_F table and the LOCATION_ID and LOCATION_NAME columns in HR_LO…Dhilip Kumar P. 28 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Which table stores the acknowledgement date of performance document and comments entered by employeeSummary: We are trying to customize one performance module seeded report. In the report, we are trying to fetch whether document is acknowledged by employee or not. If y…