EAM: AMPS1000 App Engine Process Running For Long Time (Doc ID 1956372.1)

Last updated on MAY 24, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
--------------------------
App engine -AMPS1000 running for long

SELECT P5.PRE_INTFC_ID , P5.PRE_INTFC_LINE_NUM , TO_CHAR(CAST((P5.DTTM_STAMP) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF') , MIN(AS2.ASSET_ID) , MIN(P5.FINANCIAL_ASSET_SW) , COUNT(*) FROM PS_ASSET AS2 , PS_AMPS_PRE1_TMP4 P5 WHERE P5.PROCESS_INSTANCE = 13140351 AND AS2.ASSET_STATUS <> 'D' AND P5.LOAD_STATUS = 'INP' AND P5.ASSET_ID = AS2.ASSET_ID AND P5.BUSINESS_UNIT_RECV <> ' ' AND EXISTS ( SELECT 'X' FROM PS_ASSET_ACQ_DET A5 WHERE A5.BUSINESS_UNIT = AS2.BUSINESS_UNIT AND A5.ASSET_ID = AS2.ASSET_ID AND A5.BUSINESS_UNIT_RECV = P5.BUSINESS_UNIT_RECV AND A5.RECEIVER_ID = P5.RECEIVER_ID AND A5.RECV_LN_NBR = P5.RECV_LN_NBR AND A5.RECV_DIST_LINE_NUM = P5.RECV_DIST_LINE_NUM AND A5.RECV_SHIP_SEQ_NBR = P5.RECV_SHIP_SEQ_NBR AND A5.BUSINESS_UNIT_PO = P5.BUSINESS_UNIT_PO AND A5.PO_ID = P5.PO_ID AND A5.PO_LINE_NBR = P5.PO_LINE_NBR AND A5.PO_DIST_LINE_NUM = P5.PO_DIST_LINE_NUM AND A5.SCHED_NBR = P5.SCHED_NBR AND A5.BUSINESS_UNIT = P5.BUSINESS_UNIT_AM AND A5.SYSTEM_SOURCE = 'PPO' AND ((P5.ASSET_ID = 'NEXT' AND (P5.DISTRIB_SEQ_NUM = A5.DISTRIB_SEQ_NUM OR (P5.DISTRIB_SEQ_NUM = 0 AND (P5.SERIAL_ID = AS2.SERIAL_ID OR P5.TAG_NUMBER = AS2.TAG_NUMBER OR (P5.SERIAL_ID = ' ' AND P5.TAG_NUMBER = ' '))))) OR (P5.ASSET_UE = 'Y' AND P5.ASSET_ID = A5.ASSET_ID))) GROUP BY P5.PRE_INTFC_ID, P5.PRE_INTFC_LINE_NUM, P5.DTTM_STAMP HAVING COUNT(*) > 1 ;

EXPECTED BEHAVIOR
-----------------------------
Process should go to success in a timely manner

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Interface assets into AM
2. Run AMPS1000

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run AMPS1000 due to performance problem

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