Fixed Assets conversion in oracle apps r12

Fixed Assets conversion in oracle apps r12

Fixed assets conversion is the process of importing Assets from external system to the Oracle Application. In Fixed asset conversion we creates mass assets in the oracle application with the help of FA interface. We insert the assets information in the Fixed asset interface tables then run the Mass addition process to import or create the assets from the interface table. Here in this post , I will share the detail steps of the Fixed assets conversion.

 

 

Interface Table Uses in the Fixed Assets conversion

1. FA_MASS_ADDITION

 

FA_MASS_ADDITION is the table given in the Oracle apps to create the Assets from the External system. We just need to enter the assets information in this table and then run the mass addition process. Mass addition process will automatically create the assets as per the information's available or entered in the FA_MASS_ADDITION table. There are few required columns in the FA_MASS_ADDITION table we needs to be filled so that assets can be create from the mass addition process.

 

Columns need to be filled in FA_MASS_ADDITION table to create the Assets.

 

1.ACCOUNTING_DATE :-

 

Accounting Date of the Added Asset Invoice. This Column is Required to run the mass addition process.

 

2.ASSET_CATEGORY_ID :-

 

We have asset categories in the Oracle System. We need to give the Asset Category ID to create the asset. 

 

 

3.ASSET_TYPE :-

 

This column for the asset type of the asset. Enter one of the following values:

 

CAPITALIZED	For your capitalized assets
CIP	For your construction-in-process (CIP) assets.
EXPENSED	For your expensed assets.

 

4.BOOK_TYPE_CODE :-

 

We have assets Books in the Oracle system. Here we need to give the Asset Book Type code to create the assets.

 

 

5.CREATED_BY

6.CREATION_DATE

7.DATE_ PLACED_IN_SERVICE :-

 

This column for the date you placed the asset in service.

 

8.DEPRECIATE_FLAG:-

 

This column to indicate if you want Oracle Assets to depreciate this asset. If you want to calculate depreciation on this asset, enter YES in this column. If you do not want to calculate depreciation, enter NO.

 

9.DESCRIPTION :-

 

Use this column for a description of the asset.

 

10.EXPENSE_CODE_ COMBINATION_ID :-

 

Here we need to pass the code combination id of the general ledger account to which depreciation expense should be charged.

 

11.FIXED_ASSETS_COST :-

 

This column for the cost of the asset as it currently appears in your general ledger.

 

12.FIXED_ASSETS_UNITS :-

 

This column for the number of units that make up the asset. You must use a positive integer value.

 

13.LAST_UPDATE_DATE DATE

14.LAST_UPDATE_LOGIN

15.LAST_UPDATED_BY

 

16.LOCATION_ID :-

 

We need to assign the Location to the assets. We do creates the assets Locations in the system then we assign the Location id of the system.

 

17.MASS_ADDITION_ID : -

Oracle Assets uses this column as a unique identifier for mass additions. The values in MASS_ADDITION_ID are generally sequential. You can use a sequence generator to populate this column.

18.PAYABLES_CODE_ COMBINATION_ID :-

 

Enter the Asset clearing account you assigned to the asset category which you defined.

 

19.PAYABLES_COST :-

 

This column for the original cost of the asset. If you do not have the original cost of the asset, use the asset cost as it appears in the general ledger.

 

20.PAYABLES_UNITS :-

 

This column for the number of units that make up the asset. You must use a positive integer value. Use the same value in this column that you use in the FIXED_ASSETS_UNITS column.

 

21.POSTING_STATUS

22.QUEUE_NAME

23.PO_VENDOR_ID

 

Example of Fixed Assets conversion in oracle apps r12

 

Insert in to FA_MASS_ADDITION

(ACCOUNTING_DATE,

ASSET_CATEGORY_ID,

ASSET_TYPE,

BOOK_TYPE_CODE,

CREATED_BY,

CREATION_DATE,

DATE_ PLACED_IN_SERVICE,

DEPRECIATE_FLAG,

DESCRIPTION,

EXPENSE_CODE_COMBINATION_ID,

FIXED_ASSETS_COST,

FIXED_ASSETS_UNITS,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN,

LAST_UPDATED_BY,

LOCATION_ID,

MASS_ADDITION_ID,

PAYABLES_CODE_ COMBINATION_ID,

PAYABLES_COST,

PAYABLES_UNITS)

 

VALUES ( '12-DEC-2018',

12201,

'EXPENSED',

'CORP_BOOK',

-1,

SYSDATE,

'12-DEC-2018',

'YES',

20034,

1200,

1,

SYSDTE,

-1,

-1,

1234,

2003,

1200,

1);

At the Last , we need to run the 'Mass Addition Process' to import the assets information to create the Assets from the Interface table 'FA_MASS_ADDITION'

Fixed Assets conversion in oracle apps r12