Blog / Category
Fixed Assets
6 articles in this category
Fixed Asset- Split Transaction
Introduction/ Issue In this document we shall see how to perform SPLIT in Fixed asset Split Divide an asset into separate units. Use the Split Assets routine to…
Fixed Asset- Depreciation
Hi All Introduction: Depreciation This Blog will explain about the Deprecation calculations What is Depreciation? Assets calculates depreciation using either th…
Query to get Asset Remaining Life
SELECT DISTINCT fb.asset_number, fab.book_type_code, (SELECT CASE WHEN decode(faab.conversion_date, NULL, faab.life_in_months-floor(months_between(fdpp.calender…
Query to get Lease assets – Oracle EBS to Fusion
Introduction: This blog has the SQL query that can be used to pull the lease assets details per asset book for EBS to Cloud data migration. SQL Query: SELECT fb…
ASSET DEPRECIATION LOGIC QUERY
This query fetches the details of those assets which are partially and fully depreciated. SELECT ASSET_CATEGORY_ID ,MAJOR_CATEG…
NEW ASSETS ADDITION QUERY
This query fetches the detailed information related to those assets which are added newly for a particular period. SELECT FAL.segment1 SOL_ID …