Troubleshoot Importing Batches of Discount Lists
Troubleshoot problems that happen when you import a batch of discount lists.
Trouble |
Description |
---|---|
I don't see my batch in the Batch Name attribute on the Process Details dialog when I try to run the Import Discount Lists scheduled process. |
Different problems might cause this trouble.
|
I encounter an error in the scheduled process log.
|
Make sure the attribute contains a value and that your value is the correct data type. For example, the data type for SET_ID is Number(18), so make sure it contains numeric data with precision 18. For details, go to SQL Language Reference, then expand Basic Elements of Oracle SQL > Data Types. |
I examine the error logs but they seem incomplete. |
Wait for all processes to reach their "terminal" state. Processing continues to add details to the log even after it sets the process status to Error. To determine whether the process is done, click Error in the status column, then verify that the dialog displays this text.
Also, each process creates two files, one with a log extension and the other with the txt extension. To view both, click more in the link next to Attachment of the log area on the Overview page in the Scheduled Processes work area. |
I encounter an error in the scheduled process log.
|
This error happens when you set the action to CREATE for an entity, such as a discount list, but the entity already exists. Change the name in template, or delete the entity in Pricing Administration, then import again. If you import again with the same template, make sure you remove records that the import successfully processed. The scheduled process imports records sequentially. For example, assume your template includes DISCOUNT_LIST_1 and DISCOUNT_LIST_2, the import successfully imports DISCOUNT_LIST_1 but fails while attempting to import DISCOUNT_LIST_2. You correct the error in the template for DISCOUNT_LIST_2 but don't remove DISCOUNT_LIST_1. You upload and import again, but this time you encounter the duplication error for DISCOUNT_LIST_1. This happens because the first import already imported DISCOUNT_LIST_1 into the database. |
I encounter an error in the scheduled process log.
|
Try this.
Troubleshoot depending on the command you use on QP_DISCOUNT_LIST_SETS_INT.
|
Note
-
If you delete data in the Pricing Administration work area to fix a duplication problem, it might not be necessary to run the Load Interface File for Import scheduled process again because you haven't changed data in the interface tables. Try running only the Import Discount Lists scheduled process.