E1: 12: Fixed Asset Report Writer FAQ
(Doc ID 1510690.1)
Last updated on MARCH 16, 2020
Applies to:JD Edwards EnterpriseOne Fixed Assets - Version 9.0 and later
Information in this document applies to any platform.
Information Center: Overview of JD Edwards EnterpriseOne Fixed Assets > Information Center: Troubleshooting JD Edwards EnterpriseOne Fixed Assets > Document 1510690.1
Purpose of this document is guide how to overcome hidden column in Tabular Report (e.g., R1200002 - Asset Report Writer: Additions and Retirements). Same issue can be occurred any Financial Report Writer, Fixes Asset Report Writer and add-on tabular reports you have created.
Issue & Business Requirement
Currently standard Fixed Asset Report R1200002 (Asset Report Writer: Additions and Retirements) is running based on business view V1201H (F1201/F1202 Joined View with All Fields) which joins two tables F1201 (Asset Master File) and F1202 (Asset Account Balances File).
To generating reports for Fixed Assets, category codes are used from F0006.RP01 (Business Unit Master.Division) as it does for various financial reports, given the Business View (BSVW) V1201H does not include the table F0006. Whereas the pre-defined business view for Financial Report V8300001 (Financial Reporting F0901/F0902/F0006) includes F0006 as referencing table.
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
|Questions and Answers|
|Question 1: How to create a new business view with tables F0006, F1201 and F1202?|
|Question 2: When copying R1200002 it gives Event Rule Validation Error, why and how to overcome it?|
|Question 3: When adding additional level break for columns MCU, RP01 and CO, the value for these columns are treated as RC (Report Constant) and RV (Report Variable).|
|Question 4: Is there any way to convert Tabular Report to Group Section Report or Columnar Section Report? If so, what are the considerations?|
|Question 5: How does the R1200002 (Asset Report Writer: Additions and Retirements) determine which assets will be shown on the report?|