iStore Section/Catalog: Items Not Displayed/Missing/Disappear (Doc ID 744313.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Symptoms

Oracle iStore Catalog (or Section Home) does not show any products.

Steps to Reproduce

• Add item to a section in iStore Administrator UI
• Access the iStore Catalog or home page (storefront)
• See no products displayed

Other symptoms

• Unable to add items via iStore Administrator UI
• Product list of values (LOV) in the iStore Administrator UI does not show any items.
• iStore "Product Autoplacement" concurrent program does not populate any items even though the item category was assigned to the section
• Product Search does not return any products on a newly created minisite
• Search returns no products on a newly created iStore site. This is because new site pointing to a different responsibility which belong to a different Item Master.
• iStore Java Log may show "Item not found", below is a sample log:
  
  5:52:4:297 [Section.getItemIDs(BigDecimal)] Getting item IDs for section with ID '1170' and display name 'Miscellaneous"
  5:52:4:297 [Section.getItemIDs(BigDecimal)] Organization ID: 210
  5:52:4:298 [Section.filterItemsByStatus(int[])] 1841931- START
  5:52:4:298 [Section.removeExclusions(int[], int)] START
  5:52:4:302 [ibeCCtdCmnSctLayout.jsp]
  Item not found

Cause

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