PRDCLRSDE.KSH Batch Status Is Not Changing to 'Success' Even After Successful Completion

(Doc ID 2033041.1)

Last updated on JUNE 13, 2017

Applies to:

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


In Oracle Retail Analytics (RA), PRDCLRSDE.KSH batch status is not updated to 'Success' after finishing successfully.  It remains in 'In Progress' status.

Steps to Recreate:

  1. Run PRDCLRSDE.KSH batch.
  2. Batch finishes successfully.
  3. Check the PACKAGE_STATUS column value in C_LOAD_DATES table.  Not that it shows 'IN PROGRESS' status instead of 'SUCCESS'.


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