My Oracle Support Banner

WS: TF: World Purge and Database FAQs (Doc ID 1169966.1)

Last updated on MARCH 20, 2024

Applies to:

JD Edwards World Procurement - Version A7.3 cume 4 and later
JD Edwards World Accounts Receivable - Version A7.3 cume 4 and later
JD Edwards World U.S. Payroll Processing - Version A7.3 cume 4 and later
JD Edwards World Accounts Payable - Version A7.3 cume 4 and later
JD Edwards World Technical Foundation - Version A7.3 cume 4 and later
Information in this document applies to any platform.


Frequently asked questions related to the World database and purging World files.

Questions and Answers

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
Questions and Answers
 Question 1: What general information is available regarding purging data?
 Question 2: Is there a purge program for the World generic text files F0016, F00163, and F00164?  Does JDE have a subroutine for deleting generic text?
 Question 3: Is there a purge program for F0082H - Menu History File?
 Question 4: When running P00PURGE over a custom file, what could generate an incorrect OPNQRYF statement that results in no records selected?
 Question 5: When running the purge routines that create the JDEDDMMYY library, what date is used - job date or system date?
 Question 6: If the purge job runs over two days will we have one or two libraries resulting from the job?
 Question 7: What information is available regarding reorganizing files?
 Question 8: What is the difference between Physical File REUSEDLT Parameter *NO and *YES?
 Question 9: How do you create a list of World data files with the field names and attributes, such as type, length, description and key fields?
 Question 10: How can you see the key fields on a physical, logical, or joined logical file?
 Question 11: How do you know what Day and Month a Julian Date field represents?
 Question 12: Why is there a difference in the length defined for the data item in Data Dictionary and the length that displays on a screen? 
 Question 13: How can the Copy File (CPYF) command be used to obtain a printout of the data in a file?
 Question 14: In A9.4, why does the library created by P00PURGE and the file within the library have *PUBLIC authority set to *EXCLUDE?
 Question 15: How can I purge Audit files created by Data Base Audit Manager (DBAM)?
 Question 16: Does JDE World offer DDL database support?
 Question 17: What should be considered when planning an upgrade, files need to be purged, and purged records may need to be restored/utilized after the upgrade?
 Question 18: Is it possible for customers to obtain the source for P00PURGE?
 Question 19: Why is message "Syntax check found no errors" returned when running a simple SQL statement?

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