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.