Receive Mass Additions Service

While submitting the Post Mass Addition concurrent program to load the Mass Additions records from interface tables to production tables, you cannot restrict the processing only to the records uploaded by this service. The input parameter for the program, Asset Book Name, drives the program to process all the unprocessed records in the interface table matching that Book Name. The concurrent program generates errors even in partially successful processing conditions. Therefore, the concurrent program can throw an exception even if it is successful in loading the records for the instance of the flow. The failure may be due to the other records that are attempting to process. The correct status of the records related to the instance of the flow can be found in the errorsDoc or ERROR_MESSAGE, which indicates the number of records processed successfully. Since no interface error table exists for storing the error records, you must review the concurrent request outputs to find the actual problem.

Database Script	Description
wm_install_into_ massadditions.sql	Runs all the scripts listed below, except the uninstall script.
wm_into_ massadditions_pkg.sql	Installs WM_FA_MASSADD_IMP_HANDLER_PKG. WM_HANDLE_FA_MASSADD.
wm_into_ massadditions_seq.sql	Creates the following components: WM_FA_MASSADD_S, which creates the unique Mass Addition ID. WM_FA_CREATEBATCH_S, which creates the Batch ID.
wm_drop_into_ massadditions.sql	Uninstalls all components created by wm_install_into_massadditions.sql.

importMassAdditions imports data to the production table from the interface table. This service then calls the execMassAddConcProg services. It also checks the MassAddImportStatus to execute the corresponding concurrent program that inserts data into the production table to generate the error or acknowledgment message. If the status of the execution is FAILED, it indicates that the Concurrent Program failed to execute. For Mass Additions Transaction, even if one particular record fails the concurrent program raises an exception. Therefore, to find the records that posted successfully by the concurrent program, use the getMassAddPostedStatus service to query the number of records which have been posted successfully for the particular Asset Book Name of the flow instance. Similarly, the getMassAddNotPosted service queries the number of records not posted for that particular Asset Book Name of the flow instance. This information is returned in the errorsDoc Recordlist with ConcProgMsg and dbErrorMsg. The errorsDoc Record list contains the data error returned by the concurrent program. The ConcProgMsg contains the Concurrent Program execution status and dbErrorMsg contains the Database Exceptions, if any, returned by the Concurrent Program Execution.

