My Oracle Support Banner

Oracle Assets Troubleshooting Guide for Mass Additions (Doc ID 1251776.1)

Last updated on JUNE 06, 2019

Applies to:

Oracle Assets - Version 11.5.10.2 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.

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:
 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?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.