My Oracle Support Banner

E1: 12: Fixed Asset Report Writer FAQ (Doc ID 1510690.1)

Last updated on MAY 24, 2023

Applies to:

JD Edwards EnterpriseOne Fixed Assets - Version 9.0 and later
Information in this document applies to any platform.

Purpose

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.

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
 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?
References


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