Related Documents
Document Properties
Kbid29H509
Last Modified08-Jul-2020
Added to KB09-Jul-2020
Public AccessEveryone
StatusOnline
Doc TypeReferences
Product
  • ICM 7.6
  • ICM 7.7
  • ICM 7.8
  • ICM 7.9
  • ICM 7.10

Job - ProductPrice Cleanup

Name

ProductPrice Cleanup

Domain

<Organization>-<Channel>

Job Dependencies

none

AcquiredResources

none

Cartridge

bc_pricing

Pipeline

ProcessProductPriceCleanup-Start

Affected Domain Objects

ProductPriceBO, ProductPriceScaleBO

Affected Tables

  • Pricelists
    pricescaleentry
    pricescaleentry_av
    pricescaletable
    pricescaletable_av
    pricescaletableassignment
  • Jobs
    jobconfiguration
    jobconfiguration_av
  • Locking
    acqlogentry
    acqlogentryresourceassignment
    acqlogentry_av
    isresource
    isresource_av
    jobresourceassignment
    process
    process_av
    resourcelock
    staginggroupresourceassignment

Stored Procedure


Default State

Enabled

Is Site Specific

True

Edit State

Globally Enabled

Live State

Locally Enabled

Description

Removes price list prices older than the configured number of days.

Scheduling

Depends on usage of price lists. The more price lists and price scale tables with specified valid-to dates, the more often the job should be called.

What Happens Switched Off

PriceScaleTable, PriceScaleTable_AV, PriceScaleEntry, PriceScaleEntry_AV, PriceScaleTableAssignment tables grow.

Trouble Shooting

The LifeTime attribute specifies the number of days in the past in which obsolete prices will be searched for.

Comments

Product Version

7.0

Product To Version


Statusfinal

Disclaimer

The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.

Customer Support
Knowledge Base
Product Resources
Support Tickets