Reports
Discussion List
-
how to suppress 0 data in FCCS reportsWe have two test environments and when I open the same report it shows different row counts. In test environment A, there are some entities that are not visible in Test …Patrick Pontillas 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP -
Learning Management - Activity Completion DateSummary: Hi - I am trying to build an OTBI report that would show all activities in a course at the employee level and whether or not they have completed that activity o…
-
Need help in creating new Talent Profile printable versionSummary: How to create new Talent Profile printable versionRavindr-Oracle 11 views 2 comments 0 points Most recent by Christine Yokoi-Oracle Reporting and Analytics for HCM
-
Batch Scheduler FunctionalitySummary: Is batch Scheduler Changing? Content (please ensure you mask any confidential information): FR is going away in June 2025. Currently we use batch scheduler to r…
-
Is it possible to Freeze additional columns/rows in EPRCS reports apart from the default ones?Only default rows/columns are freezing in EPRCS reports. We need additional two columns to be freeze which are text columns, and it contains account descriptions and its…Pramila Sakthivel 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
DM for an Emergency Contact ReportHi Sorry if this has been asked before and I see a number of reports in OTBI but I am looking to see if someone has a data model for an Emergency Contact report. I am lo… -
what is the formula or calculation logic for lease revenueSummary: what is the formula or calculation logic for lease revenue? In lease details report for revenue lease, we can find the lease revenue column on Payment Amortizat…
-
Extract XML or output from ESS jobSummary: Is there a way to extract XML or output from ESS job through SOAP webservice, or REST to outside of Oracle fusion Content (please ensure you mask any confidenti…Sunil Pradhan 81 views 4 comments 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
talent profileSummary: hi, Could I get the pending transaction data (includes items data) which is under approval for employee talent profile. Content (please ensure you mask any conf…User_L2S8E 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
NRCS Suppression settings for Departments with no DataHi All, We have a NRCS report using a PBCS application as Data source. We need to suppress the full report if any department has No Data. We have tried different combina…
-
Issue post moving FR reports from one folder to another within the Explore repositoryWhen we move a specific FR report from one folder to another within the explore repository, the refreshable version of the report in smartview stops to work. The excel t…
-
Table to find instance name/Environment NameHi Team, Could you please share a table or SQL to find the instance name, when values would be DEV1, DEV2, or PROD. I have already checked the ASK_DEPLOYED_DOMAINS table…Swapnil Kashid 581 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
actual vs budget bi publisher based on COASummary: Hi, is there a BIP report where we can extract initial budget and adjusted amount for chart of accounts 1-3. Content (please ensure you mask any confidential in…
-
Report only one sheet excelSummary: Hi, migrating the reports from Financial Reporting to Report, we noticed that downloading the report in Excel on Financial Reporting inserted the report in a si… -
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 793 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a report migration tool for migrating HFM reports to FCCS Management Reporting?Summary: Is there a report migration tool for migrating HFM reports to FCCS Management Reporting? Content (please ensure you mask any confidential information): I believ…Jack Traynor 41 views 3 comments 0 points Most recent by Vlad Rusu-Oracle Financial Consolidation and Close -
Position Request Status ReportHello, I am looking for a report that will give me all the positions requested for New Position, Backfill/Replacement, and Promotion by leader. Ideally the report captur…
-
Report on User Name Last Updated DateSummary: I'm looking for a report to tell me the last updated date / last updated by for the User Name, please Content (please ensure you mask any confidential informati…
-
How to fetch comments and attachments from hcm extract and bip report?Summary: I want to know, how to fetch comments and attachments from HCM extract and BIPreport? Content (required): Version (include the version you are using, if applica…
-
25A-SOAK- Project Reports ending into errorProject Summary Reports are ending in error with below message. The same reports are up and running in Production and other environments where 25A has not yet been appli…Tina_Motwani 21 views 2 comments 0 points Most recent by Sue Gordon - Frontera Consulting UK Project Management
-
OTBI filter - Two columns don't matchSummary: Is it possible to create a filter (maybe a new column to calculate?) to only provide results if two columns don't match? I can't imagine it's a common thing, bu…
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
For the custom reports User is not able to see the data in the report outputSummary: For the Custom Reports, users are not able to view the data when they run the report. Content (please ensure you mask any confidential information): Version (in…
-
OTBI - Read Only ModeSummary: I have a service account that is set to Read Only Mode within Fusion, however when navigating into OTBI the account is no longer in read only mode and can edit,…
-
Smartview account description truncatingSummary: The customer has identified that the account description in Smart View (ESS) is truncating to 80 characters. This is making account identification by name impos…Maria Smith- de Novo Solutions 21 views 4 comments 0 points Most recent by NarayananS Financial Consolidation and Close
-
Is there any way to view report usage in Planning?Summary: My organization is interested in seeing how many times the reports we have developed have been run. Is a there any way to view this data? There doesn't appear t… -
Benefit Enrollment Report which has all Life events and the Enrollments in an excel format?Summary: Content (please ensure you mask any confidential information): Can someone share the report format where we have the following format Effective date Life event …Hariharan_Sivan 11 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Query to get the final approver of AP InvoiceSummary: Hello, We have a requirement to fetch only final approver details along with Invoice/Requisition in a Invoice and requisition workflow report. Current report is…Sushmitha G 147 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP