RMS WH Publisher Does Not Publish Any Messages When One WH Does Not Have the Mandatory Addresses Defined (Doc ID 2214175.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

When the first record in WH_MFQUEUE does not have the mandatory addresses defined, RMS WH publisher adapter does not publish any of the next messages from WH_MFQUEUE.

 
Steps to Recreate:

 1. Log in to RMS and create a warehouse (WH#1).
 2. When adding the warehouse addresses, close the RMS session.
 3. Notice one record is inserted in WH_MFQUEUE in 'U'npublished status.
 4. Log in to RMS again.  Create another warehouse (WH#2) and complete the addresses (and other mandatory details).
 5. Notice multiple records (header, address related) are inserted in WH_MFQUQUE in 'U'npublished status.
 6. Notice that even though WH#2 has all required records, it is not published from WF_MFQUEUE and status is still 'U'npublished.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.