Reports
Discussion List
-
Fusion HCM BIP report completed with errorSummary Fusion HCM BIP report completed with errorContent Hi Everyone, When attempting to run a fusion hcm BIP report Online (not schedule) the following error occurs. E…Dhanuka Chamal 496 views 2 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Multiple Conditions CASE StatementSummary Build a case statement to include ELSE conditionContent Hi, Please see the attached formula logic. I am trying to build out this formula for multiple locations b…User_2025-01-25-03-46-43-745 292 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to add a column in OTBI Analysis summing up values of two other columnsSummary I am working on OTBI analysis, where I need to show a column which will sum up the values of two other columns at row level.Content Hello, I am working on OTBI a… -
Head-CountSummary how do i get head count using SQL QueryContent i want to get head count from oracle fusion by organization id to each organization Version oracle fusion last ver…User_2025-02-11-08-39-07-186 48 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
BIP Report with stacked Bar chart not showing all dataContent Hello, We have created a BIP report with stacked bar chart. But it is not showing all data. I have attached screenshot document here. There is 1 filled requisiti…Ananya Sadhukhan 49 views 2 comments 0 points Most recent by Ananya Sadhukhan Reporting and Analytics for HCM
-
Oracle Procurement withholding tax problem - sqlSummary Oracle Procurement withholding tax problem - sql - see no tax code at line location, but populated norec / rec tax at distribution levelContent Hi, this is a sql…User_2025-02-10-15-12-48-631 15 views 0 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Reporting and Analytics for ERP
-
How Can we import Gl Balances from legacy to Oracle Fusion?Summary How Can we import Gl Balances from legacy to Oracle Fusion?Content Hello All, Can you please let me know what are the ways to import GL account Opening Balances … -
Contracts Deliverables ReportContent Hello, Does anyone have a Contracts Deliverables Report that they can share? When I am building a report using OTBI Subject Area - I am getting many different st…Troy Collard 8 views 0 comments 0 points Most recent by Troy Collard Reporting and Analytics for ERP
-
Filtering Workforce Trend Real Time by item in Worker Assignment Real TimeContent Has anyone had success filtering workforce trend real time data by a data point in Worker Assignment Real Time? I want to report on the make up of our officer po…Lauren Owen 31 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possbile to extract the SQL's wirtten in BI Publisher?Summary Is it possbile to extract the SQL's wirtten in BI Publisher?Content We would like to know if there is any option to export all the custom sql's written in BIP. T…GTS Narayanen 44 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
Source Safe - Oracle Fusion BIPSummary Source Safe - Oracle Fusion BIPContent Hi, Can you please guide me on how to and best tools for setting up Source Safe for Oracle Fusion BIP (ERP/HCM), as we wou…Rakesh Sreenivasa 26 views 0 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP
-
Include 'Comments' from Contract Risks into Subject Area "Enterprise Contracts - Contracts Real TimeContent Hello, I am wanting to include a field called 'Comments' from Contract Risks into an OTBI report that uses the Subject Area "Enterprise Contracts - Contracts Rea…Troy Collard 3 views 0 comments 0 points Most recent by Troy Collard Reporting and Analytics for ERP
-
Facing a error while fetching the balance Results from Payroll. Error : ORA-20001: An error occurredContent I'm fetching the different balance results from payroll custom balance groups & getting an error ORA-20001: An error occurred. An assertion failure was detected …Akshat Rajpurohit 29 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM -
CSV output being generated in a different layoutSummary BI Publisher report tab is not working properly when CVS output is selected.Content Hi Team, Maybe this is a known issue and I getting late aboard. I've added a …Alvaro Couto 30 views 3 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM -
BIP excel template to enhance pivot chartsContent We are trying to build a BIP report and include analytics (pivot charts) on one of the tabs. is there a way to not have to repeat the filters? For instance, Stat…User_2025-02-10-08-27-16-805 33 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to extract data from Manage Business Unit Set Assignments pageContent Hi All, I need help identifying which table I can pull the data in Manage Business Unit Set Assignment. I need to identify what is the reference data set of Busi…User_2025-02-08-02-40-14-106 583 views 2 comments 0 points Most recent by User_2025-02-08-02-40-14-106 Reporting and Analytics for HCM
-
It is March 2021 - Why Can We Still NOT Export to csv or Excel in PCM Batch Scheduler?Content Why is it not possible to export to excel or a csv file using the report Batch Scheduler in PCMCS? Why are we limited to only PDFs or Web Page view? Thanks! Vers…John H-2955 40 views 6 comments 0 points Most recent by John H-2955 Profitability and Cost Management -
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…Sushan Peiris 48 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Lease Accounting in China -VideoSummary Lease Accounting in China-VideoContent 1. Fusion ERP Soultion in China 2. Demo 3. Q&A
-
Lease Accounting Solution in ChinaSummary Lease Accounting Solution in ChinaContent Oracle Fusion 租赁会计方案专题 – Oracle 售前顾问 金军 1.Fusion ERP Leasing Solution overview 2.Demo 3.Q&A
-
Reports Failing after upgrade to 20BSummary Reports Failing after upgrade to 20BContent Does anyone experiencing these issues after the upgrade over the weekend? 1. Reports parameters are blank not display…
-
What is the best way to identify whether the current Fusion instance is PROD or Non-PRODSummary What is the best way to identify whether the current Fusion instance is PROD or Non-PRODContent As we need to transfer BIP Reports to different FTP file servers …Umamaheswara Reddy Karri 51 views 9 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Program Documentation ReportContent Hi, What is the relevance of Detail Report option while generating Program Documentation Report. Thanks in advance.Mohit Pahuja 34 views 2 comments 2 points Most recent by Mohit Pahuja Profitability and Cost Management
-
Entity Structure - Segment Reporting Investment eliminationContent Hi Team, We have 2 structures in entity dimension, 1st represents Segment hierarchy and 2nd represents legal reporting structure. The elimination for Investment …Kotak Pramit 54 views 5 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close -
How can we extract requisitions tied other locations data through BIP tables ?Content Hi All, PFA, screenshot and we have two tables available (IRC_REQUISITIONS_VL & IRC_REQ_LOCATIONS ) and the join is for tables is “IRL.REQUISITION_ID = IRV.REQUI…Janardhana Kondaveeti 43 views 4 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Department Hierarchy and Department Changes reportingContent I have been working on rolling out a department hierarchy for my company. The hierarchy is complete and working but i am looking at how it interacts with things …User_2025-02-10-15-06-52-222 62 views 4 comments 1 point Most recent by MilanMohanty Reporting and Analytics for HCM
-
FOLLOW-UP ~ EPM – Best Practice: How to Wow Your Users and Make Your EPM Solution Shine!Content Following the recently delivered event "How to wow your users and make your EPM solution shine" https://cloudcustomerconnect.oracle.com/posts/343fe13a76# I wante…Andy King-Oracle 24 views 0 comments 0 points Most recent by Andy King-Oracle Tax Reporting (Direct Tax)