My Oracle Support Banner

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

Last updated on DECEMBER 03, 2018

Applies to:

JD Edwards World U.S. Payroll Processing - Version A7.3 cume 4 and later
JD Edwards World Accounts Receivable - 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
JD Edwards World Address Book - Version A7.3 cume 4 and later
Information in this document applies to any platform.

Purpose

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
Purpose
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?
References

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