Reports
Discussion List
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
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 51 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 81 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 12 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 123 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 58 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 809 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 211 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…
-
Are Named Ranges in excel report output generated by FCCS MR referenced anywhere?Summary: Getting an error message to repair the excel report due to named ranges generated by the application. Need suggestions to deal with it. Content (please ensure y…SanjanaRR 51 views 7 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…Pradeep Moganti 395 views 2 comments 1 point Most recent by User_0P0CT Reporting and Analytics for ERP
-
DFFs missing from few OTBI Subject areasWe have Multiple OTBI reports in which the DFF columns are missing from the subject areas. after running the “Import Oracle Fusion Data Extensions for Transactional Busi…Hitachi ServiceDesk 21 views 4 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM
-
How to check user access statistics for artifacts?Hi, How can we check how many times and which user has accessed a form or report in PBCS application for the past 90 days? Is there some way to get the statistics? We ne…
-
Custom attribute in oracle delivered / seeded HCM extractSummary: Hi experts, Working on Payroll Interface for ADP Global Payroll V2, requiring a pay group field. Pay group field is a DFF stored in attribute 12 of the "per_all…
-
Deep link for Journals to view Journal Entry ScreenSummary: Hi Team, Need some details about the Deep link for Journals to view the Journal. In BIP report on Journal Batch Name column , respective journals can be opened …
-
Extract Invoice attachment with Rest API Fusion ERP CloudSummary usingContent The following help page documents how to use the Get an attachment for an invoice Rest API. Running the codes gives me a similar response as per the…
-
How can I retain the drill down selection from the previous run in my narrative reporting?We have a report that requires the user to perform multiple drill-down actions. The user finds it tedious to have to repeat these drill-down steps each time they want to…
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …Winky Chan 81 views 4 comments 0 points Most recent by Sudhir Behera Reporting and Analytics for ERP