To delete available-to-promise (ATP) inventory objects:
- Type the following:
. dbclean.sh -object atp_inventory -type typename -instancexml instancename -db dbname -loglevel loglevell -dbtype oracle -dbuser user -dbpasswd password
dbclean -object atp_inventory -type typename -instancexml instancename -db dbname -logLevel loglevell -dbtype oracle -dbuser user -dbpasswd password
Use host:port:sid for the Oracle database name. For example, myhost:1521:mydb.
- Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.