Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Purge Old/ Unwanted data

edited Nov 16, 2017 12:49PM in Design Tools & Output Technologies - JDE1 (MOSC) 9 commentsAnswered ✓

Hi Mentors,

We are planning to purge below scenario data to increase performance and to cut loose unnecessary Storage. Could you suggest List of tables which should fall under this category and best way to purge them;

  • Purging work type files. For example, clearing the integration/interface tables. Z1 and F47. These tables can be safely cleared once the usefulness of the data has passed. You should review on a table by table basis but most should be able to be run regularly to remove data older than 6 months.
  • Purging/Archiving business data - It makes sense that a project should be put in place in the future to determine the best course of action for KIND. You may want to look into summarizing and removing some of the GL detail data as a first step.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center