IBM Support

In Sterling MCF version 8.5; Records in YFS_Person_Info table are not being purged by Person Info purge agent.

Question & Answer


Question

In Sterling MCF version 8.5; Records in YFS_Person_Info table are not being purged by Person Info purge agent.

Answer

The Person Info Purge agent purges records from the YFS_Person_Info table only when there are no references to that record to orders in either the live or the history tables.

References to History tables are also checked since orders can be restored from history tables. Hence, to be able to purge records from the YFS_Person_Info purge table, the associated orders should be purged from the history tables as well.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

FAQ4229

Document Information

Modified date:
16 June 2018

UID

swg21518833