Status and Message Columns
Within the ‘Results’ section of the worksheet there is a column which records the ‘Upload Result’ for each section. The status recorded in these columns is explained below.
Against each section there is an ‘Upload Message’ column. This column records any error messages which may be returned as part of the validation or returned by Oracle via the API or Concurrent program.
For example the following is the ‘Price List Line’ section which has a ‘Price List Lines Upload Message’ column.
Status
The ‘Upload Result’ column for each section should be read in conjunction with the ‘Upload Message’ column, at the start of each section, to determine the overall success of the upload.
The individual statuses are detailed as follows:
|
Status
|
Status Explanation
|
|
Blank
|
Prior to running the validate/upload process.
|
|
Validated
|
The information for this Price List has successfully passed the spreadsheet validation and no errors are reported.
|
|
Accepted
|
All the information for this section has passed validation and has been successfully loaded into Oracle.
|
|
Error
|
All the information for this section has error(s) and has not been uploaded into Oracle. Refer to the ‘Upload Message’ column against the appropriate section for details of the error.
|
|
Pending
|
Information for this section has passed validation and has been successfully loaded into the temporary table to be uploaded by the concurrent request. Loading by the concurrent request is automatically called by the Wizard so no additional action is required. You will however need to refresh the worksheet to return any errors or successful messages returned by the concurrent request.
|
Example
Below is an example of a Price List Wizard worksheet. In this example three Price Lists are being created. The 3rd Price List failed for the 1st and 3rd lines and therefore have an Error status.
To determine what the issue is refer to the appropriate section and ‘Upload Message’ column. For example the following shows the error message for the Attribute records which have an Error status.
