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.
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.
"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
- Apply the Patch for <Bug 29964022>.
- Re-test the scenario for the <Bug 29964022>.
- Notice the ORA-08102.
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