Oracle-Developer.com Forums

[vj.jain]

The Mass Additions Create process is used to transfer invoice distributions in Payables to Fixed Assets for tracking as an expensed asset, a CIP asset, or a capitalized asset. Costs are also sent directly to Fixed Assets from Oracle Projects using the PRC: Interface Assets to Oracle Assets. Any invoice distribution line charged to a capital project must be transferred from Oracle Projects.

The Mass Additions Create Program (APMACR) is submitted from an Accounts Payable (AP) responsibility. The purpose of the program is to interface the costs of purchased items that meet the criteria to become an asset. It also interfaces adjustments to the invoice cost and discounts taken when the invoice is paid for assets that have already been interfaced.

There are three types of assets:

• capitalized asset
• construction-in-process (CIP) asset
• expensed asset.

Which type of asset an invoice distribution becomes depends on the natural account segment and the asset category configuration. Any invoice distribution that is charged to an expense account is eligible to be transferred to Fixed Assets (FA) as an expense type asset if the “Track as Asset” option is selected on the distribution line. These expenses are not depreciated in FA, but they are reported as an expense. Capitalized assets will start to depreciate based on the depreciation method rules and the date placed in service. CIP assets do not depreciate until the asset is capitalized and placed into service.


In order for an invoice distribution amount to be transferred to FA, the invoice must meet the following conditions:

• The invoice is approved.
• The invoice line distribution is accounted and posted to Oracle General Ledger from Payables.
• The invoice distribution line is charged to an account set up as an asset type account (CIP or capitalized assets) or an expense type account (expensed asset).
• If an invoice distribution charge account is an asset type account, then that account must be set in Fixed Assets on an asset category as either an Asset Clearing Account or a CIP Clearing Account.
• The “Track as Asset” check box is selected. This checkbox is automatically checked if the distribution charge account is an asset type account and cannot be changed. For expense type accounts this box can be checked or unchecked. For other account types. The “Track as Asset” check box remains greyed out.
• The accounting/GL date on the invoice line distribution is on or before the date specified for the Create Mass Additions request
• In a multiple organizations set up, the Payables operating unit must be tied to the same General Ledger Set of Books as the Corporate book



Changes to Mass Additions Create in R12

In release 12, the Mass Additions Create process (apmassab.pls) inserts the records into the FA_MASS_ADDITIONS_GT table, a global temporary table. In 11i, it inserted the records into the FA_MASS_ADDITIONS table.
The Mass Additions Create process then calls the fixed assets code, FA_MASSADD_CREATE_PKG (famadcb.pls), which determines whether the selected data meets the criteria to be set moved to the FA_MASS_ADDITIONS table based on the asset book controls and the configured asset and cip clearing accounts. The
The profile option “FA: Include Nonrecoverable Tax in Mass Addition” is obsolete in R12. See the Non-Recoverable Taxes section to see how to transfer these costs to FA.
The asset book and asset category can be defined in Payables on the invoice line. If these are defined in Payables, they will appear in the Mass Additions Prepare screen when the asset is reviewed.