Data Import (DIMP) Takes Excessive Time to Complete Processing in Back Office (BO) (Doc ID 2035450.1)

Last updated on APRIL 16, 2017

Applies to:

Oracle Retail Back Office - Version 14.0.1 and later
Information in this document applies to any platform.

Symptoms

While processing a MOM jar, all the xml files are getting processed immediately.  However, ItemClassificationMod.xml alone takes a very long time to process in Back Office and fails with the below error:

Steps to Reproduce:

  1. Start the BO instance.
  2. Place the MOM jar created from Retail Merchandising System (RMS) in the <DIMP>\incoming folder.
  3. In the table MA_STS_FL_IMP, observe StoreOrgHier.xml and MerchandiseHier.xml process immediately.
  4. Observe that ItemClassificationMod.xml takes more than 40 minutes to process.
  5. After that, ItemExport.xml alone takes more than 20 minutes to process.
  6. In the MA_STS_BNDL_IMP table, there is more than an hour difference from record created and last modified. 
  7. Also observe the above mentioned exception calling multiple times in column DE_IMP_EXCP for ItemExport.xml in table MA_FL_IMP_FLRS.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms