To purge jobs and schedules:You can purge old job and schedules records in your database. You can purge:
Discrete and lot based jobs closed in accounting periods currently closed
Repetitive schedules cancelled or completed with no charges in a closed accounting period
All detail information including material requirements, resource requirements, and operations associated with jobs and schedules
Move and/or resource transactions associated with jobs and repetitive schedules
For quality and customer service tracking purposes, you can choose to retain as-built configuration histories for discrete jobs that build assemble to order items. You can purge all discrete job and repetitive schedule information (details, transactions and headers) by choosing to purge headers.
Note: Once you submit a purge request with a Purge Only or Purge and Report action type, all related information is removed from the database.
Purge requests can be submitted using concurrent or scheduled processing. See: Overview of Standard Request Submission.
You can check the status of purge requests using the Concurrent Requests window.
You must have at least one closed period for your organization. See: Overview of Period Close
To purge jobs and schedules:Navigate to the Purge Jobs and Schedules window. The Parameters window appears.
Select a Job Type.
All Jobs/schedules: Purge information for discrete and lot based jobs with statuses of Closed, and repetitive schedules with statuses of Cancelled and Complete-No Charges. All Jobs/schedules is the default.
Discrete jobs: Purge information for discrete jobs with a status of Closed.
Lot Based Jobs: Purge information for lot based jobs with a status of Closed.
Repetitive Schedules: Purge information for repetitive schedules with statuses of Cancelled or Complete-No Charges.
Select an Action Type.
You can choose from the following:
Purge and Report: Purge the selected jobs/schedules and print a report. You can print the report in Full, Summary, or Detail format. If you select Purge and Report, you must select a Report Type.
Report Only: Print a report listing the selected jobs/schedules but do not purge them. You can print the report in Full, Summary, or Detail format. If you select Report Only, you must select a Report Type.
Purge Only: Purge the selected jobs/schedules but do not print a report. If you choose Purge Only, you must specify that the Report Type is None.
Note: Printing a report before submitting a purge request allows you to view the exceptions that might arise and determine how many records are to be deleted from related tables as a result of the purge.
Specify which job or schedule records to purge by selecting one or more of the following:
Jobs From/To: Purge all jobs in this range that have a close date before the purge cutoff date.
Line: Purge all repetitive schedules produced on this line that have been closed or cancelled before the purge cutoff date.
Assembly: Purge all jobs and repetitive schedules that produce this assembly. If a job range is also specified, only jobs that produce this assembly that are within that range are purged. Similarly, if a production line is specified, only repetitive schedules that produce this assembly on that line are purged.
Note: When purging discrete jobs, you can enter a production line, however this information is ignored when the purge is submitted. If you enter a job range, when purging repetitive schedules, this information is also ignored.
Enter a Cutoff Datetime.
The date and corresponding time component must be less than or equal to the close date of the most recently closed accounting period.
If you choose to purge details in the Purge Options window, the system purges the details (material requirements, resource requirements, and operations) of Closed jobs and Cancelled and Complete-No Charges repetitive schedules with closed, completed, or cancelled dates less than or equal to this date. If you choose to purge Move, Resource, or Move and Resource Cost Transactions, the system purges transactions with dates less than or equal to this date for Closed jobs and Cancelled and Complete-No Charges schedules.
Note: If you enter a date that is earlier than the closed, cancelled or completed date of a selected job or repetitive schedule, the system only purges job and repetitive schedule detail and transaction information up to the date you enter.
Select Yes for Include Configurations to include discrete jobs that build either configured items or models in the purge. Select No to exclude configured items.
If Oracle Bills of Materials purges the configured item that you build in Work in Process, then Oracle Bills of Material replaces the configured item on the job with the model the configuration was based on. You do not want to include configurations if you need this information for customer support. For example, if a customer complains that you did not build the configuration he ordered.
If you do include configurations, you still have access to lot and serial information using the Lot Genealogy window or the lot and serial transactions in Oracle Inventory.
Select whether to purge Headers.
If you purge Headers, all information associated with the parent record and all associated details (material requirements, resource requirements, and operations) and transactions (move and resource transactions) are automatically purged. Shop floor statuses associated with jobs and/or repetitive schedules are also purged. Sales order allocations associated with discrete jobs are also purged.
Note: When you choose to purge headers, the options to include details, move transactions, and resource transactions are automatically selected. You cannot choose to purge header and choose not to purge details are purged even if you choose not to purge details, move transactions, and resource transactions.
Select whether to purge Details
You can selectively purge Details - material requirements, resource requirements, and operations - without purging headers. Selective purging allows you to retain pertinent historical information. For example, you can retain operation information but purge move transactions associated with these operations.
Select whether to purge Move Transactions
You can selectively purge Move Transactions associated with the selected discrete jobs, repetitive schedules, or both. If the move transaction date is less than or equal to the cutoff date you entered, move transactions for repetitive schedules with Cancelled and Complete-No Charges statuses or discrete jobs with Closed statuses are purged.
Select whether to purge Resource Transactions associated with jobs and/or repetitive schedules.
You can selectively purge Resource Transactions associated with the selected discrete jobs, repetitive schedules, or both. Only resource transactions for repetitive schedules with Cancelled and Complete-No Charges statuses are purged, regardless of whether the transaction date is less than or equal to the cutoff date you entered.
Select one of the following Report Types:
Full: The report lists all job and/or schedule records selected for the purge, the table and number of rows affected as well as those records that cannot be purged because of purge rule violations. Full is the default option.
Summary: The report lists all job and/or schedule records selected for the purge but in a tabular form. The table and row detail is omitted although exception information is included.
Exception: The report lists only those job and/or schedule records that cannot be purged because of purge violation rules. Exception information is included.
None: The report lists only the purge options selected (e.g. Headers, Schedule Details, Move Transactions, Resource Transactions), but does not list tables affected and records purged.
In the Days Before Cutoff Date field, you have the option to select another cutoff value for purge calculations. This value, entered in days, is prior to the date and time entered in the Cutoff Datetime field.
If there is a value entered in this field, the system purges jobs and schedules where the Close Date is between Cutoff Datetime and Days before Cutoff. If this field is null, all eligible jobs are considered in the purge where Close Date is less than or equal to Cutoff Date.
Choose OK.
Submit your purge request. See: Submitting a Request.
