Supply Chain Management - PSFT (MOSC)

MOSC Banner

How to resolve low performance issue on PO receipt Page when select PO

edited May 27, 2014 8:22AM in Supply Chain Management - PSFT (MOSC) 3 commentsAnswered

we use Peoplesoft SCM 8.8 SP1 from 2006 , and then we have 2M+ records on PO receipt side , Now when user do PO receipt , the select PO page very slow to process , and after the DB level trace , one SQL statement show perofmance very bad

UPDATE PS_PO_RECV_SHIP_T

  SET PROCESS_FLG = 'Y'

WHERE PS_PO_RECV_SHIP_T.SEQ_NBR = :1

   AND PS_PO_RECV_SHIP_T.AMT_ONLY_FLG = 'N'

   AND EXISTS (

SELECT 'X'

  FROM PS_RECV_LN_SHIP_VW

WHERE PS_RECV_LN_SHIP_VW.BUSINESS_UNIT_PO = PS_PO_RECV_SHIP_T.BUSINESS_UNIT_PO

   AND PS_RECV_LN_SHIP_VW.PO_ID = PS_PO_RECV_SHIP_T.PO_ID

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center