This purge removes inventory data from the system. This reduces the load on frequently accessed tables. This purge does not take retention days into account when purging.
You can use purge codes pseudo-logic to analyze purges.
For YFS_INVENTORY_SUPPLY, if the following conditions are met, an inventory supply is picked up for purge:
For YFS_INVENTORY_DEMAND, if the following conditions are met, an inventory demand is picked up for purge:
For YFS_INVENTORY_TAG, it is purged if the INVENTORY_TAG_KEY is not used by any of the existing supply and demand.
For YFS_INVENTORY_RESERVATION, an inventory reservation is picked up for purge if it meets the following conditions:
For YFS_INVENTORY_NODE_CONTROL, it is purged if the INV_PIC_INCORRECT_TILL_DATE is earlier than the current time stamp minus the purge criteria's retention days.
For YFS_IBA_TRIGGER, it is purged if IBA_REQUIRED = 'N', IBA_RUN_REQUIRED = 'N', and LAST_IBA_PROCESSED_TS is earlier than the current time stamp minus the purge criteria's retention days.
Any enterprise using the Console must schedule purge transactions.
The following are the attributes for this time-triggered transaction:
Attribute | Value |
---|---|
Base Transaction ID | INVENTORYPRG |
Base Document Type | General |
Base Process Type | General |
Abstract Transaction | No |
APIs Called | None |
User Exits Called | YFSBeforePurgeUE |
The following are the criteria parameters for this transaction:
Parameter | Description |
---|---|
Action | Required. Triggers the transaction. If left blank, it defaults to Get, the only valid value. |
Number of Records To Buffer | Optional. Number of records to retrieve and process at one time. If left blank or specified as 0 (zero), it defaults to 5000. |
EnterpriseCode | The inventory organization for which the Inventory Purge needs to be run. |
Live | Optional. Mode in which to run. Valid values are:
|
PurgeCode | Required. Cannot be modified. Used for internal calculations, such as determining retention days. Corresponds with the PurgeCode used in Business Rules Purge Criteria. |
ColonyID | Required in a multi schema deployment where a table may exist in multiple schemas. Runs the agent for the colony. |
The following statistics are tracked for this transaction:
Statistic Name | Description |
---|---|
NumInventoryDemandsPurged | Number of inventory demands purged. |
NumInventoryNodeControlsPurged | Number of inventory node controls purged. |
NumInventoryReservationsPurged | Number of inventory reservations purged. |
NumInventoryTagsPurged | Number of inventory tags purged. |
NumItemBasedAllocationTriggers |
Number of item based allocation triggers purged. |
For this transaction, the pending job count is the total number of records that can be purged from the YFS_Inventory_Supply, YFS_Inventory_Demand, YFS_Inventory_Tag, YFS_Inventory_Reservation, YFS_IBA_Trigger, and YFS_Inventory_Node_Control tables.
None.
YFS_IBA_TRIGGER
YFS_INVENTORY_DEMAND
YFS_INVENTORY_TAG
YFS_INVENTORY_RESERVATION
YFS_INVENTORY_SUPPLY
YFS_INVENTORY_NODE_CONTROL