When creating a new modifier, you cannot create Qualifier Line Level records at the same time as creating the Qualifier Header level record; this is a restriction of the Oracle Modifiers API rather than the Wizard itself. For the first upload, the Wizard will ignore the line level qualifiers, simply reload the modifier and the line level qualifiers will be added to the Pricing Modifier.
To upload, use your cursor to select the range or single record you need to validate and/or upload. Make sure you have included the first line of each Pricing Modifier to be uploaded. The columns selected are NOT important.
Pricing Modifiers Wizard searches through the spreadsheet between the top and bottom of the range you have indicated. If necessary, Pricing Modifiers Wizard will continue past the end of the range to complete the last Pricing Modifier selected.
On the Pricing Modifiers Wizard ribbon, select the ‘Validate Only’ or ‘Validate Commit’ option (Refer to section Upload Pricing Modifiers).
Select the ‘Create/Update’ or ‘Update Only’ option on the Pricing Modifiers Wizard ribbon (Refer to section Upload Pricing Modifiers).
Click the ‘Upload’ icon and select ‘Upload Selected’.
If uploading a Pricing Modifier into Oracle the overall status against the Header indicates that the header, lines and attributes were uploaded into Oracle. If this has a status of Accepted then the entire record (including header, qualifiers, lines and attributes) has been loaded into Oracle. If there is an issue with any of the data then the entire Pricing Modifier will not be loaded into Oracle.
