Oracle Assets Adjustments API Documentation Supplement
(Doc ID 206474.1)
Last updated on JUNE 08, 2022
Applies to:Oracle Assets - Version 18.104.22.168 and later
Information in this document applies to any platform.
Oracle Assets Adjustments API
You can use the Adjustments API to adjust assets directly via PL/SQL rather than using the Oracle Assets interfaces listed above. The Adjustments API uses the FA_ADJUSTMENT_PUB.DO_ADJUSTMENT procedure. You can use this API if you have a custom interface that makes it difficult to use with the existing Oracle Assets interfaces for adjusting assets.
The Adjustments API allows you to automatically adjust the asset to the corporate book, as well as to the dependent tax books.
Oracle Assets also allows you to adjust assets using the following methods: You can adjust assets using the Asset Workbench (using the Source Lines and Books windows), Mass Additions, Mass Change, Mass Copy, and Tax Upload Interface user interfaces.
- Mass Additions: You use the Mass Additions process to make cost adjustments to existing assets.
- Mass Change: You use the Mass Change process to change financial information for existing assets.
- Mass Copy: You use the Mass Copy process to add existing assets to tax books.
- Cost Adjustments: You use the Upload Tax Book Interface to adjust cost and financial information in both Corp and Tax Books. Note that reserve can only be modified in period of addition.
- Asset Workbench: You use the Asset Workbench to make changes to individual assets.
The Adjustment API will create new lines in fa_asset_invoices in all cases. This is true even if the intent of the adjustment is to modify an existing adjustment.
You cannot adjust the Depreciate Flag of an asset as an adjustment that also adjusts other features. Accordingly, if you wish to adjust Depreciate Flag you will need to submit the API twice to also adjust other values. It should also be noted that an adjustment involving only the Depreciate Flag does not follow standard expensed or amortized logic, and will not trigger catchup depreciation. This is standard behavior of the application.
The Adjustment API will force a rollback of periodic depreciation if the adjustment is done after preliminary depreciation is complete for a period in R12. This is standard behavior in R12. In 11i, however, the Adjustment API will not complete normally if periodic depreciation has been taken already, and users will need to rollback the book before using the API.
Alternate Ledger Currencies / Secondary Ledgers
If you have set up Reporting Currencies on your Corporate book(s) or Tax book(s) or have attached a Secondary Ledger to your Tax book(s), when you adjust assets using the Adjustments API, the API automatically adds these adjustments to the relevant books. You will need to supply a rate for Cost Adjustments.
This document covers use of the Adjustment API for basic adjustments with and without invoice information attached.
See <Note 456064.1> for a discussion of use of this API for Group Asset Member Reclasses; a sample script for that is available there as well.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!