R12 Poor Performance In Mass Additions Post (FAMAPT) (Doc ID 1448892.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Assets - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
FAMAPT
Mass Additions Report



Symptoms

Mass Additions Post (FAMAPT) has poor performance.  The offending SQL statement is as follows:

UPDATE /*+ index(gt FA_MASS_ADDITIONS_GT_N4) */FA_MASS_ADDITIONS_GT SET
MASS_ADDITION_ID = FA_MASS_ADDITIONS_S.NEXTVAL ,BOOK_TYPE_CODE = :B11 ,
LINE_STATUS = :B9 ,POSTING_STATUS = :B8 ,QUEUE_NAME = :B7 ,ASSET_TYPE =:B6
,SPLIT_MERGED_CODE = :B5 ,MERGED_CODE = :B4 ,PARENT_MASS_ADDITION_ID = :B3,
MERGE_PARENT_MASS_ADDITIONS_ID = :B2 ,ADD_TO_ASSET_ID = :B1
WHERE
PARENT_INVOICE_DIST_ID = :B10 AND LINE_STATUS = 'NEW' AND
LEDGER_CATEGORY_CODE = 'P' RETURNING INVOICE_DISTRIBUTION_ID ,
PARENT_MASS_ADDITION_ID ,ADD_TO_ASSET_ID ,LINE_STATUS ,POSTING_STATUS ,
QUEUE_NAME ,ASSET_TYPE ,MERGED_CODE INTO :O0 ,:O1 ,:O2 ,:O3 ,:O4 ,:O5 ,:O6,
:O7

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