BI Publisher
Discussion List
-
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 635 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 75 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 49 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 377 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. 27 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…
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe…C.R.Balaji 15.1K views 6 comments 0 points Most recent by Penmetsa_Sushma Reporting and Analytics for HCM -
Payroll query that fetches results only if Archive and Generate Payslips is run post Payroll runSummary: We have a requirement to fetch the run result values only if the Archive Periodic Pay results and Generate Payslips processes have been run for the person post …Pinky Mukherjee 734 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Why IRC_HTTP_REQUESTS is having blank when there is a data in Recruiting Messaging ConfigurationSummary: Hi Team, The SMS communication information is stored in IRC_COMM_ACCOUNTS but We are not getting anything in these tables IRC_HTTP_REQUESTS, IRC_HTTP_BODY_TOKEN…Opkey PA 6 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Recruiting, Opportunity Marketplace