Reports
Discussion List
-
In narrative reporting Is it possible to change signage for certain accounts?In narrative reporting Is it possible to change signage for certain accounts? Eg through conditional formatting? If accounts are under a certain parent, can you make the… -
BICC - Custom offerings migration Import / ExportSummary Dears, We created custom offerings and added PVOs in that custom offerings. BICC Job is created and the source is the PVOs with in that custom offerings. Now the… -
Required Table or SQL query to get Phase details for the ORC moduleSummary: Hi, Required Table or SQL query to get Phase details uder the task: Candidate Selection Process Configuration for the ORC module Content (please ensure you mask…Opkey PA 116 views 3 comments 0 points Most recent by PhilippeTawk Recruiting, Opportunity Marketplace -
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 303 views 3 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 545 views 6 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
SQL Query for Project Budget InformationSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task … -
Looking for SQL to Retrieve BI Report Job History and Deleted Job History in Oracle FusionHi everyone, I have a requirement to retrieve BI Report job history using SQL in Oracle Fusion. I also need to identify or retrieve deleted/removed BI report job history…Kanishka DIas 80 views 4 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 1K views 7 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
What is the field name of checklist status?Summary: Content (please ensure you mask any confidential information): Unfortunately it is not per_allocated_checklists_vl.CHECKLIST_STATUS, any other idea? Version (in…Stefano_Mazzocca 32 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
AI not working for even simplest of use casesSummary: Generative AI - not working. Content (please ensure you mask any confidential information): So I have enabled generative AI for an environment , but I am not ge… -
Not able to return Questionnaire information from Performance Subject AreaSummary: I have created a new performance document but am unable to have any data returned from the workforce performance - performance rating real time subject area. Co… -
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 71 views 3 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…Sanender SP 72 views 9 comments 0 points Most recent by Fiona Marran Reporting and Analytics for ERP -
Dashboards that shares the health status of integration batches, scheduled loopbacks, notificationsSummary: Dashboards that shares the health status of integration batches, scheduled loopbacks, notifications Content (please ensure you mask any confidential information…Ankur_Fusion_HCM 30 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Assignment Manager (Unsecured) significantly slower in Workforce Performance Subject AreasSummary: Material / significant slowness that appear to be driven by [Assignment Manager (Unsecured)] folder within Workforce Performance Subject Areas, relative to othe…bwdata 63 views 3 comments 0 points Most recent by Alexandra Sherman Reporting and Analytics for HCM -
Sample Report: Project Financial Management Cloud: Cost Transaction Import SummaryContent This dashboard displays a summary of the cost transactions that have been successfully imported after a specific date. The default is the last 7 days, and this c… -
Variance logic on calculated rowsSummary: Is it possible to determine the right sign on a calculated row to get the right variance amount? I know, ideally those calculated members would be added as an a… -
OTBI Agent - Invoke an HTTP RequestSummary: While invoking an HTTP Request as an Action from Agent, receiving below error in Fusion ERP Cloud. Could you please provide steps on how to resolve this in Fusi…Abhilash K - Deloitte USI 21 views 2 comments 0 points Most recent by Sabarish Reddy Ganda Reporting and Analytics for ERP -
Can't get Scheduled Hours of employee that shows on OTL Time Card into OTBI ReportSummary I need to get field Scheduled Hours per week that shows on employee time cardContent Hello , I assigned a work schedule to worker and I need to get value of Sche…User_2025-01-30-17-46-10-378 380 views 13 comments 0 points Most recent by Leah H. Reporting and Analytics for HCM -
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 35 views 9 comments 0 points Most recent by User_16WBA Reporting and Analytics for HCM -
Error In Generating Some Books In Update 26.08.95Summary: For some books we are now getting an error message "An error occurred while processing CascadeElement…". See below screenshot for reference as well. This was wo… -
ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_detailsSummary: ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_details This is fusion HCM extarct BIP report related issue, Can anyone please h…User_2025-07-18-07-07-18-338 3.4K views 7 comments 0 points Most recent by Consultant Ian HCM Extract -
Is there a way to automatically expand zoomed members on rows in EPBCS management reports?Please let me know if there is a way to automatically expand the zoomed members on rows in EPBCS management reports, so that users do not have to manually expand each pa… -
Reports 2.0 Audit Trail: Is it possible to determine what changes were made to a Report?We are using Oracle FCCS Reports 2.0 (Reports / Management Reporting) and we have a report that was modified recently. We understand that report properties can display i…Patrick Pontillas 22 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
replace and summarise from epm data sourceSummary: Remap and summarise many to one mappings when pulled from a all bottom members of account row? Or - possible if I do put the remaps on a separate line? Content …