Granted Patent B2

US 11,042,830 · App. 16/778,348 · Granted Jun 22, 2021

Abstract

Claims (51)

1. A method comprising:

receiving, by a processor, a commissioning event in a supply chain, wherein the commissioning event includes an identifier that identifies an item that is a commissioned item;

associating, by the processor, the commissioning event with the identifier;

storing, by the processor, the identifier in a database as ungrouped data elements formatted as a block of binary (BLOB);

tuning, by the processor, the database to optimize database performance;

obtaining, by the processor, the identifier from the database for the commissioning event;

determining, by the processor, whether an event sequence exists for the identifier;

initiating, by the processor, the event sequence for the identifier, in response to the event sequence not previously existing;

determining, by the processor, that an event in the event sequence for the identifier is earlier than the commissioning event;

setting, by the processor, a state of the identifier to a potential duplicate condition;

determining, by the processor, that the state of the identifier indicates a missing commissioning event for the event sequence;

determining, by the processor, whether the commissioning event satisfies the missing commissioning event;

clearing, by the processor, the state of the identifier for the missing commissioning event, in response to the commissioning event satisfying the missing commissioning event; and

updating, by the processor, the state of the identifier for the missing commissioning event with the commissioning event that does not satisfy the missing commissioning event, in response to the commissioning event not satisfying the missing commissioning event.

2. The method of claim 1 , wherein the identifier is an electronic product code (EPC).

3. The method of claim 1 , further comprising:

determining, by the processor, that the identifier is not known; and

storing, by the processor, the identifier in a database.

4. The method of claim 1 , wherein the event includes at least one of a state or change of the state associated with the item.

5. The method of claim 1 , wherein the commissioning event includes identifying at least one of the item that is sellable, a container associated with the item or aggregation hierarchies for the item.

6. The method of claim 1 , further comprising receiving a decommissioning event issued in response to at least one of destruction of an unconsumed item, an expired item, a damaged item, a recalled item, an item being dispensed, an item being consumed or an item being discarded.

7. The method of claim 1 , further comprising:

determining, by the processor, whether the commissioning event exists in the event for the item; and

generating, by the processor, an error status for the item, in response to the determination that no commissioning event exists in the event for the item.

8. The method of claim 1 , further comprising:

determining, by the processor, whether a plurality of commissioning events exist in the event for the item; and

generating, by the processor, a suspect status for the item, in response to the determination that the plurality of commissioning events exists in the events for the item.

9. The method of claim 1 , further comprising:

determining, by the processor, whether any receiving events exist in the event for the item;

determining, by the processor, whether an associated shipping event exists for each receiving event; and

generating, by the processor, an error status for the item, in response to the determination that there is not the associated shipping event for the receiving event.

10. The method of claim 1 , further comprising:

determining, by the processor, whether any shipping events exist in the event for the item;

determining, by the processor, whether an associated receiving event exists for each of the shipping events; and

generating, by the processor, an error status for the item, in response to the determination that there is not an associated receiving event for at least one of the shipping events.

11. The method of claim 1 , further comprising:

identifying, by the processor, one or more contiguous chains of events within the event sequence;

matching, by the processor, one or more pairs of events;

forming, by the processor, one or more trees of links from the matched pairs of events; and

identifying, by the processor, each tree as one of the contiguous chains of events.

12. The method of claim 1 , further comprising adding, by the processor and in response to a condition reflecting error, a subset of the items associated with the identifier to be commissioned at least one of on the production line, as a shipment is being packed, or by a wholesaler.

13. The method of claim 1 , further comprising creating, by the processor, at least one of a new link for related events or an unlinked event by utilizing a rules engine.

14. The method of claim 1 , further comprising removing, by the processor and in response to a condition reflecting error, a subset of the items associated with the identifier.

15. The method of claim 1 , further comprising:

receiving, by the processor, a set of custom rules from an entity in the supply chain; and

assessing, by the processor, the retrieved events by utilizing the set of custom rules.

16. The method of claim 1 , further comprising:

reading, by the processor, a plurality of stored parameters from an entity in the supply chain;

creating, by the processor, a set of custom rules for the entity; and

assessing, by the processor, the retrieved events by utilizing the set of custom rules.

17. The method of claim 1 , further comprising reporting, by the processor and in accordance with a rule, a new commissioning event as suspect, in response to the item having a commissioning event, and no previous decommissioning associated with the item.

Assignments (6)