My Oracle Support Banner

Patch for Bug 29964022 Fails to Fix ORA-08102 Error on DLYPRG.PC Batch (Doc ID 2626854.1)

Last updated on JANUARY 09, 2020

Applies to:

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

Symptoms

 The DLYPRG.PC (Daily Purge) batch fails with the ORA-08102 error in the DEL_ITEM package. There was a fix available but it did not resolve the issue until 16.0.2_Jun2019_1 Cumulative Hot-fix.

Error

"sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-08102: index key not found, obj# 1492842, file 96, block 1304834 (2)@2DEL_ITEM"

Steps to Reproduce

  1. Apply the Patch for <Bug 29964022>.
  2. Re-test the scenario for the <Bug 29964022>.
  3. Notice the ORA-08102.

 

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.