Assets faq:standard reports-top Issues [ID 109758.1]

Assets faq:standard reports-top Issues [ID 109758.1]--------------------------------------------------------- -----------------------modification time 17-apr-2005 type Bulletin status published * * * IMPORTANT * * * help us improve our service. If you are have any comments or questions regarding the solution as documented into this note (or no other questions related to Oracle Assets), please post on the Oracle Assets technical Forum at the following Url:http://metalink.oracle.com/metalin K/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 the time is generally within. Thank for using metalink! Purpose-------The purpose of this document are to educate customers and support analysts on the most common /problems that are asked of the Oracle Assets standard reports. Following are common questions from our customers and their associated. SCOPE & Application-------------------This document can is used by Oracle Support analysts as as-technical and F Unctional customers. #1-asset Additions report-fas420---------------------------------------------------Q. When submitting the "Asset additions", the periods are missing in the List of Values (LOV). In some cases, your get the error message:app-01436 list of values cannot find no values for your to choose. A. There is a table in Fixed Assets called Fa_deprn_periods. When a depreciation the book are created, two rows should be inserted to the table-the current period and one period us. On occasion, the previous period does don't get inserted into the table. The Asset additions The has logic that looks for at least to rows in the table. To resolve this issue, the previous period row needs to is inserted into fa_deprn_periods. Q. The Asset additions the returning No Data Found after submission. A. Make sure this you have run depreciation at LEAsT once for the "book" You are running the ". The logic of the "looks" for a D row in the Fa_deprn_summary table, and, if depreciation has not been run, you'll o Nly have a B row in Fa_deprn_summary. Also, you are must have run depreciation for the period this you are running the "the" to the were made that period. Make sure so you are on the latest version of the. There were several code changes to the logic of the The "the" to resolve this issue. To find the version of the Report:at UNIX prompt:release 10.7% cd $FA _TOP/SRW $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. A. The year-to-date depreciation and depreciation reserve columns'll only reflect the YTD and Reserve amounts the A Sset had when added. Therefore, if your asset is added to the system with no year-to-date or Reserve amounts, the show would show zero in these columns. Q. Why doesn ' t my Asset additions (FAS420) reserve balance to the reserve Detail (fasrsved)?? A. The Asset addition to the reports what the reserve was then Asset was added. Q. The Asset addition the showing CIP Assets with cost in both the Asset type CIP totals and also the Asset type Cap italized totals. How come? A. The asset was added as a CIP and then capitalized within the timeframe this you are running the. Therefore, it was a new CIP addition as "a" new asset addition within the time specified. Q. When running the "Asset additions", I get a error saying that all segments are not populated?? A. Go to Sysadmin, System profile Options and set-Option, flexfields:validate on Server to ' NO '. #2 Property Tax report-fas460---------------------------------Q. The property Tax the showing of No data Found or not showing the the. A. These issues usually boil the "parameter", end Date acquired. The end date acquired are a system date when a asset be modified in the system (added, retired, etc.,)-not the date pl aced in service. Also, the end date acquired needs to being equal to the "Last Day", a period is open. Therefore, if you add a asset March 1st DPIs to June, 1999 and ran depreciation for March on March 31st. Y OU would not-asset appear on the property tax the "on" until your run it with a end date acquired of March 31st. Q. You are are attempting to submit the property Tax, the "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 are trying to run the property Tax A (FAS460), but get the following error:app-01050:this Flexfield be o penedBecause it has no displayed egments. A. Make sure the State Flexfield qualifier are 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 is the data by State segment. In order of this functionality, your must define which segment in the location. #3 Tax Reserve ledger-fas480------------------------------Q. I do not periods in my list of values when trying to submit the Tax Reserve ledger?? A. Only closed periods would appear in the list of values. Q. When performing a mass to depreciation methods for a-tax book, the change isn't reflected in the tax Reserve Le Dger. A. The change date effective must being before the period that the "the" is ran for. For example, if you change yourR depreciation method and make the change effective 01-dec-01 and your run the "for 01-jan-01", you are not the C Hanges. #4/5-Cost/cip Detail and Summary reports-fascostd and Fascosts------------------------------------------------------ ------------Q. Executing the cost Summary-resulted in error:rep-0452, Ora-1400 A. Upgrade your P.ODF file to version 110.5 or higher (currently patch 928017). Q. Experiencing performance issues running the cost Summary and/or. A. Apply patches 1084211 and pre-requisites 740124, 824830 for version one (FAMRC.ODF 110.23 or higher and Faxdridx.sql 110. 2 or higher), 1584277 for 11.i and run Gather schemas Statistics If you are the using cost Based Optimizer. Q. The amounts on the cost Detail and/or Summary Reports are. A. The document CR 282764:reconciling cost Metalink. #6-journal Entry Reserve ledger-fas400------------------------------------------Q. Why is the cost center FieLD appearing in the "Company field" on the JE Reserve ledger?? A. This is bug:812175 in 10.7 and 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, 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 ". "note:102409.1 on" and "do" this. Q. FAS400 is experiencing poor performance, what can are done?? A. Verify that, 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, why are this?? A. The JE Reserve ledger to show capitalized assets, not CIP or expensed assets. #7 Mass Additions delete-fas829---------------------------------Q. After submitting the Mass additions Delete, it has a message of ' No DatA Found '. A. The Mass additions deletes the "A" and "assets" were deleted by virtue of the have been in the ' delete ' queue . However, when you submit the Delete Mass additions process, it isn't only deletes the Mass additions this were in the delete Queue (additions that you would truly want deleted), but also, automatically deletes-assets-were in the ' POSTED ' Queu e because once posted, and therefore has become assets, they are no longer needed in the Fa_mass_additions table (a CLE an-up measure). #8 Asset Transfer Reconciliation report-fas431------------------------------------------------Q. The Asset Transfer Reconciliation is erroring if the Period to parameter are not entered. The error is:rep-1401: ' Period2_pcformula ': A fatal error has occurred ora-1403:no data found a. This is Bugs 1943626 and has been corrected in 11i minipack G-1974812. RELATED DOCUMENTS-----------------note:108446.1-fixed Assets Reports Troubleshooting Guide