Reports
Discussion List
-
I am trying to get te work schedules of the inactive employees via analysis reportSummary: Work Schedules - if employees are inactive, their work schedules are missing from the analysis Content (please ensure you mask any confidential information): We…Claudia Linares L 41 views 4 comments 0 points Most recent by David Vaughan-Watkins Reporting and Analytics for HCM -
Conditional Region for Pictures on BI PublisherSummary: Difficulty Applying Conditional Region for Displaying Different Logos in BI Publisher Word Add-In Content (please ensure you mask any confidential information):… -
Excel cannot open the file worksheet.xls because the file format or file extension is not validSummary: Hi All, In a lot of area like the application table, there is function to export the data to excel. But we hit a problem for few users. Some users doing export …Yeung Shing Keith 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learneContent Hi All, I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current statu… -
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o…Brian Burns 87 views 5 comments 5 points Most recent by daniel.valdovinos Reporting and Analytics for ERP -
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. 32 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
BI table for AR transaction approvalHi Team, Please help to get table that stores AR transaction approval History. I am not able to find any dedicated table like AP Invoices (AP_INV_APRVL_HIST_ALL). Also t…
-
Unable to Add Home or Work Address for Internal Employee in Offer Letter TemplateHi, We are currently unable to include the Home Address or Work Address of internal employees when generating the offer letter using our offer letter template in Oracle …Narendra N 50 views 4 comments 0 points Most recent by Mohammed Hussain Reporting and Analytics for HCM
-
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 16.7K views 6 comments 0 points Most recent by Penmetsa_Sushma Reporting and Analytics for HCM -
How to fetch User changes details in oracle fusion on daily basisSummary: Can anyone please let us know if there is any way to fetch audit log of when a below actions are performed on user account. The log should give who performed th…Lakkana Bhanuprakash 23 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 774 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Edit note in a report via report packageSummary: Content (please ensure you mask any confidential information): Hi Experts, I am new to narrative reporting and exploring the functionality on report package. We…
-
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 3 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Recruiting, Opportunity Marketplace
-
Looking for report that list active and inactive responsibilies of a userSummary: My client needs to be able to extract current and historical responsibilites of a user in order to verify that compliance rules has been followed. So far I've o…
-
Aggregate (sum) balance amounts by group in an RTF template (such as a Payslip)I've been asked to update a BI Publisher RTF template to consolidate a list of Payroll Balances by Reporting Name and Hourly Rate. The data in the XML extract appears in…Eric Geddes 493 views 6 comments 0 points Most recent by Himanshu Chavan Reporting and Analytics for HCM -
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…User_2025-01-28-20-43-56-568 1.9K views 21 comments 3 points Most recent by Raymund J Reporting and Analytics for HCM -
COUNT function in e-Text Template in BI Publisher with HCM extractSummary COUNT function in e-Text Template in BI Publisher with HCM extractContent I used count function in e-text template ,the count function returns no data, any thing…G Madatala 443 views 8 comments 0 points Most recent by Anupam Rana-Oracle Reporting and Analytics for HCM
-
Repeated Heading Property is not visible under Cell Properties (25.11 Update in Reports)We are reviewing What's New for Cloud EPM Platform for Nov 2025 in Test environment and noticed that our applications do not have the Repeated Heading property under Cel…Jmlopez 21 views 1 comment 0 points Most recent by Komala Reddy-Oracle Financial Consolidation and Close
-
Management reports - function which Allows to check if Text Values in two Columns is the sameSummary: There is presently no function within management report which allows us to Compare two Text Values in different, cells, columns or rows Content (please ensure y…
-
How to Create Custom PVO on Oracle Interface TablesWe have a Requirement where we want to use BICC Console to extract data for oracle Interface Error Table. Can anyone please help with Guided Steps.
-
Not able to send Bursting output zip file to mail as it exceeds the limit of 10MBI am using legacy distribution file, for generating the reports in a folder structure. I can not split the entity list in the file as i am extracting the reports in a fo…
-
Career Site Metrics ReportSummary: Does anyone have Career Site metrics report based on Candidate Tracking subject area in OTBI? Content (please ensure you mask any confidential information): Doe…AvinashP 1 view 3 comments 0 points Most recent by Durga Magar-232055 Reporting and Analytics for HCM -
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 281 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
The Multiple Natural Accounts selected in Single row But Data showing in multiple Rows in FRS OutputCreated FRS Report , One Row We selected Multiple natural account in output data Showing Multiple rows, Expectation Is : Should be appear In Single RowRama Mohan ReddyB 31 views 3 comments 0 points Most recent by Pradnya Bhosale Reporting and Analytics for ERP
-
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m…Pritha 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time …Raghavendra M 31 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Row width changes with multi line commentary in narrative reportingWe have a notes template column in the report, but when we enter any commentary which is bulleted or multi line, the row width changes and the report and package do not …
-
Schedule process runs on working daysHello, Is there a way we can schedule a process for a BIP report which runs first 8 business days on hourly basis and from 9th day to end of month to run daily basis. Pl…