My Oracle Support Banner

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

Last updated on MARCH 05, 2019

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 below error , when related items are created:

Error:


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:

  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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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