RIB 13.1.x - Test Items

EnglishVersion

Apos adicionar um novo warehouse / WMS a solucao de Oracle Retail, ou refrescar um ambiente, e recomendavel testar a integracao RMS --> WMS antes de passar a bola ao negocio or project team.
Nest post partilho uma forma facil de fazer esse teste - e como monitorizar a mensagem.

Na base de dados do RMS, Alterar a descricao do Item : 101715654

select item, item_desc from item_master where item ='101715654'
ITEM ITEM_DESC
101715654 ITEM XPTO

update rms.item_master
set item_desc = 'ITEM XPTO - DESC CHANGED'
where item='101715654';
select item, item_desc from item_master where item ='101715654';
commit;

Na base de dados do RIB
Validar se a mensagem esta na queue/topic : 101715654

set lines 300
col enq_time form a30
col deq_time form a10
col msg form a100
set longchunksize 30000
set long 30000
select msgid,enq_time, deq_time, r.user_data.text_lob msg
from ribaq.etitemsfromrmstable r
where
enq_time > sysdate - 1
and r.user_data.text_lob like '%101715654%'
order by enq_time;

Na base de dados do WMS

Validar se a desccricao do item foi alterada mensagem : 101715654
se correu tudo bem, repor a descricao original

select item_id, description from wms.item_master where item_id ='101715654';
101715654 ITEM XPTO - DESC CHANGED

Obrigado pela leitura, espero que este post o tenha ajudado.
Rogerio

Versao Portuguesa

After add a new warehouse / WMS to teh Oracle Retail soluction , is recommended to test the integration RMS --> WMS before to deliver it to to the business.
In this post i'm sharing an easy way to make that test. RMS database change a Item desciption : 101715654

select item, item_desc from item_master where item ='101715654'
ITEM ITEM_DESC
101715654 ITEM XPTO

update rms.item_master
set item_desc = 'ITEM XPTO - DESC CHANGED'
where item='101715654';
select item, item_desc from item_master where item ='101715654';
commit;

RIB database Is possible to monitor the RIB database to see the message passing - to check if is in the queue/topic : 101715654

set lines 300
col enq_time form a30 
col deq_time form a10 
col msg form a100 
set longchunksize 30000 
set long 30000 
select msgid,enq_time, deq_time, r.user_data.text_lob msg 
from ribaq.etitemsfromrmstable r 
where 
enq_time > sysdate - 1 
and r.user_data.text_lob like '%101715654%' 
order by enq_time; 

WMS database

Check if the item description was changed 101715654 <> if all fine put the original description back
select item_id, description from wms.item_master where item_id ='101715654';
101715654 ITEM XPTO - DESC CHANGED



Thank you for reading, hope this post was helpful.
Rogerio

select item_id, description from wms.item_master where item_id ='101715654';
101715654 ITEM XPTO - DESC CHANGED

Thank you for reading, hope this post was helpful.
Rogerio