Fixed Assets

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 divide an…

Read More

Fixed Asset- Depreciation

Hi All Introduction:  Depreciation This Blog will explain about the Deprecation calculations What is Depreciation? Assets calculates depreciation using either the recoverable cost or the recoverable net book value as…

Read More

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_period_close_date,faab.prorate_date)), faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.deprn_start_date)))<=0 then 0 ELSE decode(faab.conversion_date, NULL, faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.prorate_date)), faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.deprn_start_date))) END FROM apps.fa_books faab, apps.fa_deprn_periods fdpp, apps.fa_additions_bfbb WHERE faab.asset_id=fbb.asset_id   AND…

Read More

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.book_type_code…

Read More

ASSET DEPRECIATION LOGIC QUERY

This query fetches the details of those assets which are partially and fully depreciated.  SELECT ASSET_CATEGORY_ID        ,MAJOR_CATEGORY        ,OPENING_DAY_ASSET_COST        ,OPEN_ACC_ASSET_COST_FY    …

Read More

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             ,FFV.description BRANCH_NAME  …

Read More