Rogerio Antonio

English Version Neste post mostro como encontrar  queue tables ( inventory adjustments neste caso) e o estado das mensagens.

Versao Portuguesa In Oracle Retail the warehouses ( and other facilities as stores ) have a unique identify. Specific to the WMS, RIB sends/redirects specific information using that ID . That information needs to be in : RMS, TAFRs file and WMS. The bellow query can be used to identify the WMS ID . set lines 20 col description a30 col description form a30 set lines 200 select l.facility_id,description,dc_dest_id from transshipment_setup t, facility l where l.facility_id = t.facility_id; Thank you for reading, hope this post was helpful. Rogerio Futher Reading : https://docs.oracle.com/cd/E82085_01/1303/operations_guide/Chapter%207%20-%20Message%20and%20Routing%20(TAFR).htm https://docs.oracle.com/cd/E12456_01/rwms/pdf/141/html/impg/wms-integration.htm

PT :   RIB - Mover mensagem da ERROR queue para Normal Queue EN : RIB - To Move  message from  ERROR queue to  Normal Queue

English Version Neste post partilho uma a query usada para extratir o mensagens de systemas Oracle AQ queues/topicos. 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; Obrigado pela leitura, espero que este post o tenha ajudado. Versao Portuguesa In post I'm shared a query I used to run to see payload messages in  Oracle AQ queues / topics .  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.u...

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 ...

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 ...

PT :  RIB -  JMS AQ  EN :  RIB -   JMS AQ

English Version Neste post partilho algumas queries que usei para monitorizar o processamento de mensagens no RIB. -- find all items queues SQL> select * from user_queues where queue_type = 'NORMAL_QUEUE' and name like '%ITEM%' --- find all items to process SQL> select * from ETITEMSTLFROMRIBTABLE -- queue subscribers SQL> select * from AQ$_ETITEMSTLFROMRIBTABLE_S -- queue historic SQL> select * from AQ$_ETITEMSTLFROMRIBTABLE_H where msgid = 'FE4C339218D830B1E0440024813309CD' --- find all tables/queue tables SQL> select * from dba_tables where table_name like '%ETITEMSTLFROMRIB%' Testar Integracao - RMS > WMS Uma forma facil de testar a integracao (RIB) apos adicionar um novo warehouse (WMS), e actualizar um Item no RMS e validar se as alteracoes estao a ser transmitidas ao WMS, no exemplo seguinte mostro como fazer isso, e os tabelas/queues envolvidas. Item : 101715654 -- RMS DB SQL> select  item, item_desc  from item_master wher...

PT :  RIB -  JMS AQ  EN :  RIB -   JMS AQ

Versao Portuguesa In this post i'm sharing some queries I used to monitoring the messages processing in RIB. -- find all items queues SQL> select * from user_queues where queue_type = 'NORMAL_QUEUE' and name like '%ITEM%' --- find all items to process SQL> select * from ETITEMSTLFROMRIBTABLE -- queue subscribers SQL> select * from AQ$_ETITEMSTLFROMRIBTABLE_S -- queue historic SQL> select * from AQ$_ETITEMSTLFROMRIBTABLE_H where msgid = 'FE4C339218D830B1E0440024813309CD' --- find all tables/queue tables SQL> select * from dba_tables where table_name like '%ETITEMSTLFROMRIB%' Tesing the Integration - RMS > WMS An easy way to test the integration (RIB) , after add a new warehouse (WMS), is to choose an Item in RMS , update the description, commit the changes and validate if they are being cascaded to the WMS. After the validation put back the original description . Eg : Item : 101715654 -- RMS DB SQL> select  item, item_desc...