Oracle Assets Troubleshooting Guide for Mass Additions
(Doc ID 1251776.1)
Last updated on JUNE 17, 2022
Applies to:Oracle Assets - Version 18.104.22.168 and later
Information 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.
Troubleshooting Guide for Mass Additions.
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
|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:|
|11. How to resolve the below error which appears when attempting to run Post Mass Additions,|
Please run the Gain/Loss Program before performing this transaction.
Mass Addition ID: XXXXX ==> ** FAILED **
|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?|