FA interface table in r12 : Fixed assets interface tables in oracle apps r12

FA interface table in r12 : Fixed assets interface tables in oracle apps r12

To Create new assets in the Oracle system , Oracle has given the Mass addition process. Mass addition helps to create the assets from the others system in the Oracle application. Here we will be discuss more about the FA Interface Table in r12. Oracle has given only the 1 interface table to create the Assets from other modules and from external systems. We just need to take care the required columns information's in this FA interface table to create the Assets in the Oracle system.

 

Fixed assets interface tables in oracle apps r12

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