Oracle Fixed Assets--> MASS Additions Interface

MASS ADDITIONS INTERFACE:

 1. It is a main interface Program for the Fixed Assets.

2. Primarily used for adding Assets to the system

The main use of this Mass Additions is:

1. Creates Assets 

2. Cost Adjust Assets.

3. Create CIP (Construction in Process) Assets. 

4. Cost adjusts CIP Assets.

5. Use only with corporate book.

The Main Sources which needs this Interface is:

1. Oracle Accounts Payables.

2. Oracle Projects.

3. Oracle ADI (Application Desktop Integrator).

4. Integrated Payables System 

5. Legacy Fixed Assets System.

6. Assets Transfers.

PLAN OF ATTACK:

General Information 

  a. Set-up 

  b. Mass Additions Components.

•        

           Discuss legacy asset conversion using mass additions.

•          Discuss feed from Accounts Payable using mass additions.

•          Discuss missing features

Components

•          Mass additions create program (in oracle payables)

•          Mass additions create program (in oracle projects)

•          Mass additions prepare screen

•          Mass additions posting program

•          Mass additions delete program

•          Mass additions purge program

What makes up an Asset?

Asset number	Description
Category	Asset cost
Payables clearing account	Depreciation Expense Account
Asset key flex field	Location flex field
Date placed in service	Units (quantity)
Book code (CORPORATE)	Feeder System Name
Depreciate Flag	Asset Type
Depreciation Reserve	YTD Depreciation
Tag Number	Serial Number
Descriptive flex fields

 Database Components

FA_MASS_ADDITIONS	Main interface table can be used exclusively if all assets have one and only one distribution
FA_MASSADD_DISTRIBUTIONS	Secondary table, only needed if an asset has more than one distribution

 Triggers for auto population of FA_MASSADD_DISTRIBUTIONS table

1.             fa_mass_additions_insert_dist

2.             fa_mass_additions_update_dist

3.             fa_mass_additions_delete_dist

4.             fa_mass_additions_insert_name (used with distribution sets).

 Key fields:

•         Represented in FA_MASS_ADDITIONS as numeric id fields, NOT CHARACTER

•         Lookup of ID needed for

–        Category

–        Location

–        Asset key

–        Payables clearing account

–        Depreciation expense account

Catergories:

 •          There is no character field for category code in mass additions table.

•          There is a numeric field, category_id in mass additions table

•          Category_id can be looked up from the FA_CATEGORIES table

Locations:

•          There is no character field for location in mass additions table.

•          There is a numeric field, location_id in mass additions table

•          Location_id can be looked up from the FA_LOCATIONS table

Payables Clearing Account             

•          There is no character field for payables clearing account in mass additions table.

•          There is a numeric field, PAYABLES_CODE_COMBINATION_ID in mass additions table

•          PAYABLES_CODE_COMBINATION_ID can be looked up from the GL_CODE_COMBINATIONS table

Useful link: http://docs.oracle.com/cd/A60725_05/html/comnls/us/fa/maoi04.htm