Rogerio Antonio

English Version Em Oracle Retail os armazens ( e outras facilities ) tem um ID unico. Neste caso especifico WMS, o RIB vai mandar informacao especifica para esse armazem. Esse ID , tera que estar no RMS, ficheiro TAFRs , e no WMS. A query em baixo retorma essa informacao , na base de dados do WMS, esse 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; Obrigado pela leitura, espero que este post o tenha ajudado. Rogerio Referencias e Mais Info : 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

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

English Version Oracle Retail Allocation e um dos produtos de Oracle Retail ( MOM), embora a base de dados seja MOM, os accessos e a seguranca sao diferentes dos outros produtos MOM. Neste post mosto como criar e configurar um utilizador para Allocations. alter session set current_schema = &&rms_schema INSERT INTO ALC_USERS (USER_ID,USER_NAME,USER_PASSWORD,FIRST_NAME,LAST_NAME,MIDDLE_INITIAL,USER_TYPE,LANGUAGE,COUNTRY) VALUES  (ALC_USERS_SEQ.NEXTVAL,'JSMITH','JackButlandGK23','Joe','Smith',NULL,'A','EN','US'); commit; -- associate departments declare cursor c_deps is select dept from deps; alloc_user_id alc_users.user_id%type; begin select user_id into alloc_user_id from alc_users  where user_name  = 'ACCSERV2'; for  c1 in c_deps loop insert into alc_user_depts(user_depts_id,user_id,dept) values (alc_user_depts_seq.nextval,alloc_user_id,c1.dept); end loop; end; commit; Obrigado pela leitura, espero que este po...

English Version Por vezes e necessario fazer trace a sessao desde inicio, nessas situacoes e util usar um  logon trigger ex: baches de Oracle Retail / RPM / RMS Em seguida partilho tres logon triggers , que podem ser uteis nessas circunstancias, o primeiro usando o hostname do cliente. SQL> drop trigger sys.set_trace_rpm; SQL> create or replace trigger sys.set_trace_rpm after logon on database when (user in ('RPM_OAS')) declare retail_module varchar(200); begin select module into  retail_module from gv$session where sid =  upper(sys_context('userenv','sid')) and (osuser is null and machine like 'rpm_app_server%'); execute immediate 'alter session set statistics_level=all';  execute immediate 'alter session set max_dump_file_size=unlimited';  execute immediate 'alter session set events ''10046 trace name context forever, level 12''';  execute immediate 'alter session set tracefile_identifier=''RA_...

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

Versao Portuguesa Sometimes is useful to trace the session from the beginning, for that is useful to use a logon trigger eg RPM batches I'm sharing three logon trigger examples to help in that situations, the first one using the client hostname, if you know it.  SQL> drop trigger sys.set_trace_rpm; SQL> create or replace trigger sys.set_trace_rpm after logon on database when (user in ('RPM_OAS')) declare retail_module varchar(200); begin select module into  retail_module from gv$session where sid =  upper(sys_context('userenv','sid')) and (osuser is null and machine like 'rpm_app_server%'); execute immediate 'alter session set statistics_level=all';  execute immediate 'alter session set max_dump_file_size=unlimited';  execute immediate 'alter session set events ''10046 trace name context forever, level 12''';  execute immediate 'alter session set tracefile_identifier=''RA_RPM'''; e...