Reports
Discussion List
-
can we hide a WF Notification hyperlink with BIP and RTF template based on a security roleSummary: HI Reporting and Analytics forum esp BI Publisher gurus: Is there is an easy way to hide a URL hyperlink on a Notification page (RTF BI Report -side) also based… -
Reports with planning merge cell not workingSummary: Content (please ensure you mask any confidential information): Hi All We have an issue we 2 similar report with Merge Cells that should display this : desv. REA… -
Where to get the file size of Work Order AttachmentI have created this query to pull the attachments for Work Order, I need to get the file size for each attachment. Is the object_size the right column to use to know the… -
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf templateLakshmiVanarasi 21 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
Reports: After migration of REPORT getting errors about reference accuracySummary: Content (please ensure you mask any confidential information): Hi all We are in the FR reporting migration process to REPORTS within FCCS. We have come across t… -
Help! Need to increase Font SizeHi We are working on our Line Manager Dashboard. We would like to add a custom tab in the dashboard. The tab would be all text as we want to add key definitions for some… -
disable send button in bi report output and deliveryHi Team, is there a way we can disable/hide "send " button in bi publisher report output and delivery section in report history page -
Can we display alpha numeric values in Pivot table?Summary: Can we display alpha numeric values in Pivot table? Content (please ensure you mask any confidential information): We have a requirement to fetch the UDT (User … -
Need the tables that stores AR Receipts: Receipt Type, Status and Refundable deposit statusHi Experts, I need the table names that stores Receipt Type, Status and Refundable deposit status in Manage Receipts UI in oracle fusion. I used, AR_CASH_RECEIPTS_ALL AR…Krishan_Palihakkara 140 views 1 comment 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for ERP -
No language pack but still errors coming in Hungarian LanguageWe have language pack installed but Hungarian language is not enabled. But still our users are receiving errors in Hungarian language Nincs eredimeny - No Results Found -
Count of All Performance Goals is not showing properlySummary: Hello, can you pls check my filters below. The Count of All Performance Goals is not showing properly so I added the Goal Status filter but still not showing up… -
FCCS IC Report display numbers as textHi All, I'm trying to get the Intercompany report to display the numbers as value when opening in Excel. As advised by Oracle, I have added the Substitution Variable 'En…Marie Traverso 52 views 10 comments 0 points Most recent by Marie Traverso Financial Consolidation and Close -
Does anyone know formula for Turnover% in Line Manager DashboardDoes anyone know formula for Turnover% in Line Manager Dashboard ? or do we need to edit the report, check the query and find it out ourselves. There is literally no doc… -
Map Monitor Audit Report data retention?Summary: We have enabled map audit. Client is asking how long will the FCCS system retain this mapping audit information? Version: Service: Enterprise Performance Manage…Shawn Paperwala 84 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve? -
How to Hide Row in BI Publisher Using Conditional RegionSummary: Hi Expert, I'm trying to hide a row based on a simple condition. We have three rows in the offer letter, and the condition is that if the attribute value is nul… -
FCC Reports build through designer is not visible in Smart ViewSummary: FCC Reports build through designer is not visible in Smart View Content (please ensure you mask any confidential information): Web: Report 'Test' visible in Web…YogeshKJain 31 views 5 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
Soppression in ReportHello, in a report I have a data column with suppression if data is zero or missing, and 2 subsequent formula columns, on all 3 columns I apply conditional suppression t… -
Historical Location Data Workforce Learning - Learning Records Real TimeSummary: Content (please ensure you mask any confidential information): We have started to move our reports to the Workforce Learning - Learning Records Real Time as the…Jeremy CSC 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Getting error while bursting BIP report output to sFTP serverSummary: Getting below error while bursting BIP report output to sFTP server- Below is my SFTP bursting query- *with hash_q as query* select distinct HASH "KEY", 'MicroS…Neha Aishwarya 142 views 1 comment 1 point Most recent by Lucy Garding Reporting and Analytics for ERP -
Transaction console approvals reportThe user is asking for a BI report that shows all the approvals for a transaction in HCM, right now I'm able to find the current and historical approvals but I can't fin…RODOLFO GARCIA SOTELO 53 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Download older version of snapshot in Oracle NRIs there a way to download daily maintenance snapshot in Oracle Narrative Reporting for an old specific date (For example - I want a 10 days old snapshot). Currently I a… -
How we can password protected a bursting BIP report?Summary I want to burst person Information and i want the output file should be password protected with person DOB(MM-DD-YYYY). How we can achieve this using burstingCon…Ashish Mangal 837 views 9 comments 0 points Most recent by Bhanuja Batra-Oracle Reporting and Analytics for HCM -
How to bring HCM UDT Columns into Fusion OTBI subject areaSummary: Need to access the UDT columns (HCM) in OTBI standard subject area's instead of using the "Payroll - User Defined Tables Real Time" as a separate subject area. … -
How to identify who made changes to the DFFs we used in our OTBI reports?Summary: There are few OTBI reports in Dev env which resulted in error because of missing DFFs. we got the DFFs back by running the schedule process. but we want to know…Hitachi ServiceDesk 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
How to filter a column?Summary: Hello, I need help on how could I filter to show only the last row. Thank you in advance! Content (please ensure you mask any confidential information): Version… -
How to write a query to get accurate "when is the employee start date?" from the OfferSummary: Hi Team, We are trying to add value for "When is the employee start date?" in one of ours Offer accepted report. However when the employee start date is changin… -
Multiple Templates - BI Publisher BurstingSummary Multiple Templates - BI Publisher BurstingContent Hi Experts I have a BI bursting report where we need to send an attachment as well as the bursting email notifi…Mansur Khalil 214 views 7 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM -
Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES TableSummary: Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES Table Content (required): Hi All, Can anyone please let me know the use of the column PAYROLL_CHG_FLAG in ANC…