RPM Overlapping clearances and their resets

 Hi,

I've notice (in version 12.0.3) that if I create two overlapping clearances I only get one reset clearance for both.

Please consider the following scenario.

I create and approve a first clearance:

-----------------------------------

Clearance 1

Item: X

Location: Y

Start date: 1/1/2013

Reset date: 20/1/2013

-----------------------------------

After approving this first clearance RPM automatically creates the following clearance reset, linking it to Clearance 1 through the CLEARANCE_RESET_IT field:

-----------------------------------

Clearance Reset

Effective date: 20/1/2013

-----------------------------------

After this I create and approve a second clearance for the same item/location, as follows:

-----------------------------------

Clearance 2

Item: X

Location: Y

Start date: 5/1/2013

Reset date: 15/1/2013

-----------------------------------

Following are the tables entries in RPM_CLEARANCE after this second clearance is created and approved (I am also uploading an Excel with this as an attachment to this post):