My Oracle Support Banner

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'.


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

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