My Oracle Support Banner

E1: 83: Frequently Asked Questions regarding Custom Financial Reports (Doc ID 664740.1)

Last updated on APRIL 04, 2024

Applies to:

JD Edwards EnterpriseOne Report Writer - Version XE and later
Information in this document applies to any platform.

Purpose

This document provides answers to some frequently asked questions on Custom Financial Reports in General Accounting module

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 General Questions
 Question 1: What are the differences between Financial Reports and  Financial Row Reports pre-defined templates?
 Question 2: What are the recommendations for using V8300001 and V8300005 Business Views?
 Question 3: What is the difference between Tabular report and Financial Report/Financial Row Report?
 Question 4: Where do I find more information on usage of Smart fields?
 Question 5: Can I design a report including both row and column overrides?
 Question 6: How do the display decimals work in case of financial reports?
 Question 7: Why do I get an error "R55XXXX--VERSION NAME has caused an exception. Your system may become unstable." when I submit my row report?
 Question 8: Why do I get incorrect results after attaching a custom processing option template with an existing financial report?
 Question 9: Where do you define that a specific account will roll up into another specific account?
 Question 10: Why B9861B BSFN is working correctly locally on fat client, whereas the system is not printing the column headings separately on server?
 Question 11: Is there a way to find what UBE versions have overwrites on them?
 Report Output
 Question 1: Why do I see non-posting accounts (PEC = 'N') inspite of the "Zero row suppression" property being setup at design level?
 Question 2: Why am I getting different results on server compared to local for the same version of financial report?
 Question 3: How can I replace the default company name on financial reports?
 Question 4: How can I add Business Unit information to print on Page Header?
 Question 5: How can I Print the Version Name and/or Version Title on the Page Header Section?
 Question 6: Why can I not sort on the Description field?
 Question 7: Why do I not see any data but only Smart Field column headings and description?
 Question 8: Why do I only see the report data but no Smart Field column headings?
 Question 9: How can rows that do not have amounts be suppressed?
 Question 10: How can the level break header description be suppressed from printing when the values of the level break are zero, because it causing to print pages with just the level break header and nothing else?
 Question 11: Why are Financial reports showing incorrect or no data after row security is revised for a financial user?
 Question 12: How to avoid from printing balances for the months outside of the as of range?
 Export to CSV
 Question 1: How to format a financial report for export to CSV?
 Question 2: How do I define a version of a financial report to always export to CSV?
 Date Titles and Period Names
 Question 1: How can I add user defined date title on a financial report?
 Question 2: Why am I getting blank or incorrect As Of Date Title printed in the header of financial report?
 Question 3: Why is the report printing an incorrect month in the title of the report?
 Question 4: Why do I get "Not found in UDC 83|TS" error, if I inquire upon an existing Date Title using P83100 application?
 Question 5: Why does the visual assist for Elements 01-14 in the Date Title Revisions application (P83100) refer to *|* UDC table?
 Question 6: Is there a way to define the period’s names by Fiscal Year using the Work With Column Headings Program (P83110)?
 Question 7: Experience a performance issue with a custom Financial Report. Are there any BUGs for Financial Reports performance?
 Reverse Sign functionality
 Question 1: How does the Reverse Sign work for Financial Report Writer?
 Question 2: Why are the FS AAI interim sub-totals printing as negative if the Reverse sign processing option is set to '3' and revenues exceed expenses?
 Question 3: Why does the reverse sign functionality not work correctly in conjunction with LOD and AAI subtotaling?
 Question 4: Why is the reverse sign not showing expected results when running with option '3'?
 Question 5: Why the Subtotals for Non-Operating Revenue and Expenses is not reversed, when Income Statement With AAI Subtotal (R10211B) is run with Processing Option Reverse sign = 2?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.