My Oracle Support Banner

E1: OS: Overview, Maintenance and Known Issues for AS400 SQLPkgs (Doc ID 1525639.1)

Last updated on NOVEMBER 20, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior to 9.2 [Release SP23 and Prior to 9.2]
IBM i on POWER Systems




Purpose

 This document provides information on SQLPKGs, their maintenance and known issues.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Definition
 Question 1: What are SQL packages?
 Question 2: What data is stored in a SQL package?
 Question 3: How to tell if the SQL package is being used?
 Question 4: How to apply this information when running EnterpriseOne applications?
 Question 5: How to identify a SQL Package for a specific UBE
 Configuration
 Question 1: How to change the location of JDE SQL Packages and SQL Package naming convention
 Question 2: Are SQL Packages JDE environment specific?
 Question 3: Are SQL Packages created when the same report is run by different users (or in different environments)?
 Question 4: How to turn off JDE SQL Package creation including SQL Packages for JAS?
 Question 5: Setting up SQLPkgs for JAS
 Question 6: Operating System SQL Packages
 Deletion
 Question 1: When is the right time to delete SQL Packages?
 Question 2: When an ESU is installed, are SQL packages automatically deleted or should they be manually deleted?
 Question 3: If one user is experiencing an issue and another is not, will deleting SQL packages help the affected user?
 Question 4: How to delete SQL packages
 Recommendations
 Question 1: What is Oracle's recommendation on clearing JD Edwards (OW/E1)  generated SQL Packages?
 Question 2: Does Oracle recommend turning off JDE SQL Package creation?
 Performance
 Question 1: What are the advantages of using SQL packages?
 Question 2: Are there any options in JDE to reduce the size of SQL Packages created?
 Known issues
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.