Reports
Discussion List
-
Table name and column for Accounting Period of Project CostSummary Table name and column for Accounting Period of Project CostContent Hi Experts, What could be Table name and column for Accounting Period of Project Cost (under M… -
New Hierarchy/Security is not getting reflected immediately in Narrative Reportingif any new hierarchy or dimension level security is implemented in EPM Planning, while opening the reports users can't see the new hierarchy even after refresh DB as wel…
-
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 13 views 1 comment 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Run Payroll Costing Results - load column into FDI?Hello, Is there a way to take a column from the seeded Run Payroll Costing Results report and move that into FDI for reporting use? The need for it is stemming from payr…Sean-B-01 12 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir…Vasanthakumar Ravi 10 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 45 views 4 comments 0 points Most recent by User_HI2N6 Reporting and Analytics for ERP -
Though the cell level indent is zero still columns are showing with indentSummary: Though the cell level indent is zero still columns are showing with indent. we want to override the indent with zero Content (please ensure you mask any confide…
-
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…
-
Reporting the Alias of an Attribute Member (possibly using MemberProperty?)Summary: Hi. We are developing a report that uses the MemberProperty function to display the attribute of a particular base dimension member. The report has the base dim…Peter Doyle - Equator EPM 101 views 8 comments 0 points Most recent by S.C.M. Tieleman Narrative Reporting
-
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 2 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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… -
HCM Extract changes only with dynamic group criteriaHI All We have a requirement for HCM changes only extract for interfacing data in payroll system. Oracle HCM is the master employee system and we have a thrid party payr…Murthy Kodavati 24 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Inquiry on Table for Bursting Email TrackingSummary: Inquiry on Table for Bursting Email Tracking Content (please ensure you mask any confidential information): In accordance with the requirement report, emails ha…ViswanadhK 42 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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 …
-
Alignment of header and main grid of reportHi In current scenario the requirement is that when report is downloaded to excel , grid should start from column B. To achieve this I have indented main grid and header…Amara Sai Sandeep 22 views 6 comments 0 points Most recent by Amara Sai Sandeep Financial Consolidation and Close
-
default bold is showing in report even not enabled the Bold in cell level property Narrative reportdefault bold is showing in report even not enabled the Bold in cell level property Narrative report
-
How to Stop Pie Chart Label Font Color defaulting to White?Summary: I have a pie chart with outside labels. The labels are always white despite what I set the label font color to be. This makes the labels invisible unless I chan… -
Do not promote feature in ReportsWe have an option called Do no promote in Forms Formatting / Validation rules , which allows user to restrict promoting an entity in Approval workflow. Do we have any su…Amara Sai Sandeep 12 views 3 comments 0 points Most recent by SaifUrRehman Financial Consolidation and Close
-
Journal approval and rejection reportSummary: Do we a report in Oracle that provide information on journals which were submitted for approval and have been rejected. If not can anyone share any queries wher…
-
Create Data Model From View ObjectSummary: We are in an Oracle Fusion Saas environment. I have been looking at the View Object Data Model, We have Data Sources that populate for ERP and HCM in the dropdo…Christopher Haupt 14 views 0 comments 1 point Started by Christopher Haupt Reporting and Analytics for ERP -
BI Publisher - how to add watermark based on condition in RTFSummary: Content (please ensure you mask any confidential information): Dears , We have a requirement that a watermark to be appeared based on condition , like if the st…Beshoy Hakim-Oracle 12 views 1 comment 1 point Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
Requirement for Encrypted File Generation in UCM via BIPSummary: Hi, We are currently using Bursting in BI Publisher, where a .csv file is generated as the output and placed in the UCM Content Server. However, we have a requi…Mounika-Oracle 51 views 5 comments 0 points Most recent by User_WBPA1 Reporting and Analytics for HCM
-
SQL to Find AP invoices assigned for approval to wf groups where those role currently has no usersWe have a requirement to fetch the invoices assigned for approval to wf groups(roles) which has no active users, if anyone has any sql or BIP report could you please hel…
-
Can we restrict OTBI report 'edit' access for user to edit OTBI Analysis created by themselves onlySummary: How can we restrict user to edit only the OTBI Analysis created by themselves, provided 'BI Author Role' access has been assigned to the user and user should ha… -
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 63 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Did the April or May updates mess up your grid/chart formatting?Summary: Reports we built months ago for our budget book (and really haven't touched since) have column widths adjusting, chart labels flipping from horizontal to vertic… -
Aggregate commentary entered at low levelIf a user is entering commentary at lower level entities and want to view that same commentary in top level entity maybe in a different text column, is that possible. I …
-
Reports to get Service Usage in fusion HCMWe need reports for below: 1) Anonymized Authorized User Names by Service Details 2) Authorized User Names by Service 3) Authorized User Privileges by Service 4) Authori…
-
Documents about multiple reporting tools in Fusion and their usesSummary: There are several reporting tools available in Fusion (OTBI, BIP, FRS, FDI etc.). Is there any document available from Oracle which helps explain when these too… -
Certified payroll - Has Oracle provided delivered reports for certified payrollSummary: Has Oracle provided delivered reports for certified payroll? Can someone, please share any leads to achieve the requirement? Content (please ensure you mask any…Suppu 61 views 3 comments 0 points Most recent by Dhinakaran Venugopal Payroll and Global Payroll Interface (GPI)