Field Name	Maps to Column	Description
ACCOUNTING_ DATE	ACCOUNTING_ DATE	Required. Accounting date of the invoice.
AP_ DISTRIBUTION_ LINE_NUMBER	AP_ DISTRIBUTION_ LINE_NUMBER	Line number in payables distribution.
ASSET_ CATEGORY_ DESCRIPTION	ASSET_ CATEGORY_ID	Required. Derived from the Oracle Applications view FA_CATEGORIES_VL. See the fixedAssets1227.intoOA. massAdditions.utils: getCategoryId transformer.
ASSET_KEY_ ACCOUNT_ CODE	ASSET_KEY_CCID	Validated against GL_CODE_COMBINATIONS_ KFV. See the fixedAssets1227.intoOA. massAdditions.utils: getAssetKeyCCId transformer.
ASSET_NUMBER	ASSET_NUMBER	Used for asset numbering. If this field is blank, it assigns an Asset Number.
ASSET_TYPE	ASSET_TYPE	Required. Type of asset. Valid values are CAPITALIZED, CIP, and EXPENSED.
ASSIGNED_TO_NAME	ASSIGNED_TO	Derives the Employee ID from FA_EMPLOYEES. See the commonOA1227.utils: getEmplIdFromFullName transformer.
BOOK_TYPE_CODE	BOOK_TYPE_ CODE	Required. Choose a CORPORATE type book that has been defined in FA_BOOK_CONTROLS.
CONTEXT	CONTEXT	Gets the date when loaded into Assets.
DATE_PLACED_ IN_SERVICE	DATE_PLACED_ IN_SERVICE	Required. Date the asset was placed into service.
DEPRECIATE_ FLAG	DEPRECIATE_ FLAG	Required. Indicates whether Oracle Assets should depreciate this asset.
DEPRN_RESERVE	DEPRN_RESERVE	Accumulated depreciation of this asset as in the General Ledger.
DESCRIPTION	DESCRIPTION	Required. Description of the asset.
DIST_NAME	DIST_NAME	Required. Distribution set name.
EXPENSE_ ACCOUNT_ CODE	EXPENSE_ CODE_ COMBINATION_ ID	Required. GL code to which the depreciation expense should be charged. Code combination ID from GL_CODE_COMBINATIONS_KFV. See the commonOA1227.utils:getCodeCombinationId transformer.
FEEDER_ SYSTEM_ NAME	FEEDER_ SYSTEM_ NAME	Name of the source system for interfacing.
FIXED_ ASSETS_ COST	FIXED_ ASSETS_ COST	Required.
FIXED_ ASSETS_ UNITS	FIXED_ ASSETS_ UNITS	Required. Number of units that make up the asset.
FULLY_RSVD_ REVALS_ COUNTER	FULLY_RSVD_ REVALS_ COUNTER	Number of times the asset has been revalued.
INVENTORIAL	INVENTORIAL	Required. Use either a Y or N to indicate if this asset should be included in physical inventory.
INVOICE_ NUMBER	INVOICE_ NUMBER	Payables invoice number.
LAST_ UPDATE_ DATE	LAST_ UPDATE_ DATE	Required. Date the asset was loaded.
CONCATENATED_ LOCATION	LOCATION_ID	Required. Location ID is derived from FA_LOCATIONS. The location of an asset is stored in this table. See the commonOA1227.utils:getLocationCodeCombination transformer.
MANUFACTURER_ NAME	MANUFACTURER_ NAME
MERGE_ INVOICE_ NUMBER	MERGE_ INVOICE_ NUMBER	Set to the invoice number for unmerged lines.
MERGE_ VENDOR_ NUMBER	MERGE_ VENDOR_ NUMBER	Set to vendor number for unmerged lines.
MODEL_ NUMBER	MODEL_ NUMBER	Model number of the asset.
PARENT_ ASSET_ NUMBER	PARENT_ ASSET_ID	Use if this asset is a component of another parent Asset. Derived from FA_ADDITIONS_B. See the fixedAssets1227.intoOA. massAdditions.utils: getAdditionalAssetId transformer.
PAYABLES_ ACCOUNTC_ CODE	PAYABLES_ CODE_ COMBINATION_ ID	Required. Code combination for the asset clearing account assigned to the asset category. See the commonOA1227.utils: getCodeCombinationId transformer.
PAYABLES_COST	PAYABLES_ COST	Required. Original cost of the asset.
PAYABLES_UNITS	PAYABLES_ UNITS	Required. Number of units that make up the asset.
PO_NUMBER	PO_NUMBER	Purchase order number of the asset.
PRODUCTION_ CAPACITY_ NUMBER	PRODUCTION_ CAPACITY_ NUMBER	Capacity of units of a production asset.
REVAL_ AMORTIZATION_ BASIS	REVAL_ AMORTIZATION_ BASIS	For the basis for amortization of revaluation reserve.
REVAL_ RESERVE	REVAL_ RESERVE	Revaluation reserve of a revalued asset.
REVIEWER_ COMMENTS	REVIEWER_ COMMENTS	Details about the asset.
SALVAGE_ VALUE	SALVAGE_ VALUE	Salvage value of the asset.
SERIAL_ NUMBER	SERIAL_ NUMBER	Serial number of the asset
TAG_ NUMBER	TAG_ NUMBER
UNIT_OF_ MEASURE	UNIT_OF_ MEASURE	Unit of measure of a production asset. If this field is blank, Oracle Assets uses the unit of measure from the asset category.
UNREVALUE_ COST	UNREVALUED_ COST	Cost without regard to any revaluation of a revalued asset.
YTD_DEPRN	YTD_DEPRN	Year-to-date depreciation.
YTD_REVAL_ DEPRN_ EXPENSE	YTD_REVAL_ DEPRN_ EXPENSE	Year-to-date depreciation expense due to revaluation.