Purge Interface Data of External Purchase Prices
Use the new scheduled process, Purge External Purchase Prices Interface Data, to purge interface table data and the corresponding records in error tables.
Prior to update 25C, you could reprocess any records with errors by running the Import External Purchase Prices scheduled process with the Reprocess Error parameter set to Yes.
However, from update 25C onward, if you opt in to the Allow Partial Processing of Interface Records in External Purchase Prices feature, then any records with errors are no longer reprocessed. Instead, you must reimport the corrected data into the interface tables and manually purge the records with errors. With this update, you can schedule or manually submit the Purge External Purchase Prices Interface Data scheduled process to automatically purge records with error.
The Purge External Purchase Prices Interface Data scheduled process lets you selectively delete records based on various criteria such as deleting only records with error or deleting all records in the interface table. This new process streamlines data correction, prevents clutter from unneeded records (including uploads with error), and supports better data integrity and operational efficiency for external purchase prices interface tables.
The following table lists the parameters of the Purge External Purchase Prices Interface Data process
| Parameter | Optional or Required | Description | Parameter Values | Validation |
|---|---|---|---|---|
| Source Organization | Required | Unique identifier or code or name of the organization in the source system for which you want to purge document interface records. | N/A | None |
| Source Contract Number | Optional | Source contract number for the external purchase price. | N/A | None |
| Source Contract Reference | Optional | Unique identifier for the header record in the source system. | N/A | None |
| Creation Start Date | Optional | Date used to verify whether the interface record was created after the specified start date. | N/A | None |
| Creation End Date | Optional | A date used to verify whether the interface record was created before the specified end date. | N/A | None |
| Batch ID | Optional | Use to match against the records in the interface tables to retrieve the correct records for purging. | N/A | None |
| Deletion type | Required | A value of ‘Delete records in error’ indicates that only records in error will be deleted. ‘Delete all records’ indicates that all records, irrespective of whether they are in error or not, will be deleted. |
- Delete records in error - Delete all records |
Default Value = Delete records in error |
Review these specifications before you set up the scheduled process.
| Specification | Description |
|---|---|
| Job Type | This process can be scheduled or submitted manually to delete the interface records with errors. However scheduled runs should typically be for clearing records that have been in error for a long time. |
| Frequency | The process should be run according to the frequency with which the interface data is populated. |
| Time of Day | Preferably, after work hours or during weekends. |
| Duration | The runtime of this process varies based on the total number of records being purged. |
| Compatibility | There must be only one instance of the job running at any point of time. This is automatically handled by the application.
This process is automatically placed on hold when the Import Purchase Agreements from External Purchase Prices scheduled process is running. And it automatically resumes after the earlier process is completed. |
Steps to Enable
You don't need to do anything to enable this feature.
Tips And Considerations
- 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 cannot be recovered.
Access Requirements
Users who are assigned a configured job role that contains this privilege can access this feature:
-
Delete External Purchase Prices Interface Data (SCH_DELETE_EPP_INTERFACE_DATA_PRIV)
This privilege was available prior to this update.