My Oracle Support Banner

Unable To Perform PURGE_TABLE Operation On SVC_NIL_DETAIL_R Staging Table In DC Tool (Doc ID 2869872.1)

Last updated on MAY 23, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

When attempting to truncate the table SVC_NIL_DETAIL_R table via DC tool the following error occurs.

Object type SVC_NIL_DETAIL_R is not valid. Program Name: DC_TASK_PURGE_TABLE

Steps To Reproduce:
1. Login into DC Tool.
2. Select system administration screen from the menu. Submit the PURGE_TABLE task with SVC_NIL_DETAIL_R as the input parameter.
3. Submit the task. Notice the above errors.

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