When Related Item Are Created BATCH_ORPOS_EXTRACT Is Failing With ORA-01427 Error (Doc ID 2243125.1)

Last updated on MARCH 20, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

BATCH_ORPOS_EXTRACT is failing with the error: "ORA-01427: single-row subquery returns more than one row" when related items are created.
The reason is that orpositemsdnld.sql returns several identical rows for item which has related items defined in Oracle Retail Merchandising System(RMS).

Steps to recreate:
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create 5 regular items.
  2. run batch batch_orpos_extract.ksh
  3. Notice that file is correctly generated for store.
  4. Add upsell, cross and subs for one of the items created in step 1
  5. Run batch batch_orpos_extract.ksh
  6. Notice that batch is failing with error

 

Changes

 

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