E1: OS: Overview, Maintenance and Known Issues for AS400 / iSeries/ IBMi SQLPkgs
(Doc ID 1525639.1)
Last updated on FEBRUARY 26, 2024
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 |
| Deletion |
| 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 |