E1: 51: Job Status Inquiry (P512000) - JSI - Performance when there are thousands of accounts and using Level of Detail (LOD) "5" and Sequencing "C"
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.
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.
A change was made to the the Job Status Inquiry-User Defined Columns (P512000) and the Join for JSI V0006JD (F0901/F0006/F0902).
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