Assets FAQ: Standard Reports - TOP Report Issues [ID 109758.1]

Assets FAQ: Standard Reports - TOP Report Issues [ID 109758.1] -------------------------------------------------------------------------------- 修改时间 17-APR-2005 类型 BULLETIN 状态 PUBLISHED *** IMPORTANT *** Help us improve our service. If you have any comments or questions regarding the solution as documented in this Note (or ANY other questions related to Oracle Assets), please post on the Oracle Assets Technical Forum at the following URL: http://metalink.oracle.com/metalink/plsql/for_main.fetchForum?p_forum_id=73&p_after_post=N&p_forum_scope=a&p_forum_time=7 The FA Forum is monitored on a daily basis by Oracle Support Services (OSS), and response time is generally within 24 hours. Thank you for using MetaLink! PURPOSE ------- The purpose of this document is to educate customers and support analysts on the the most common questions/problems that are asked of the Oracle Assets standard reports. Following are common questions from our customers and their associated answers. SCOPE & APPLICATION ------------------- This document can be used by Oracle Support Analysts as well as technical and functional customers. #1 - Asset Additions Report - FAS420 --------------------------------------------------- Q. When submitting the Asset Additions Report, the periods are missing in the List of Values (LOV). In some cases, you get the error message: APP-01436 list of values cannot find any values for you to choose. A. There is a table in Fixed Assets called FA_DEPRN_PERIODS. When a depreciation book is created, two rows should be inserted into the table - the current period and one period previous. On occasion, the previous period does not get inserted into the table. The Asset Additions Report has logic that looks for at least two rows in the table. To resolve this issue, the previous period row needs to be inserted into FA_DEPRN_PERIODS. Q. The Asset Additions Report is returning No Data Found after submission. A. Make sure that you have run Depreciation at least once for the book that you are running the report. The logic of the report looks for a D row in the FA_DEPRN_SUMMARY table, and, if depreciation has not been run, you will only have a B row in FA_DEPRN_SUMMARY. Also, you must have run depreciation for the period that you are running the report for in order to see any additions that were made that period. Make sure that you are on the latest version of the report. There were several code changes to the logic of the report to resolve this issue. To find the version of the report: At UNIX prompt: Release 10.7 % cd $FA_TOP/srw Release 11 % cd $FA_TOP/reports % strings -a FASAAMTD.rdf|grep 'Header' Windows NT: find /i "Header" FASAAMTD.rdf Q. The Year-to-Date Depreciation and Depreciation Reserve columns are showing incorrect amounts. A. The Year-to-Date Depreciation and Depreciation Reserve columns will only reflect the YTD and Reserve amounts that the asset had when added. Therefore, if your asset was added to the system with no Year-to-Date or Reserve amounts, the report will show zero in these columns. Q. Why doesn't my Asset Additions (FAS420) reserve balance to the Reserve Detail Report (FASRSVED)?? A. The Asset Addition report only reports what the reserve was when asset was added. Q. The Asset Addition report is showing CIP Assets with Cost in both the Asset Type CIP Totals and also the Asset Type Capitalized Totals. How come? A. The asset was added as a CIP and then capitalized within the timeframe that you are running the report. Therefore, it was a new CIP addition as well as a new asset addition within the time specified. Q. When running the Asset Additions Report, I get an error saying that all segments are not populated?? A. Go to Sysadmin, System Profile Options and set the Profile Option, Flexfields: Validate on Server to 'NO'. #2 Property Tax Report - FAS460 --------------------------------- Q. The Property Tax Report is showing No Data Found or not showing the data that you expect to see on the report. A. These issues usually boil down to the report parameter, End Date Acquired. The end date acquired is a system date when an asset was modified in the system (added, retired, etc., ) - NOT the date placed in service. Also, the end date acquired needs to be equal to the last day that a period is open. Therefore, if you add an asset March 1st 2000 with a DPIS of June 15, 1999 and ran depreciation for March on March 31st. You would not see this asset appear on the property tax report until you run it with an end date acquired of March 31st. Q. You are attempting to submit the Property Tax Report and you get an error message, "Values have not been entered for 1 or more required segments". A. Under System Administrator Responsibility: Navigation: Profile Options => System Query up profile option Flexfields:Validate on Server. Set this profile option to No. Q. You are trying to run the Property Tax Report (FAS460), but get the following error: APP-01050: This flexfield cannot be opened because it has no displayed egments. A. Make sure the state flexfield qualifier is set up. Navigation Path: / Set Up / Financials / Flexfields / Key / Segments Query the Location Flexfield. Unfreeze the flexfield definition. Select the "Segments" button, then the "Flexfield Qualifiers" button. Save the change. Freeze the flexfield definition. Recompile the flexfield. The Property Tax Report will sort the data by state segment. In order to use this functionality, you must define which segment in the location flexfield is the state. #3 Tax Reserve Ledger - FAS480 ------------------------------ Q. I see no periods in my list of values when trying to submit the Tax Reserve Ledger Report?? A. Only closed periods will appear in the list of values. Q. When performing a mass change on depreciation methods for a tax book, the change is not reflected in the Tax Reserve Ledger report. A. The change date effective must be before the period that the report is ran for. For example, if you change your depreciation method and make the change effective 01-DEC-01 and you run the report for 01-JAN-01, you will not see the changes. #4/5 - Cost/CIP Detail and Summary Reports - FASCOSTD and FASCOSTS ------------------------------------------------------------------ Q. Executing the Cost Summary report in Release 11 resulted in Error: Rep-0452, Ora-1400 A. Upgrade your farep.odf file to version 110.5 or higher(currently patch 928017). Q. Experiencing performance issues running the Cost Summary and/or Detail reports. A. Apply patches 1084211 and pre-requisites 740124, 824830 for version 11(Famrc.odf 110.23 or higher and Faxdridx.sql 110.2 or higher), 1584277 for 11.i and run Gather Schema Statistics if you are using Cost Based Optimizer. Q. The amounts on the Cost Detail and/or Summary Reports are out-of-balance. A. See document CR 282764: Reconciling Cost Report on Metalink. #6 - Journal Entry Reserve Ledger - FAS400 ------------------------------------------ Q. Why is the cost center field appearing in the company field on the JE Reserve Ledger Report?? A. This is BUG:812175 in 10.7 and you can download the patch from MetaLink. Or, you can apply the latest FA Patchset to get current version of all executables and reports. Q. When running the FAS400 report, it is erroring with: REP-00736 - There exists uncompiled program units. REP-01247 - Report contains uncompiled PL/SQL. A. You need to re-attach your libraries to the report. See Note:102409.1 on how to do this. Q. FAS400 is experiencing poor performance, what can be done?? A. Verify that you are on the latest version of FAS400.rdf and FARSV.pld. You can download the latest FA Patchset directly from MetaLink. Q. Some assets are not appearing on the FAS400 report, why is this?? A. The JE Reserve Ledger Report will only show Capitalized assets, not CIP or Expensed assets. #7 Mass Additions Delete - FAS829 --------------------------------- Q. After submitting the Mass Additions Delete Report, it has a message of 'No Data Found'. A. The Mass Additions Delete Report will only show assets that were deleted by virtue of having been in the 'DELETE' queue. However, when you submit the Delete Mass Additions process, it not only deletes the mass additions that were in the Delete queue (additions that you would truly want deleted), but also automatically deletes assets that were in the 'POSTED' queue because once posted, and therefore having become assets, they are no longer needed in the fa_mass_additions table (a clean-up measure). #8 Asset Transfer Reconciliation Report - FAS431 ------------------------------------------------ Q. The Asset Transfer Reconciliation report is erroring if the Period To parameter is not entered. The error is: REP-1401 : 'period2_pcformula' : a fatal error has occurred ORA-1403 : no data found A. This is bug 1943626 and has been corrected in 11i Minipack G - 1974812. RELATED DOCUMENTS ----------------- Note:108446.1 - Fixed Assets Reports Troubleshooting Guide