OEMIMP performance issues in EBs 12.0.6
Hi,
We are using EBS R12.0.6 . Off late we have found performance issues in "order booking". After going through awrrpt , we found sql module "OEMIMP" taking most time. Is there any patch to improve the performance of this module.
sql statement
UPDATE OZF_ORDER_GROUP_PROD SET LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID, ORDER_LINE_ID = :B14 , OFFER_ID = :B13 , QP_LIST_HEADER_ID = :B12 , GROUP_NO = :B11 , VOLUME_TRACK_TYPE = :B10 , COMBINE_SCHEDULE_YN = :B9 , PBH_LINE_ID = :B8 , VOLUME_TYPE = :B7 , PROD_ATTRIBUTE = :B6 , PROD_ATTR_VALUE = :B5 , APPLY_DISCOUNT_FLAG = :B4 , INCLUDE_VOLUME_FLAG = :B3 , INDIRECT_FLAG = :B2 WHERE ORDER_GROUP_PROD_ID = :B1
We are using EBS R12.0.6 . Off late we have found performance issues in "order booking". After going through awrrpt , we found sql module "OEMIMP" taking most time. Is there any patch to improve the performance of this module.
sql statement
UPDATE OZF_ORDER_GROUP_PROD SET LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID, ORDER_LINE_ID = :B14 , OFFER_ID = :B13 , QP_LIST_HEADER_ID = :B12 , GROUP_NO = :B11 , VOLUME_TRACK_TYPE = :B10 , COMBINE_SCHEDULE_YN = :B9 , PBH_LINE_ID = :B8 , VOLUME_TYPE = :B7 , PROD_ATTRIBUTE = :B6 , PROD_ATTR_VALUE = :B5 , APPLY_DISCOUNT_FLAG = :B4 , INCLUDE_VOLUME_FLAG = :B3 , INDIRECT_FLAG = :B2 WHERE ORDER_GROUP_PROD_ID = :B1
0