Reports
Discussion List
-
The absence report should calculates absence durations based solely on working days.We have created a report name "Absence Balance Details Report" , which has below columns : EMPLOYEE NUMBER EMPLOYEE NAME LEGISLATION CODE LEGAL EMPLOYER NAME ASSIGNMENT …User_6VOPA 36 views 4 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM -
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment … -
Lease Accounting - CWB + Test Scripts + Business Process ModelSummary: Lease Accounting - CWB + Test Script + Process Flow Content (required): We are looking at replacing our legacy system for Lease with Oracle Lease Accounting, an… -
OBJECT_ID stores the Period of Service ID instead of the Assignment ID for PER_ALL_ASSIGNMENTS_M ?Usually, for transactions related to the Assignment page: •Object Name → PER_ALL_ASSIGNMENTS_M • Object ID → Employee Assignment ID However, in one particular case invol…Ashish_Goyal_MPC 61 views 8 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
VAT report for a specific VAT regime currencyWe have a requirement to generate a VAT report for a specific VAT regime currency (e.g., DKK), with potential extension to additional currencies in the future. For examp…Kamonwan Srasrisom 54 views 2 comments 0 points Most recent by Kamonwan Srasrisom Tax Reporting (Direct Tax) -
OTBI Report Issue - "Compensation - Workforce Compensation Real Time"I am currently building a report using the “Workforce Compensation – Real Time” subject area in OTBI. My objective is to retrieve basic employee details along with their…Abdul Raqueeb 46 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea…notautomni9 4 views 1 comment 0 points Most recent by Julia Kiszelewska1234 Reporting and Analytics for HCM -
how get query manage locationsCan someone help me with the query to obtain the information shown in the "manage locations" option? Basic details name status code Main address Main address usage type …Henry S. 23 views 3 comments 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP -
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 31 views 3 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…Roohi Syed 4.4K views 6 comments 0 points Most recent by SUDERSHAN PRASAD TIWARI Reporting and Analytics for ERP -
in the account analysis report when the category payroll the line description is blankedSummary: in the account analysis report when the category payroll the line description is blanked, from where we can fill the data for Line description Content (please e…Mohammad Merie 7 views 0 comments 0 points Started by Mohammad Merie Reporting and Analytics for ERP -
How does smart view work with Oracle fusion? are there any conditions to work like license?Summary: How does Smart View work with Oracle Fusion? Are there any conditions to work like a license? Content (please ensure you mask any confidential information): Ver…Mohamed Roshdy 41 views 4 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close -
What’s New in EPM Cloud Narrative Reporting and Reports Release 26.06What’s New in EPM Cloud Narrative Reporting and Reports Release 26.06 Please refer to the June 2026 What's New Guide to understand the new features included in Cloud EPM…Dave Roberts_-Oracle 86 views 0 comments 2 points Started by Dave Roberts_-Oracle Narrative Reporting -
Unable to pull the pull the complete parent hierarchy chain through OTBI reportUnable to pull the pull the complete parent hierarchy chain (Parent Manager 01 to Parent Manager 05) for terminated cases through OTBI report Subject Area > Workforce Ma…Harpreet Kohli 32 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is data contained in a report created/ scheduled in BI Publisher automatically encrypted ?We are looking to improve the way data is extracted from Oracle Fusion and delivered to internal customers. Using BI Publisher reporting, it is not clear or visible if t… -
CIP Account Analysis is not showing dataSummary: Why is my asset project not showing data here in the dashboard: There are plenty of cap transactions. I have also tried with chosing all periods - same result … -
Employee Rating not fetchingSummary: I have issue with my performance rating analysis. I was able to get the Overall Manager Rating but it's not fetching the Employee Rating, Rating Level Name, Sta…Marilyn O 12 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re…Parag Hiremath 1 view 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Scheduled agent is failedHi Experts, I’m hoping someone can assist me here. We have several agents scheduled that were running successfully. However, one of the scheduled agents has suddenly sto…Angela Nietes 52 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m… -
FCCS Management Reporting- Conditional Properties - Suppression option not working properlyHi, In FCCS I'm trying to create a Management Report, where in rows, I've selected few Accounts and in column I've selected Entity dimension. I've only used one single c…T Hussain Kumar 26 views 1 comment 0 points Most recent by Girish Joshi Financial Consolidation and Close -
Grouping on Rows and Columns - can I do a Variance on on both descendants of 2 dimensions?Summary: Not sure if this is possible: I have descendants of children going across the columns (could be between 5 and 20 members depending on what parent is selected in… -
Automated / Dynamic Comments in ReportsSummary: The customer requests a feature to automatically generate dynamic comments within reports that explain changes in key metrics. Specifically, they want comments … -
Smart View handled an unknown exception thrown by Microsoft OfficeSummary: Smart View Error - Smart View handled an unknown exception thrown by Microsoft Office Content (please ensure you mask any confidential information): Steps to re… -
How to fetch the document names of the attachments on a Journey Checklist taskSummary: I need to fetch the names of the attached documents on a checklist task, onto my OTBI analysis. Content (required): I need to fetch the names of the attached do…User_2025-07-18-13-29-11-469 66 views 4 comments 0 points Most recent by Himanshu Chavan Reporting and Analytics for HCM -
BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisSummary BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisContent Hi, BI Publisher: Can I have Action Links on the BI Publisher … -
What’s New in EPM Cloud Narrative Reporting and Reports Release 25.06What’s New in EPM Cloud Narrative Reporting and Reports Release 25.06 Please refer to the June 2025 What's New Guide to understand the new features included in EPM Cloud…Dave Roberts_-Oracle 84 views 2 comments 2 points Most recent by Dave Roberts_-Oracle Narrative Reporting