The database definition of the FA_MASS_ADDITIONS table does not require that you provide values for any columns, but in order for the Mass Additions Posting program to work properly, you must follow the rules in the following list of column descriptions. The Mass Additions Posting program uses some of the columns in the FA_MASS_ADDITIONS table, so these columns are marked NULL. Do not import your data into columns marked NULL. You must fill columns marked REQUIRED before you run Mass Additions Post.
You can either load the column directly from your other system, or you can fill in some values in the Mass Additions window before you post. Columns marked OPTIONAL are for optional asset information that you can track if you want. VARCHAR2 columns are case sensitive.
| Column Name | Null | Type | Comments |
|---|---|---|---|
| ACCOUNTING_DATE | Null | DATE | Required. Use this column for the accounting date of the invoice. The Unposted Mass Additions Report reports on this date. |
| ADD_TO_ASSET_ID | NUMBER(15) | Do not use this column. | |
| ADJUSTED_RATE | NUMBER | Actual rate used to calculate the depreciation for flat rate method. | |
| ALLOWED_DEPRN_LIMIT | NUMBER | Depreciation limit percentage for the asset. | |
| ALLOWED_DEPRN_LIMIT_AMOUNT | NUMBER | Depreciation limit amount for the asset. | |
| AMORTIZATION_START_ DATE | DATE | Optional. This column indicates the date to start amortizing the net book value for the asset, if the AMORTIZE_NBV_FLAG column is set to Yes. | |
| AMORTIZE_FLAG | VARCHAR2(3) | Optional. Use this column to determine whether an asset should be amortized. This column should be set to yes if either the AMORTIZATION_START_DATE or the AMORTIZE_NBV_FLAG columns contain values. | |
| AMORTIZE_NBV_FLAG | VARCHAR2(1) | Optional. Use this column to determine whether to enable the asset to amortize the net book value over the remaining useful life | |
| AP_DISTRIBUTION_ LINE_NUMBER | NUMBER(15) | Optional. Use this column for the distribution line number. The value must be a valid in the AP_DISTRIBUTION_LINE_NUMBER column on the table AP_INVOICE_DISTRIBUTIONS, and tied to the INVOICE_ID given above. | |
| ASSET_CATEGORY_ID | NUMBER(15) | Required. Use this column for the category id that corresponds with the asset category of the asset. See: Importing Your Asset Information . | |
| ASSET_ID | Null | NUMBER(15) | Do not use this column. |
| ASSET_KEY_CCID | NUMBER(15) | Use this column for the code combination id that corresponds to the asset key. Use an enabled value from the CODE_COMBINATION_ID column of the FA_ASSET_KEYWORDS table. | |
| ASSET_NUMBER | VARCHAR2(15) | Optional. This column is a unique external identifier for assets. If you enter a value in this column it is used for asset numbering. The numbers you supply must be unique. It identifies the asset in Oracle Assets windows and reports. If you leave this column blank Oracle Assets assigns an asset number using automatic numbering, in which case the asset number is the same as the asset id. | |
| ASSET_TYPE | VARCHAR2(11) | Use 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. Group: For your group assets. | |
| ASSIGNED_TO | NUMBER(15) | Optional. Use this column for the employee id of the employee responsible for this asset. Use a value from the EMPLOYEE_ID column in FA_EMPLOYEES. Note that EMPLOYEE_ID is the unique internal identifier, and not the same as the external identifier EMPLOYEE_NUMBER. | |
| ATTRIBUTE_ CATEGORY_CODE | Null | VARCHAR2(30) | Do not use this column. |
| ATTRIBUTE1 through ATTRIBUTE30 | VARCHAR2(150) | Optional Use these columns to copy the Asset Workbench descriptive flexfield segments setup on the Asset Workbench. To access these values in the Asset Workbench, you need to define the descriptive flexfield on the Asset Workbench. The values stored in ATTRIBUTE1 through ATTRIBUTE30 are copied to the columns in FA_ADDITIONS. | |
| BASIC_RATE | NUMBER | Base rate used to calculate the depreciation amount for flat rate. | |
| BEGINNING_NBV | Null | NUMBER | Do not use this column. |
| BONUS_DEPRN_RESERVE | NUMBER | Optional. This column contains the bonus depreciation reserve for the asset. This amount should also be included in the DEPRN_RESERVE column. | |
| BONUS_RULE | VARCHAR2(30) | Name of the bonus rule for the asset. | |
| BONUS_YTD_DEPRN | NUMBER | Optional. This column contains the year-to-date bonus depreciation expense for the asset. This amount should also be included in the YTD_DEPRN column. | |
| BOOK_TYPE_CODE | VARCHAR2(15) | Required. Use this column for the book to which you want to assign the asset. You must choose a book that you have set up in the Book Controls window, and the book class must be CORPORATE. Values in this column must be in upper case. | |
| CONTEXT | VARCHAR2(210) | Optional. Use this column for the date you load this asset into the FA_MASS_ADDITIONS table. | |
| CONVERSION_DATE | DATE | Optional. This column indicates the date the short fiscal year asset was added to the acquiring company. | |
| CREATE_BATCH_DATE | DATE | Optional. Use this column for the date you load this asset into the FA_MASS_ADDITIONS table. | |
| CREATE_BATCH_ID | NUMBER(15) | Optional. Use the value 1 for this column to distinguish it from subsequent Mass Additions for a conversion, or use the same number for all mass additions from your payables system that you load at once. | |
| CREATED_BY | NUMBER(15) | Required. Use the value 1 in this column, or the specific user id of the person working on the import. | |
| CREATION_DATE | DATE | Required. Use this column for the date you load this asset into the FA_MASS_ADDITIONS table. | |
| CUA_PARENT_ HIERARCHY_ID | NUMBER | CRL users should use this column to assign the asset to a hierarchy parent node. | |
| DATE_ PLACED_IN_SERVICE | DATE | Required. Use this column for the date you placed the asset in service. | |
| DEPRECIATE_FLAG | VARCHAR2(3) | Required. Use 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. | |
| DEPRN_LIMIT_TYPE | VARCHAR2(30) | Depreciation limit type of the asset, such as the amount or percent. | |
| DEPRN_METHOD_CODE | VARCHAR2(12) | Name of the depreciation method for the asset. | |
| DEPRN_RESERVE | NUMBER | Optional. Use this column for the accumulated depreciation of the asset as it currently appears in your general ledger. You can enter a value, or have Oracle Assets calculate it. For CIP, expensed and group assets, you must enter zero or leave it blank. | |
| DESCRIPTION | VARCHAR2(80) | Required. Use this column for a description of the asset. | |
| DIST_NAME | VARCHAR2(25) | Optional. Use this column to indicate the name of the distribution set. | |
| EXPENSE_CODE_ COMBINATION_ID | NUMBER(15) | Required. Use this column for the code combination id of the general ledger account to which depreciation expense should be charged. See: Importing Your Asset Information . | |
| FEEDER_ SYSTEM_NAME | VARCHAR2(40) | Optional. Use this column to note that this asset came from a import process. Use a word like CONVERSION or PAYABLES to denote the nature of the import. | |
| FIXED_ASSETS_COST | NUMBER | Required. Use this column for the cost of the asset as it currently appears in your general ledger. For group assets, you must enter zero or leave it blank. The cost of a group asset is derived from the sum of all member assets when the member assets are assigned to the group. For group assets, you must enter zero or null. The cost of a group asset is the sum of the assigned member asset costs. | |
| FIXED_ASSETS_UNITS | NUMBER(15) | Required. Use this column for the number of units that make up the asset. You must use a positive integer value. | |
| FULLY_RSVD_ REVALS_COUNTER | NUMBER | Optional. Use this column for the number of times you have revalued this asset as fully reserved. If you do not revalue your assets, do not use this column. | |
| GLOBAL_ATTRIBUTE_ CATEGORY | Null | VARCHAR2(30) | Do not use this column. |
| GLOBAL_ ATTRIBUTE1-20 | VARCHAR2(150) | Optional. Use these columns to copy the Asset Workbench global descriptive flexfield segments setup on the Asset Workbench. To access these values in the Asset Workbench, you need to define the global descriptive flexfield on the Asset Workbench. The values stored in GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE20 are copied to the columns in FA_ADDITIONS. | |
| GROUP_ASSET_ID | NUMBER(15) | Optional. Use this column for member assets only. Group_Asset_ID is the Asset_ID of the group asset to which the member asset is assigned. Note that if you leave this field null, any applicable default from the category default will be applied. If a group association exists in the category, and you wish to enforce no group association, you should populate this field with FND_API.G_MISS_NUM. | |
| IN_USE_FLAG | VARCHAR2(3) | Optional. Use this column to indicate whether the asset is in use. | |
| INVENTORIAL | VARCHAR2(3) | Optional. Use this column to indicate whether an asset should be included in physical inventory. The value is defaulted from the category but can be overridden. The valid values for this column are YES or NO. | |
| INVOICE_CREATED_BY | Null | NUMBER(15) | Do not use this column. |
| INVOICE_DATE | Null | DATE | Do not use this column. |
| INVOICE_ID | NUMBER(15) | Optional. Use this column for the invoice id, if available. Use the appropriate value from the INVOICE_ID column of the AP_INVOICES table. Note that INVOICE_ID is the unique internal identifier, and not the same as the external identifier INVOICE_NUMBER. | |
| INVOICE_NUMBER | VARCHAR2(15) | Optional. Use this column for the invoice number for this asset, if available. | |
| INVOICE_UPDATED_BY | Null | NUMBER(15) | Do not use this column. |
| LAST_UPDATE_DATE | DATE | Required. Use this column for the date you load this asset into the FA_MASS_ADDITIONS table. | |
| LAST_UPDATE_LOGIN | NUMBER(15) | Required. Use the value 1 in this column, or the specific user id of the person working on the import. | |
| LAST_UPDATED_BY | NUMBER | Required. Use the value 1 in this column, or the specific user id of the person working on the import. | |
| LEASE_ID | NUMBER(15) | Optional. This column identifies the lease number. | |
| LESSOR_ID | NUMBER(15) | Optional. This column identifies the lessor number. | |
| LIFE_IN_MONTHS | NUMBER(4) | Life of the Asset in total months. | |
| LOCATION_ID | NUMBER(15) | Required. Use this column for the location id that corresponds with the location of the asset. See: Importing Your Asset Information . | |
| MASS_ADDITION_ID | NUMBER(15) | Required. 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. Note that the value of this column must be less than 2,000,000,000. | |
| MANUFACTURER_NAME | VARCHAR2(30) | Optional. Use this column for the name of the manufacturer of the asset. | |
| MERGE_ INVOICE_NUMBER | VARCHAR2(50) | Optional. Optionally set this column to INVOICE_NUMBER for unmerged lines. | |
| MERGE_PARENT MASS_ADDITIONS_ID | Null | NUMBER(15) | Do not use this column. |
| MERGE_ VENDOR_NUMBER | VARCHAR2(30) | Optional. Optionally set this column to VENDOR_NUMBER for unmerged lines | |
| MERGED_CODE | Null | VARCHAR2(3) | Do not use this column. |
| MODEL_NUMBER | VARCHAR2(40) | Optional. Use this column for the model number of the asset. | |
| NEW_MASTER_FLAG | Null | VARCHAR2(3) | Do not use this column. |
| NEW_USED | VARCHAR2(4) | Optional. Use this column to indicate whether the asset is new or used. | |
| ORIGINAL_DEPRN_START_DATE | DATE | Optional. This column indicates the date the short fiscal year asset began depreciating in the acquired company's books. | |
| OWNED_LEASED | VARCHAR2(15) | Optional. Use this column to indicate whether the asset is owned or leased. | |
| PARENT_ASSET_ID | NUMBER(15) | Optional. If you are importing asset information from another payables system, use this column for the asset id of the parent asset if this asset is a subcomponent of another asset. The parent asset must be an existing asset. Note that ASSET_ID is the unique internal identifier, and not the same as the external identifier ASSET_NUMBER. For a conversion, do not use this column. If an asset is a subcomponent, you can enter this relationship in the Subcomponents window after you post. | |
| PARENT_ MASS_ADDITION_ID | Null | NUMBER(15) | Do not use this column. |
| PAYABLES_ BATCH_NAME | Null | VARCHAR2(50) | Do not use this column. |
| PAYABLES_CODE_ COMBINATION_ID | NUMBER(15) | Required. Use this column for the code combination id of the asset clearing account you assigned to the asset category. See: Importing Your Asset Information Step 2: page 1 - 92. | |
| PAYABLES_COST | NUMBER | Required. Use 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. | |
| PAYABLES_UNITS | NUMBER | Required. Use 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. | |
| PERCENT_SALVAGE_VALUE | NUMBER | Salvage percentage of the asset. | |
| PO_NUMBER | VARCHAR2(15) | Optional. Use this column for the purchase order number for this asset, if available. | |
| PO_VENDOR_ID | NUMBER(15) | Optional. Use this column for the supplier id. See: Importing Your Asset Information Step 5: page 1 - 94. | |
| POST_BATCH_ID | Null | NUMBER(15) | Do not use this column. |
| POSTING_STATUS | VARCHAR2(15) | Required. To import asset information from another payables system, use the value NEW or ON HOLD for this column if you want to review this asset in the Mass Additions window. Use the value POST for this column if you are entering all required information and want to post the asset immediately, such as for a conversion. | |
| PRODUCTION_CAPACITY | NUMBER | Optional. Use this column for the capacity of a units of production asset. If you do not enter a capacity, Oracle Assets uses the capacity from the asset category. If this asset is not a units of production asset, do not use this column. | |
| PROJECT_ASSET_LINE_ID | Null | NUMBER(15) | Do not use this column. |
| PROJECT_ID | Null | NUMBER(15) | Do not use this column. |
| PROPERTY_1245_1250_CODE | VARCHAR2(4) | Optional. Use this column to indicate that the property type class is 1245 (personal) or 1250 (real). | |
| PROPERTY_TYPE_CODE | VARCHAR2(10) | Optional. Use this column to indicate the property type. | |
| PRORATE_CONVENTION_CODE | VARCHAR2(10) | Depreciation prorate convention used for the asset. | |
| QUEUE_NAME | VARCHAR2(15) | Required. Use the same value you entered into the POSTING_STATUS column (e.g. NEW, ON HOLD, POST). | |
| REVAL_ AMORTIZATION_BASIS | NUMBER | Optional. Use this column for the basis for amortization of revaluation reserve for a revalued asset, usually the current revaluation reserve. If you do not revalue your assets, do not use this column. | |
| REVAL_RESERVE | NUMBER | Optional. Use this column for the revaluation reserve of a revalued asset. If you do not revalue your assets, do not use this column. | |
| REVIEWER_ COMMENTS | VARCHAR2(60) | Optional. Use this column to note that this asset came from a import process and any other details about this asset. | |
| SALVAGE_TYPE | VARCHAR2(30) | Salvage type of the asset, such as the amount or percent. | |
| SALVAGE_VALUE | NUMBER | Optional. Use this column for the salvage value of the asset, if available. | |
| SERIAL_NUMBER | VARCHAR2(35) | Optional. Use this column for the serial number of the asset. | |
| SHORT_FISCAL_YEAR_FLAG | VARCHAR2(3) | Optional. Use this column to indicate if the asset was added in a short fiscal year. | |
| SPLIT_CODE | Null | VARCHAR2(3) | Do not use this column. |
| SPLIT_MERGED_CODE | Null | VARCHAR2(3) | Do not use this column. |
| SPLIT_PARENT_MASS_ADDITIONS_ID | Null | NUMBER(15) | Do not use this column. |
| SUM_UNITS | Null | VARCHAR2(3) | Do not use this column. |
| TAG_NUMBER | VARCHAR2(15) | Use this column for the asset tag number if required. You can use this column for barcode values if you track assets by barcodes. Oracle Assets allows no duplicate values except null. | |
| TASK_ID | NUMBER(15) | Optional. This column identifies the task from which costs were collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task. | |
| TRANSACTION_DATE | DATE | Optional. This column indicates the date on which the transaction is processed. | |
| TRANSACTION_TYPE_CODE | VARCHAR2(20) | Optional. Use this column to identify the type of future transaction. Possible values are: FUTURE ADD, FUTURE ADJ, and FUTURE CAP. | |
| UNIT_OF_MEASURE | VARCHAR2(25) | Optional. Use this column for the unit of measure for a units of production asset. If you do not enter a unit of measure, Oracle Assets uses the unit of measure from the asset category. If this asset is not a units of production asset, do not use this column. | |
| UNITS_TO_ADJUST | NUMBER(15) | Do not use this column. | |
| UNREVALUED_COST | NUMBER | Optional. Use this column for the cost without regard to any revaluations of a revalued asset. If you do not revalue your assets, do not use this column. | |
| VENDOR_NUMBER | Null | VARCHAR2(15) | Do not use this column. |
| WARRANTY_ID | NUMBER(15) | Optional. Use this column to identify the warranty number. | |
| YTD_DEPRN | NUMBER | Optional. Use this column for the year-to-date depreciation of the asset as it currently appears in your general ledger. You can enter a value, or have Oracle Assets calculate it for an asset with a date placed in service in a prior period. For CIP, expensed and group assets, you must enter zero or leave it blank. Note: If you enter the YTD_DEPRN manually, make sure you are aware of how this affects depreciation calculation in subsequent periods. For more information, see: Journal Entries for Additions and Capitalizations. If you are using the FA: Annual Rounding profile option, see: Profile Options and Profile Options Categories Overview. | |
| YTD_REVAL_DEPRN_EXPENSE | NUMBER | Optional. Use this column for the year-to-date depreciation expense due to revaluation of a revalued asset. If you do not revalue your assets, do not use this column. Some columns do not apply to group, CIP, or expensed assets. These columns include the following: YTD_REVAL_DEPRN_EXPENSE, UNREVALUED_COST, SHORT_FISCAL_YEAR_FLAG, REVAL_RESERVE, REVAL_AMORTIZATION_BASIS, ORIGINAL_DEPRN_START_DATE, FULLY_RSVD_REVALS_COUNTER, YTD_DEPRN |