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

Last updated on AUGUST 25, 2017

Applies to:

Oracle Payables - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Other-MiscIss & KeyIndReport

ACTUAL BEHAVIOR
---------------
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 )

EXPECTED BEHAVIOR
-----------------------
Mass Additions Create (APMACR) program should complete in time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Mass Additions Create (APMACR) program

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run MMass Additions Create (APMACR) program

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms