Delete Pricing Data from Interface Tables
Use the Delete Pricing Data from Interface Tables scheduled process to delete pricing data from your interface tables.
When to Use
Run it after you finish the import. It helps improve performance. For details, see the Delete Pricing Data from Interface Tables subtopic in Import Batches of Price Lists.
Privileges Required
- Import Price Lists (QP_PRICE_LIST_IMPORT_PRIV)
Specifications
Use these specifications when you run the scheduled process.
Specification | Description |
---|---|
Job Type | Its recommended that you use Scheduled, but you can also run it on demand, when needed. |
Frequency | There are no constraints. |
Time of Day | Run it when your system isn't processing a lot of transactions. |
Duration | It is quick because it truncates the interface tables, and then creates them again. |
Compatibility | This is a built in feature. |
Parameters
None.