Reports
Discussion List
-
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 49 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 10 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 45 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 27 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 30 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 35 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 644 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 50 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 53 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 36 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 44 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 73 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 26 views 0 comments 0 points Most recent by Andy King-Oracle Tax Reporting (Direct Tax) -
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 57 views 0 comments 0 points Most recent by Andy King-Oracle Financial Consolidation and Close -
OTBI AP Report including approversSummary Can I access a field containing approvers in an OTBI Payables transaction report?Content We have a report that returns all payables transactions for the prompted…User_2025-02-11-03-09-13-126 27 views 2 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP -
.cvs output file is splitting in 2 columns I want it one column only.Content Hi Experts, I have BI Report and I want output as .csv Tab Delimited. I did all setup and when I schedule this report I see output in 2 columns (A & B). I want i…User_2025-02-07-19-03-14-525 23 views 5 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
Exception reporting for projects with no baselined budgetContent We are trying to create a report that will list any projects that do not have a baselined budget. I have been able to get so far in OTBI using 'Project Control -…