Performance Issues In Mass Additions Create (APMACR) Concurrent Program (Doc ID 2128480.1)

Last updated on JULY 26, 2021

Applies to:

Symptoms

Mass Additions Create (APMACR) program is taking more than 8 hours to finish.

Below is the query that is causing the poor performance of the program.

 INSERT INTO FA_MASS_ADDITIONS_GT( MASS_ADDITION_ID, ASSET_NUMBER, TAG_NUMBER, DESCRIPTION, ASSET_CATEGORY_ID, INVENTORIAL, MANUFACTURER_NAME, SERIAL_NUMBER, MODEL_NUMBER, BOOK_TYPE_CODE, DATE_PLACED_IN_SERVICE, TRANSACTION_TYPE_CODE, TRANSACTION_DATE, FIXED_ASSETS_COST, PAYABLES_UNITS, FIXED_ASSETS_UNITS, PAYABLES_CODE_COMBINATION_ID, EXPENSE_CODE_COMBINATION_ID, LOCATION_ID, ASSIGNED_TO, FEEDER_SYSTEM_NAME, CREATE_BATCH_DATE, CREATE_BATCH_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, REVIEWER_COMMENTS, INVOICE_NUMBER, VENDOR_NUMBER, PO_VENDOR_ID, PO_NUMBER, POSTING_STATUS, QUEUE_NAME, INVOICE_DATE, INVOICE_CREATED_BY, INVOICE_UPDATED_BY, PAYABLES_COST, INVOICE_ID, PAYABLES_BATCH_NAME, DEPRECIATE_FLAG, PARENT_MASS_ADDITION_ID, PARENT_ASSET_ID, SPLIT_MERGED_CODE, AP_DISTRIBUTION_LINE_NUMBER, POST_BATCH_ID, ADD_TO_ASSET_ID, AMORTIZE_FLAG, NEW_MASTER_FLAG, ASSET_KEY_CCID, ASSET_TYPE, DEPRN_RESERVE, YTD_DEPRN, BEGINNING_NBV, ACCOUNTING_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, SALVAGE_VALUE, MERGE_INVOICE_NUMBER, MERGE_VENDOR_NUMBER, INVOICE_DISTRIBUTION_ID, INVOICE_LINE_NUMBER, PARENT_INVOICE_DIST_ID, LEDGER_ID, LEDGER_CATEGORY_CODE, WARRANTY_NUMBER, LINE_TYPE_LOOKUP_CODE, PO_DISTRIBUTION_ID, LINE_STATUS )

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.