My Oracle Support Banner

RMS 12: Missing TRAN_TYPE 25 POSMODS While Changing the Parent Item Location Status (Doc ID 1981913.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Retail Merchandising System - Version 12.0.10 to 12.1 [Release 12.0]
Information in this document applies to any platform.


Missing TRAN_TYPE 25 in POS_MODS table while changing the parent item location status.

Steps To Reproduce:

1. Create a new level 1 parent item and create a level 2 transaction item for level 1.

2. In Location screen -
- select the below option, if not already selected/ticked.
Apply additions and modifications to all items below the current item down to the transaction level.
- Under the same locations screen, Add a store to the level 1 item with status 'A' and click apply.

3. Check and verify that the same store is added to the level 2 transaction level item with status 'A'

4. Entry to the POS_MODS table will be made for the level 2 transaction level item with TRAN_TYPE = 1, with status 'A'

5. Open the item created in step 1 in Edit mode and go to transaction level 2 item.

6. open the location screen of level 2 item and select the store added in step 2 and change the status to 'D' and click apply. Come out of the item screen.

7. POS_MODS entry will be made with TRAN_TYPE 25 for the tran level 2 item.

8. Now again open the level 1 item in edit mode and go to locations screen for level 1 item.

9. select the store for which the status was set to 'D' in step 6 and click apply button. Note that for this store the status is 'A' for level 1 item. [ with the option mentioned in step 2 ticked ]

10. Check POS_MODS table, there will be no entry for tran_type 25, even though the status has been changed for level 2 from 'D' to 'A'.

Expected result --> A tran type 25 for status change D to A should come in POS_MODS table for level 2 tran item.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.