Distribution - JDE1 (MOSC)

MOSC Banner

R42800 Sales Update Data Selection and Job Performance

edited Jun 5, 2020 9:53AM in Distribution - JDE1 (MOSC) 7 commentsAnswered

We have R42800 no custom code for the version data selection: F4211.DOC <> 0, F4211.NXTR = 620, select 6 DCTOs with Equal To

ran for 35 mins processed 3923 records or 21 mins processed 2595 records

I would like to check to see if this is normal process time and the data selection is correct and efficient

I thought when data selection to select <> which will do a full table scan but I found standard JDE versions have the same data selection

Could you please compare with your R42800 to see if the performance is about right or if there is anything I can do to improve the job performance?

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