Reports
Discussion List
-
Why FRS Range Function with Relative Member Offset Not Returning Expected Period DataSummary: We are encountering an issue in Financial Reporting Studio (FRS) while using the Range function with the Relative Member function to display Current Year (CY) a…Mahesh Munagala 22 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Question marks appearing in custom eText outputSummary: Custom eText payment format in BI Publisher has question marks inserted into output. Content (please ensure you mask any confidential information): I have creat… -
Creation of new FCCS application for IFRS18 with 3 years of dataHi, We have a production live Pre-IFRS18 FCCS application with data starting from FY23. However, we are looking to backup current Pre-IFRS18 FCCS application and replace…Batul Rangwala 86 views 6 comments 0 points Most recent by Ramith Attravanam Financial Consolidation and Close -
Best way to handle rounding in reportsSummary: Currently, we are handling rounding and footing by having an unrounded hidden column and using the round function in a visible column. At each section of the ba…Karla McMillan IBM 2 views 0 comments 0 points Started by Karla McMillan IBM Financial Consolidation and Close -
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 31 views 6 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for ERP -
Nested Functions in Narrative Reporting Not Returning DataSummary: Nested function in Relative Member does not return values. Content (please ensure you mask any confidential information): Hi there, I'm creating a report in Nar…
-
ESS-01035 Unable to determine a logical application name for new request running new jobset in UII am defining a jobset for the first time, to work in financials for Advanced Collections. I have identified how to create the jobset under Manage Enterprise Scheduler J…Susan Hathaway 44 views 2 comments 0 points Most recent by Susan Hathaway Reporting and Analytics for ERP -
Feasibility of Deep Link Navigation Between Enterprise Contracts and Lease Accounting ModulesOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Telenor Towers Norway AS Description …SURYA NARAYANAN ANDAVARAJ 1 view 0 comments 1 point Started by SURYA NARAYANAN ANDAVARAJ Lease Accounting -
Comparison between two fields in rtf templateSummary: Comparison between two fields in rtf template Content (please ensure you mask any confidential information): In the RTF template, we need to conditionally displ… -
How to report on worker Area of Responsibility records assigned?Currently created an analysis report in OTBI to pull Area of Responsibility records against current active employee records. Tried testing with a variety of ways with di… -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by Rajdeep_Chavda Reporting and Analytics for HCM -
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 391 views 5 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
Supplemental Data Manager Report Fails After Migration/Cloning with errorHi Team, We have created several Non-Consolidation Reports for Supplemental Data Manager (SDM), and they work correctly in the source environment with the generated repo…rahul shinde 30 views 1 comment 0 points Most recent by Tom LeFebvre-Oracle Financial Consolidation and Close -
How can we print different Logo based on LE name in EXCEL BIP TemplateSummary: For the Excel template, we have a requirement to print the logo based on the Legal Employer selected in the parameter while running the report. This requirement… -
Payroll Reports Performance Impact After 26C Introduction of "Quick Pay" TaskSummary: Hi everyone We are experiencing a significant performance degradation in a custom BI Publisher payroll reports after our environment was updated to release 26C.…PavelACT 10 views 1 comment 0 points Most recent by Barry Goodsell - LNER Reporting and Analytics for HCM -
is there any option to call the FRS reports from OICSummary: We have requirement to call the FRS reports from OIC and to push the output to SFTP. Is there any option like we call BI reports. Content (please ensure you mas… -
Web Forms opened in SmartView IssueSummary: Web Forms opened in SmartView is showing Zero values in Blank Formula Rows and Columns. Anyone has experience the same? Content (please ensure you mask any conf…Kenneth John Asper-Oracle 256 views 15 comments 1 point Most recent by Ija Vidaurri Financial Consolidation and Close -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 118 views 20 comments 0 points Most recent by Milan_Chandra Reporting and Analytics for HCM -
Consolidation Journal Report not includes submitted by detailsSummary: As per the current system, the Status Consolidation Journal Report includes the Created By details but does not capture the Submitted By details. We also need t…Prerna Datey-Oracle 10 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Report to monitor payables invoice rejections due to invalid approval rulesSummary: Any seeded report to monitor payables invoice rejections rejected due to invalid approval rules. These kind of rejections can be viewed only in Transaction cons… -
Integration issues with EPM post 26.07 updateSummary: We are finding some of our existing integrations into EPM have broken post 26.07 update Content (please ensure you mask any confidential information): Is anyone…John_H_FusionApps 971 views 65 comments 0 points Most recent by Laura Reichert-271115 EPM Platform and Freeform -
FCCS FR Report Books throw Error - Refused to ConnectSummary: When trying to run an existing FR Report Book in FCCS and EPBCS Production, we see an error: epm-xxxxxx.epm.us6.oraclecloud.com refused to connect. We do not se…Thiru Vedantham 42 views 8 comments 0 points Most recent by Paras Negi Financial Consolidation and Close -
Activity Report Download EPM Automate Cannot Find FileSummary: Running EPM Automate to download the daily activity reports cannot find the html file anymore. Content (please ensure you mask any confidential information): We…William Macale 50 views 5 comments 0 points Most recent by William Macale Financial Consolidation and Close -
Reporting Pack - Assigning task by AccountSummary: I created a reporting pack (PDF Report Type) with reports that have Inline Grid notes that the business needs to enter comments based on accounts variance over … -
Query to display the Phases and States of the CSP in OBIContent Hi Experts, I am looking for a OBI query to display the Phases and States which are associated to the CSP. Regards, Harish Version 20DHarish Vummidi 68 views 5 comments 0 points Most recent by Stanciu Maria Reporting and Analytics for HCM -
on Redwood page using Guided Journey- BI report bind parametersSummary: To show/embed BI report link on the redwood page and pass the assignment id of the logged in employee as a bind parameter to the path , tried using below &_xmod… -
How to create a view only Lease accounting Role ?Summary: How to create a view only Role for Lease Accounting that also provides a user access to run the following reports: i) generate lease liability analysis report i… -
what is the syntax for a variance calculation using column referencing currentPOVI have a column A using CurrentPOV for the Years dimension. I cannot locate the correct syntax to reference in a Variance calculation. I know the Variance function will …