Purge External Purchase Prices Interface Data
Use the Purge External Purchase Prices Interface Data scheduled process to purge interface table data and the corresponding records in error tables.
When to Use
Schedule the process to selectively delete records based on criteria such as deleting only records with error or deleting all records in the interface table.
Privileges Required
- Delete External Purchase Prices Interface Data (SCH_DELETE_EPP_INTERFACE_DATA_PRIV)
Specifications
Review these specifications before you set up the scheduled process.
| Specification | Description |
|---|---|
| Job Type | Ad hoc job or scheduled This process can be scheduled or submitted manually to delete interface records. However, scheduled runs should typically be for clearing records that have been in error for a long time. |
| Frequency | The process should be scheduled to run according to the frequency with which the interface data is populated. |
| Time of Day | After work hours or during weekends. |
| Duration | Variable, based on the total number of records being purged. |
| Compatibility | There should be only one instance of the job running at any time and, there's no current functional need to run multiple instances of this process simultaneously. This process is automatically placed on hold when the Import Purchase Agreements from External Purchase Prices scheduled process is running. It automatically resumes after the earlier process is completed. |
Parameters
| Parameter | Optional or Required | Description | Parameter Values | Special Combinations Required | Notes |
|---|---|---|---|---|---|
| Source Organization | Required | Specify the unique identifier or code or name of the organization in the source system for which you want to purge document interface records. | Source organization code or identifier | None | N/A |
| Source Contract Number | Optional | Specify the source contract number for the external purchase price. | Source contract number | None | N/A |
| Source Contract Reference | Optional | Specify the unique identifier for the header record in the source system. | Unique identifier for the header record | None | N/A |
| Creation Start Date | Optional | A date used to verify if the interface record was created after the start date specified. | Calendar | None | N/A |
| Creation End Date | Optional | A date used to verify if the interface record was created before the end date specified. | Calendar | None | N/A |
| Batch ID | Optional | Enter the batch ID corresponding to the set of records in the interface table that need to be retrieved for purging. | Value of the batch ID | None | N/A |
| Deletion type | Required | Specify Delete records in error to delete only records in error. Specify Delete all records to delete all records, irrespective of whether they're in error or not. | Delete records in error or Delete all records | None | Default value is Delete records in error |
Troubleshooting Information
- Use the 'Delete all records' value for the Deletion type parameter thoughtfully to avoid deleting necessary records without any errors.
- The process will remove related records from the SCH_EPP_HEADERS_INT, SCH_EPP_LINES_INT, and SCH_EPP_ERRORS tables based on your criteria.
- Always verify the parameters before purging, as deleted data can't be recovered.