E1: 51: Job Status Inquiry (P512000) - JSI - Performance when there are thousands of accounts and using Level of Detail (LOD) "5" and Sequencing "C" (Doc ID 1616385.1)

Last updated on NOVEMBER 23, 2015

Applies to:

JD Edwards EnterpriseOne Project Costing - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

When the Job Status Inquiry- JSI (P512000) is used on a Project that has at least 41 jobs rolling up to the project and the jobs have between 1000-3000 accounts on each of the jobs, the JSI is taking over 20 minutes when sequencing "C" and Level of Detail "5" is used.

Changes

A change was made to the the Job Status Inquiry-User Defined Columns (P512000) and the Join for JSI V0006JD (F0901/F0006/F0902).              

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