Oracle Assets Troubleshooting Guide for Mass Additions
(Doc ID 1251776.1)
Last updated on AUGUST 28, 2023
Applies to:
Oracle Assets - Version 11.5.10.2 and laterInformation in this document applies to any platform.
FAMAPT - Post Mass Additions
FAMACR - Mass Additions Create
This knowledge document is a replacement for 820793.1 which has been deleted.
Purpose
Troubleshooting Guide for Mass Additions.
Troubleshooting Steps
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 |
| Troubleshooting Steps |
| 1. Why post mass addition program errors with: 'FA_MASSADD_CHILD_LOC_NULL' while trying to change Mass Addition from 'ON HOLD' to 'POST' ? |
| 2. When trying to run the post mass addition program, why is a particular book is not appearing in LOV ? |
| 3. How to correct error ORA-01400: cannot insert NULL into FA_ADDITIONS_B.CURRENT_UNITS ? |
| 4. While attempting to set mass addition line to POST status, the following error occurs: The maximum value size for segment XXXX is 2. Truncating value OTHER.XXXX.XXX.XX to OT |
| 5. How to resolve the error 'Cache: Error retrieving row from FA_METHODS table' in Post mass addition program ? |
| 6. Post mass addition program errors with: Error: Incorrect Asset Type and Category combination for &CATEGORY_ID. |
| 7. How to resolve EXPENSE CCID CANNOT BE NULL error messages during Mass Additions ? |
| 8. When attempting to query project details in Mass Additions form or in Assets form, the following error is shown ORA-01403: no data found ORA-06512: at "APPS.PA_UTILS", line 1315 |
| 9. How to resolve the below error when querying the invoice in Prepare Mass Additions from, FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception |
| 10. Why error APP-OFA-47777: This Book is not setup for this Category appears when attempting to assign asset category in the prepare mass addition form: |
| 12. Why asset_type field is not populated for Asset lines that are loaded into the FA_MASS_ADDITIONS table by SQL*Loader |
| 13. Post mass addition program is erring with: APP-482858 ASSET NUMBER already exists. Please enter a new value. |
| 14. Post mass addition program is erring with: APP-OFA-47011: Error: Failed to process the add_to_asset function call |
| 15. Post mass addition program is erring with: APP-47010: Error: Failed to get Prorate Date and Depreciation Start Date. |
| 16. Why error "Please choose an existing combination" appears when trying to save a record in Asset Workbench or Prepare Mass Addition form ? |
| 17. When trying to retire an asset, below error message appears: APP-47434 you must post mass additions before you retire the asset. |
| 18. Post mass addition program is erring with: APP-00988 ORACLE error 1403 in get_date And APP-47010 Error: failed to get prorate date and depreciation start date. |
| 19. How to resolve 'APP-47777 This book is not setup for this asset category'. appearing while trying to post the mass addition line ? |
| 20. Post mass addition program ends with error: Error: function fa_massadd_pkg.do_mass_addition returned failure And Cache: Error retrieving row from FA_CATEGORY_BOOK_DEFAULTS table for: |
| 21. Post Mass Additions is failing with the following error: You cannot expense an adjustment to an asset for which you have already Amortized an adjustment.Please Amortize this adjustment. |
| 22. Why Post Mass addition program is failing with Error Message: Asset Key CCID cannot be NULL ? |
| 23. Post mass addition program is erring with: Cache: Error retrieving row from FA_CATEGORY_BOOK_DEFAULTS table for: , Category ID: XXX , Book: xxxx |
| 24. Mass Additions Post fails with the following errors in the log file: Request ID: XXX , Cache: Error retrieving row from FA_METHODS table , Depreciation Method: STL , Life in Months: 60 |
| Still Have Questions? |
| References |