Purge Unprocessed Records
Use the Purge Unprocessed Records scheduled process to purge temporary, unprocessed data from Oracle Fusion Supply Chain Collaboration after a defined period.
Unprocessed data includes any forecasts and request status details, as well as unprocessed collaboration relationship candidates, for a specified Supply Plan or all plans in the Supply Chain Collaboration interface tables. Additional purged data includes previous cycle forecasts data, if there is a previous cycle without a matching current cycle and if it's older than a specific number of days.
These configuration parameters are used to purge data records after a specified number of days, and can be modified to suit your needs:
- SUPPLY_PLANNING_FORECASTS_INTERFACE_DATA_RETENTION_DAYS
- SUPPLY_PLANNING_CONVERTED_CANDIDATES_RETENTION_DAYS
- SUPPLY_PLANNING_PREVIOUS_FORECAST_RETENTION_DAYS
When to Use
We recommend that you schedule this process to run on a weekly basis. Depending on the volume of interface data that your business process uses, you can run it less frequently
Privileges Required
- Manage Supply Planning Network Relationships (VCS_MANAGE_SUPPLY_RELATIONSHIPS_PRIV)
Specifications
Review these specifications before setting up this scheduled process:
Specification | Description |
Job Type | Can be run on a regular basis, based on your business process data volume. It also can be run at any time, if required. |
Frequency |
Once a week, or less frequently. |
Time of Day |
Should be run during off hours. |
Duration |
Varies, based on the overall volume of data your collaboration process uses. This includes the number of records created or expired since the last time you ran the scheduled process |
Compatibility | Only one instance of the job should be running at any time. There’s no current functional need to run multiple instances of this process simultaneously. |
Parameters
Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
Supply Plan | Required | The name of the associated Supply Plan for which to purge interfaces records. | Plan Name | None | NA |
Troubleshooting Information
- You can view the status of the Purge Unprocessed Records scheduled process on the Scheduled Processes work area.
- The validation errors and warning messages that prevented the new cycle from completing display in the error log, along with purged record counts.