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 |