7 Supplier Administration

The following topics are covered in this chapter:

Alerts

Select the Alerts option from the Admin drop-down list. The following options are available in the left pane:

Mailing Lists

Mailing lists can be used to create a predefined list of recipients to receive alerts.

To create a mailing list:

  1. Select the New Mailing List action. The New Mailing List tab opens.

  2. Enter the name of the mailing list. This field is mandatory.

  3. Select the list of users from which you can choose the recipients in this mailing list. You can select Sites, Suppliers, or Sites & Suppliers. Open the Recipients tab to select from the list of available users.

  4. Select the Save action.

Manage Alert Status

This option enables you to view the alert status codes and descriptions defined for each. To edit the list, select the Edit action. You can change the descriptions and add new status codes.

Figure 7-1 Alert Status Page

This figure shows the Alert Status page.

Manage Alert Response Status

This option enables you to view the alert status response codes and the descriptions defined for each. To edit the list, select the Edit action. You can change the descriptions and add new status response codes. The Alert Response Status page has the same format as the Alert Status page shown in Figure 7-1.

Suppliers & Sites

Billing Codes

This option is used to define the billing codes used when creating a new supplier. The billing code determines how costs are calculated during the registration process. Billing codes are optional. If billing is not applicable or a portal, a code could be defined with a zero charge.

During the registration of a new supplier in the Supplier module, the values in this table are used to determine the cost charged for the registration:

Registration Cost equals Fixed Price plus (Charge Per Site multiplied by the number of sites registered)

For more information, see the Oracle Retail Brand Compliance Management Cloud Service Supplier User Guide.

Figure 7-2 Billing Codes Page

This figure shows the Billing Codes page.

To edit the list of billing codes, select the Edit action. The table opens in edit mode. The code and any existing descriptions cannot be edited.

To add a new billing code, click Add. A new row is added to the table. Enter the code, charge per site, fixed price, description in the default language. Enter any translations. Select the Save action.

Order Requests

This option is used to manage registration order requests.

To work with orders:

  1. Select Order Requests. The list of orders appears. It is sorted into processed and unprocessed orders.

    Figure 7-3 Orders Page

    This figure shows the Orders page.
  2. To see the details for an order, select the order and then select the View action. A new tab opens with the order details in read-only mode. For an example of the content, see Figure 7-4.

  3. To edit an order, select the order an then select the Edit actions. A new tab opens with the order record in edit mode.

    Figure 7-4 Order Details Page

    This figure shows the Order Details page.
    • Order status: Choose the status from the drop-down list. The status can be updated to Processed once the supplier has been billed.

    • Contact Details: The Phone and Fax fields can be updated.

    • Comments: Enter any comments.

Supplier Statuses

This option is used to define the statuses that can be associated with the registration of a supplier. The codes are defined by the system; new codes cannot be added. To edit the existing codes, select the Edit action. The table opens in edit mode. Any translations that do not already exist can be added. No other changes can be made.

Figure 7-5 Supplier Statuses Page

This figure shows the Supplier Statuses page.

Site Statuses

This option is used to define the statuses that can be associated with a site. The statuses are defined by the system; new statuses cannot be added. To edit the existing statuses, select the Edit action. The table opens in edit mode. Any translations that do not already exist can be added. No other changes can be made.

Figure 7-6 Site Statuses Page

This figure shows the Site Statuses page.

Business Categories

Select the Business Categories option in the left pane. The list of defined business categories appears in the right pane. Each top-level category can be expanded to show its child categories.

Figure 7-7 Business Categories Page

This figure shows the Business Categories page.

To edit a category entry, select the entry in the left pane and then select the Edit action in the right pane. The category opens in edit mode. The descriptions and specification types can be edited. For an example of the content of this page, see Figure 7-8.

To create a new top-level category:

  1. Click Create new top-level category. The Business Category Details page opens.

    Figure 7-8 Add Business Category Details Page

    This figure shows the Add Business Category Details page.
  2. Enter the details for the new category:

    • Enter the code. This is a mandatory field.

    • Enter the description for the default language. This is a mandatory field. Enter any translations.

    • To select the specification types for this level, click the icon. The Select Specification Types dialog box appears. Select the specifications for this level and click Ok.

  3. Select the Save action. The business category is added to the list of categories.

  4. To add child categories, select the top-level category and then select the Add Child Category action.

  5. Enter the details for the child level and select the Save action.

Supplier Types

This option is used to define the types of suppliers that can be created.

Figure 7-9 Supplier Types Page

This figure shows the Supplier Types page.

To edit the list of supplier types, select the Edit action. The table opens in edit mode. For existing supplier types, only the translated descriptions that do not already exist can be edited. To add a supplier type, click Add. A new row is added to the table. Enter the new supplier type and description in the default language. Enter any translations. Select the Save action.

Site Types

This option is used to define the types of sites that can be created.

To edit the list of site types:

  1. Select the Edit action. The table opens in edit mode. For existing site types, only the translated descriptions that do not already exist can be edited.

  2. To add a site type:

    1. Click Add. A new row is added to the table.

    2. Enter the new site type and description in the default language. Enter any translations.

    3. To select the specification types enabled for this site, click the icon and select the specifications in the dialog box. Click Ok.

  3. Select the Save action.

Maintenance Audit Reasons

This option is used to define the reasons why a maintenance audit needs to take place. The Maintenance Audit Reasons page has the same format as the Supplier Statuses page shown in Figure 7-5.

To edit the list of reasons, select the Edit action. The table opens in edit mode. For existing reasons, only the translated descriptions that do not already exist can be edited. To add a maintenance audit reason, click Add. A new row is added to the table. Enter the new reason code and description in the default language. Enter any translations. Select the Save action.

Invoicing Systems

Invoicing systems are used in the Billing Details area of the Supplier and Site records to assign alternative account codes, such as the supplier's account number in the retailer's corporate purchasing system. This option is used to define the available invoicing systems. The Invoicing Systems page has the same format as the Supplier Statuses page shown in Figure 7-5.

To edit the list of invoicing systems, select the Edit action. The table opens in edit mode. For existing invoicing systems, only the translated descriptions that do not already exist can be edited. To add an invoicing system, click Add. A new row is added to the table. Enter the new invoicing system code and description in the default language. Enter any translations. Select the Save action.

Supplier Top Grades

This option is used to define the grades that can be associated with a supplier for an audit/visit, for example, A, B, and C. The Supplier Top Grades page has the same format as the Supplier Statuses page shown in Figure 7-5.

To edit the list of grades, select the Edit action. The table opens in edit mode. For existing grades, only the translated descriptions that do not already exist can be edited. To add a new grade, click Add. A new row is added to the table. Enter the new grade code and description in the default language. Enter any translations. Select the Save action.

Site Top Grades

This option is used to define the grades that can be associated with a site for an audit/visit, for example, A, B, and C. The Site Top Grades page has the same format as the Supplier Statuses page shown in Figure 7-5.

To edit the list of grades, select the Edit action. The table opens in edit mode. For existing grades, only the translated descriptions that do not already exist can be edited. To add a new grade, click Add. A new row is added to the table. Enter the new grade code and description in the default language. Enter any translations. Select the Save action.

Reference Statuses

This option is used to define the reference codes that can be associated with a supplier site, for example, the health mark codes used in the UK or the FDA registration numbers used in the US. The Reference Status page has the same format as the Supplier Statuses page shown in Figure 7-5.

To edit the list of statuses, select the Edit action. The table opens in edit mode. For existing statuses, only the translated descriptions that do not already exist can be edited. To add a new status, click Add. A new row is added to the table. Enter the new code and description in the default language. Enter any translations. Select the Save action.

Reference Types

This option is used to define the reference types, or certificate types, that can be associated with a supplier.

Figure 7-10 Reference Types Page

This figure shows the Reference Types page.

To edit the list of reference types, select the Edit action. The table opens in edit mode. For existing types, only the translated descriptions that do not already exist can be edited. To add a new type, click Add. A new row is added to the table. Enter the new type code and description in the default language. Enter any translations. Select the Save action.

Business Units

This option is used to define the classifications of suppliers and sites.

Figure 7-11 Business Units Page

This figure shows the Business Units page.

To edit the list of business units, select the Edit action. The table opens in edit mode. For existing business units, only the translated descriptions that do not already exist can be edited. To add a new business unit, click Add. A new row is added to the table. Enter the new business code and description in the default language. Enter any translations. Select the Save action.

Currencies

This option is used to define the supported currencies, for example, Sterling and Dollars. The Currencies page has the same format as the Supplier Statuses page shown in Figure 7-5.

To edit the list of currencies, select the Edit action. The table opens in edit mode. For existing currencies, only the translated descriptions that do not already exist can be edited. To add a new currency, click Add. A new row is added to the table. Enter the new currency code and description in the default language. Enter any translations. Select the Save action.

Countries

This option is used to define the list of countries used throughout the system (in addresses, countries of origin, countries of manufacture, and so on).

The maintenance of Countries also incorporates Areas and Regions. Areas are geographical areas that are not countries, but may be referenced in a similar way within the system. For example, the country of origin of a product may be a country or may be an area, such as the Atlantic Ocean.

When the user selects from the pick-list of countries, it either contains a list of just Countries (for example, where completing an address), or Countries and Areas (for example, where selecting a country of origin).

A list of Regions can be maintained against a Country to provide, for example, the states or countries of that country. The list can be used to provide a pick-list of the states/counties for use when entering the address for that country.

Figure 7-12 Countries Page

This figure shows the Countries page.

To edit a country entry, select the entry in the list and then select the Edit action. A tab opens in edit mode. Translated descriptions that do not already exist and additional regions can be added. For an example of the content of this page, see Figure 7-13.

To add a new country:

  1. Select the New Country action. The New Country tab opens.

    Figure 7-13 New Country Page

    This figure shows the New Country page.
  2. In the Details section:

    • Type: Select whether this is a country or area.

    • Code: Enter a code for the country.

    • Country Name: Enter the country name in the default language. This field is mandatory. Enter any translations.

    • Postcode Mask: The Postcode Mark is used to define the format of the postal or zip code for the country. Enter a post code mask to be used for this country.

    • Internet Domain Suffix: Enter the Internet domain suffix used for this country.

  3. In the Regions section, enter any regions for this country or area. To add a region, click Add. A row is added to the table. Enter the code for the region. Enter a description in the default language. The description is a mandatory field. Enter any translations.

  4. Select the Save action.

Other Production Details

This option is used to define the list of production details that can be assigned to a site. The Other Production Details page has the same format as the Supplier Statuses page shown in Figure 7-5.

To edit the list of production details, select the Edit action. The table opens in edit mode. For existing details, only the translated descriptions that do not already exist can be edited. To add a new production detail, click Add. A new row is added to the table. Enter the new detail code and description in the default language. Enter any translations. Select the Save action.

Area

This option is used to define the supported areas. The Areas page has the same format as the Supplier Statuses page shown in Figure 7-5.

To edit the list of areas, select the Edit action. The table opens in edit mode. For existing areas, only the translated descriptions that do not already exist can be edited. To add a new area, click Add. A new row is added to the table. Enter the new area code and description in the default language. Enter any translations. Select the Save action.

Delete Supplier

This option is used to delete suppliers. In order for a supplier to be deleted, the following criteria must be met:

  • The supplier has not gone through the registration process, that is, only a supplier with sites at a status of AWAITING REGISTRATION can be deleted.

  • There is no Alert Response record beyond the status of OUTSTANDING for the supplier being deleted.

  • There are no Scorecards beyond the status of FUTURE for any of the sites of a supplier being deleted.

To delete a supplier:

  1. Select the Delete Supplier option from the Admin drop-down list. The Select Suppliers page appears.

  2. To display the list of suppliers, select the icon. The Suppliers to Delete page appears.

    Figure 7-14 Suppliers to Delete Page

    This figure shows the Suppliers to Delete page.
  3. Select the suppliers to be deleted and click Ok. The selections are shown in the right pane.

  4. To delete the suppliers, select the Submit action. A dialog box appears to enable you to confirm the deletion. To confirm the deletion, click OK. A batch job is submitted to perform the deletion.

    Figure 7-15 Delete Suppliers Confirm Change Dialog Box

    This figure shows the Delete Suppliers page.

Delete Site

This option is used to delete sites. In order for a site to be deleted, the following criteria must be met:

  • The site has not gone through the registration process, that is, only sites at a status of AWAITING REGISTRATION can be deleted.

  • There is no Alert Response record beyond the status of OUTSTANDING for the site being deleted.

  • There are no Scorecards beyond the status of FUTURE for the site being deleted.

To delete a site:

  1. Select the Delete Site option from the Admin drop-down list. The Select Sites page appears.

  2. To display the list of sites, select the icon. The Sites to Delete page appears.

    Figure 7-16 Sites to Delete Page

    This figure shows the Sites to Delete page.
  3. Select the sites to be deleted and click Ok. The selections are shown in the right pane.

  4. To delete the sites, select the Submit action. A dialog box appears to enable you to confirm the deletion. To confirm the deletion, click OK. A batch job is submitted to perform the deletion.

    Figure 7-17 Delete Sites Confirm Change Dialog Box

    This figure shows the Delete Sites Confirm dialog box.

Upload Supplier and Site Data

Retailer users with the Upload Administrator authority profile have access to the Upload Data option within the Admin menu for the upload of suppliers and sites.

To upload new suppliers and sites:

  1. Select the Import action from the Suppliers List View actions menu. The Data Upload dialog box opens.

    Figure 7-18 Data Upload Dialog Box

    This figure shows the Data Upload dialog box.
  2. Click Browse to search for the upload file.

  3. Enter any comments to describe the reason for the upload.

  4. Select whether the system is to automatically send email to the primary contact user of each newly created supplier/site on successful completion of the upload. The email will invite the user to register on the portal. The default is No, which will not send an email.

  5. To upload the file, select either the Submit or Submit Go to Manage Batch Jobs action. At this point, the system will create a background job to process the spreadsheet. The spreadsheet used to upload the data will be stored within the Attachments tab of the batch job.

Note:

An email will be sent to the job submitter if the date within the upload file fails validation.

Download Supplier and Site Upload Spreadsheet

Retailer users with the Upload Administrator authority profile also have access to the option to download a blank spreadsheet.

To download the latest version of the upload spreadsheet:

  1. Select the Download Blank Spreadsheet action from the Suppliers List View actions menu. An operating system specific dialog box opens with the option to either open or save the file.

  2. Select the save option to download the ZIP file to your desktop.

Note:

The ZIP file contains a spreadsheet workbook with the first tab used to upload the data. The second tab contains guidance notes and the remaining tabs contain the valid glossary values.

The column heading text shown on the first tab is in the user's language. If translations are not present for the user's language, the system the portal's default language is substituted. An asterisk (*) is shown in a column heading if an entry is mandatory.

Scorecards

Select the Scorecards option from the Admin drop-down list. The following options are available in the left pane:

Scorecard Questions

Each scorecard template is comprised of a series of questions which may be selected from this glossary.

Figure 7-19 Glossary Scorecard Question Page

This figure shows the Glossary Scorecard Question page.

To edit a question, select the question and then select the Edit action. A tab opens with the record in edit mode.

To create a new scorecard question:

  1. Select the New Question action. The Scorecard Question tab opens.

    Figure 7-20 New Scorecard Question Page

    This figure shows the New Scorecard Question page.
  2. In the Details section:

    • Question Id: Enter the ID for this question. The ID must be between 3 and 10 characters and unique. The value cannot be changed once the question has been created. This field is mandatory.

    • Status: The status is set to Deactivated.

    • Question: Enter the question in the default language. This field is mandatory.

    • Sequence: Enter the sequence number for this question. The sequence number is used to set the default order of questions within the scorecard template.

    • Question Type: Select the type of question:

      • Universal questions are automatically added to a scorecard template. These questions may be removed and individually re-added as required (if configured in System Parameters to allow removal).

      • General questions are manually added to a scorecard template from the questions glossary.

    • Comments: Enter any comments. This field is not mandatory.

  3. In the Answers section:

    • Answer Type: Select the type of answers allowed for this question.

    • Includes Comments: If set to Yes, a text field is included in the questionnaire to enable the user to enter any comments.

    • To add an answer choice, click Add. Enter the answer in the default language. This is a mandatory field. Enter any translations.

  4. Select the Save action.

Scorecard Templates

Scorecards provide a means for the retailer to assess their suppliers on an on-going (or ad hoc) basis against a set of predefined criteria. Scorecards are made up of a series of questions which may be answered by the suppler as a self-assessment or completed by the retailer.

Any number of types of scorecard can be configured, with the option to use weighted scoring for the overall grading of suppliers' responses. On completion of a scorecard, the next one can be automatically scheduled based on a predefined periodic or quarterly frequency.

Scorecard templates define the rules that control the behavior of the different types of scorecards. Every scorecard is created from a template which defines the rules for how it behaves within the system, that is, the set of questions and permitted answers, the setting of basic default values, and whether certain fields are used or hidden.

Figure 7-21 Glossary Scorecard Templates Page

This figure shows the Glossary Scorecard Templates page.

To edit a template, select the entry and then select the Edit action. A tab opens in edit mode to enable you to edit the template. For an example of the content, see Figure 7-22.

To create a new template:

  1. Select the New Scorecard Template action. The New Scorecard Template tab opens.

    Figure 7-22 New Scorecard Template Page

    This figure shows the New Scorecard Template page.

    Table 7-1 describes the fields in the Details section.

    Table 7-1 New Scorecard Template Fields

    Field Description

    Code

    Enter a unique code for this template. This field is mandatory.

    Scorecard Name

    Enter the name for the template in the default language. This field is mandatory. Enter the translations.

    Status

    The status is set to Deactivated.

    Supplier Can Create Scorecard

    If checked, the supplier user can choose to create this type of scorecard. The default is unchecked.

    Supplier Can Change Due Date

    If the supplier can create this type of scorecard and this field is checked, the supplier user may also change the due date of this type of scorecard. The default is unchecked.

    Supplier Can Complete Scorecard

    If checked, the supplier user may choose to complete this type of scorecard. The default is unchecked.

    Approval Required

    If the supplier can complete this type of scorecard and if this field is checked, the retailer user is required to approve this scorecard before the supplier can complete it. The default is unchecked.

    Grace Period

    Enter the number of days or weeks after the scorecard's due date when it becomes overdue.

    Overdue Email

    If checked, an email is automatically generated to the supplier if the supplier has not completed the scorecard by the time it becomes overdue.

    Contact Roles

    Select the roles for which supplier users receive the notifications if the scorecard becomes overdue. The field is mandatory.

    Future Date Derived From

    These fields are used to control the rules for automatically scheduling subsequent scorecards of this type, and when a scorecard becomes overdue.

    Automate Future versus Auto Schedule

    If a scorecard’s template is set to Automate Future the system will automatically create the next future scorecard of this type for active sites that have previously had this type of scorecard and do not already have one currently scheduled, or do have one scheduled but its due date has been reached. This ensures all sites that have this type of scorecard always have one scheduled.

    If a scorecard’s template is set to Auto Schedule, the system prompts the user with the option to auto-schedule the next future scorecard of this type for the site when the existing scorecard is completed.

    Automate Future

    Auto Schedule

    Default Frequency

    Due Day Of Week

    Level of Business Category

    Enter the number of levels of business category to be recorded for this type of scorecard. Set to zero if none are required. This is a mandatory field.

    Business Category Required

    If checked, the business category becomes mandatory when the scorecard is completed.

    Comments

    Enter a comment regarding this template.

  2. Set the questions for this type of scorecard in the Questions tab using the tables of questions for Universal, General, and Ad Hoc Questions:

    • Universal questions are automatically added.

    • General Questions are selected from the glossary of Scorecard Questions.

    • Ad Hoc questions can be entered specifically for this type of scorecard.

    Once the questions have been added, the Refresh Preview action can be used to show the scorecard as it will be presented to the supplier.

  3. Select any scoring rules for this type of scorecard in the Scoring subtab.

  4. Select the Save action.

Scorecard Status

This option enables you to view the scorecard status codes and descriptions defined for each. To edit the list, select the Edit action. You can change the descriptions and add new status codes. The Scorecard Status page has the same format as the Alert Status page shown in Figure 7-1.

Audits & Visits

Select the Audit & Visits option from the Admin drop-down list. The following options are available in the left pane:

Certification Bodies

Certification bodies are assigned to audits/visits that are carried out by a third-party organization. A certification body defines the details of an organization that carries out an audits. On the Certification Bodies page, the name and contact details of existing auditors and certification bodies are shown.

To edit the details for a certification body, select the entry and then select the Edit action. A page opens in edit mode with the details of the certification body. For an example of the content, see Figure 7-23.

To add a new certification body, select the New Certification Body action. The New Certification Body tab opens. The Name and Type fields are mandatory. The contact details and address may also be entered.

Figure 7-23 New Certification Body Page

This figure shows the New Certification Body page.

Audit/Visit Templates

Audit/visit templates define the rules that control the behavior of the different types of audits and visits. Every audit or visit is created from a template which defines the rules for how it behaves within the system, that is, the setting of basic default values and whether certain fields are used or hidden.

Figure 7-24 Audit/Visit Templates Page

This figure shows the Audit/Visit Templates page.

To edit a template, select the entry and then select the Edit action. A tab opens in edit mode to enable you to edit the template. For an example of the content, see Figure 7-25.

To create a new template:

  1. Select the New Audit/Visit Template action. The New Audit/Visit Template tab opens.

    Figure 7-25 New Audit Template Page

    This figure shows the New Audit Template page.
  2. Table 7-2 describes the fields in the Audit/Visit Details section.

    Table 7-2 Audit/Visit Template Fields

    Field Description

    Active

    Check the box if this template is set active when created.

    Allowable Audit/Visit Standards

    Click the icon to select the standards for this audit/visit.

    Allowable Score Options

    If scoring is used, click the icon to select the scoring options to use.

    Audit/Visit Standards Used

    If set to Yes, this type of audit is aligned with a particular standard.

    Audit/Visit Template Name

    Enter the name for the template in the default language. This field is mandatory. Enter the translations.

    Audit/Visit Type

    • Select Internal if the audit/visit is carried out by the retailer.

    • Select Third Party if a third-party auditor or certification body carries out the audit/visit.

    Audit/Visit Visibility

    This field determines whether the supplier knows in advance of an audit/visit. If Unannounced, the supplier is not notified until it is time for them to collaborate.

    Auto Schedule

    If set to Yes, a new future audit/visit is automatically scheduled on completion of the current audit/visit.

    Business Category Levels Required

    If the Business Categories Required field is set to Yes, enter the number of levels of business category to use on the audit/visit record.

    Business Categories Required

    If set to Yes, a business category is required for this type of audit/visit.

    Code

    Enter a unique code for this template. This field is mandatory.

    Comments

    Enter a comment regarding this template.

    Cost Recovery

    If set to Yes, the all or part of the cost of the audit/visit is recharged to the supplier.

    Cost Recovery Comments

    If the Cost Recovery field is set to Yes, the amount to be recharged can be entered as a comment.

    Create Issues

    If set to Yes, issues can be raised against audits/visits of this type regardless of whether the issue is created by the supplier or retailer.

    Default Audit/Visit Frequency (months)

    Enter the frequency of the audit/visit in months. This is used when auto-scheduling the next audit/visit.

    Default Issue Completion (days)

    Enter the number of days an outstanding issue must be completed by before being flagged as urgent.

    Record Date of Last Audit/Visit

    If set to Yes, the site record is updated with the date when the latest audit is completed.

    Record Type

    Select whether this template is for an audit or a visit.

    Scope

    This is the summary of the purpose of the audit/visit. This is the default text for the Scope field in the audit/visit.

    Score Audit/Visit

    If set to Yes, an overall score/grade is required.

    Score Mandatory

    If set to Yes, scoring is mandatory when scoring is being used.

    Supplier Generated

    If set to Yes, the supplier can create new audits/visits of this type.

  3. In the Auditors subtab, select the certification bodies and internal auditors who are allowed to perform the audit:

    • If All is selected, all defined certification bodies or internal auditors are allowed to perform the audit.

    • If Only Allowable is selected, the list of certification bodies or internal auditors is chosen. Click the icon and select the certification bodies or internal auditors.

    Figure 7-26 New Audit Template Auditors Subtab

    This figure shows the New Audit Template Auditors subtab.
  4. Select the Checklists subtab. Add any checklists to be used for the audit. When an audit/visit is created, if its template has checklists assigned, the checklists are automatically created as Audit/Visit Checklist records for completion during the audit/visit.

  5. In the Attachments subtab, attach any documents to the audit.

  6. Select the Save action.

Audit/Visit Issue Types

Audit/visit issue types define the types or levels of non-conformance that can be raised against an audit. An audit/visit template may not be edited once it has been made active; to make any changes it must first be deactivated. The Audit/Visit Issue Types page has the following columns:

  • Set to Yes if the issue type is active.

  • Code for the issue type.

  • Description for the issue type in the default language.

  • Descriptions for each supported language.

Figure 7-27 Audit/Visit Issue Types Page

This figure shows the Audit/Visit Issue Types page.

To edit the list of issue types, select the Edit action. The table opens in edit mode. Only the translated descriptions can be edited.

To add a new issue type, click Add. If the issue type should be set active, check the box in the Active column. The code and description in the default language are mandatory fields.

Auditor Types

Audit types are used to differentiate between individuals (Auditors) and organizations (Certification Bodies). The Auditor Types page has the same format as the Audit/Visit Issue Types page shown in Figure 7-27.

To edit the list of auditor types, select the Edit action. The table opens in edit mode. Only the translated descriptions can be edited.

To add a new auditor type, click Add. If the auditor type should be set active, check the box in the Active column. The code and description in the default language are mandatory fields.

Audit/Visit Risk Levels

Where used, the levels of risk may be assigned to a site based on the type of product the site produces, for example, High Risk and Low Risk. The levels can be used, based on risk level, to vary the frequency of an audit/visit type per site. The Audit/Visit Risk Levels page has the same format as the Audit/Visit Issue Types page shown in Figure 7-27.

To edit the list of risk levels, select the Edit action. The table opens in edit mode. Only the translated descriptions can be edited.

To add a new risk level, click Add. If the risk level type should be set active, check the box in the Active column. The code and description in the default language are mandatory fields.

Audit/Visit Scores

Audit/visit scores provide the scoring or grading options for audits, for example, Red and Green. The Audit/Visit Scores page has the same format as the Audit/Visit Issue Types page shown in Figure 7-27.

To edit the list of scores, select the Edit action. The table opens in edit mode. Only the translated descriptions can be edited.

To add a new score, click Add. If the score should be set active, check the box in the Active column. The code and description in the default language are mandatory fields.

Audit/Visit Standards

Each type of audit can be aligned with a specific standard. The Audit/Visit Standards page has the same format as the Audit/Visit Issue Types page shown in Figure 7-27.

To edit the list of standards, select the Edit action. The table opens in edit mode. Only the translated descriptions can be edited.

To add a new standard, click Add. If the standard should be set active, check the box in the Active column. The code and description in the default language are mandatory fields.

Audit/Visit Statuses

Statuses define the names of the stages of the Audit/Visit workflow.

To edit the list of statuses, select the Edit action. The table opens in edit mode. Only the translated descriptions can be edited.

Figure 7-28 Audit/Visit Statuses Page

This figure shows the Audit/Visit Statuses page.

Issue Statuses

Issue statuses define the names of the stages of the Issues (non-conformances) workflow. The Issue Statuses page has the same format as the Audit/Visit Statuses page shown in Figure 7-28.

To edit the list of statuses, select the Edit action. The table opens in edit mode. Only the translated descriptions can be edited.

Visit Locations

Only used in visits, the locations are a predefined list of options for specifying where the visit takes place, for example, Head Office or Conference Room. The Visit Locations page has the same format as the Audit/Visit Issue Types page shown in Figure 7-27.

To edit the list of locations, select the Edit action. The table opens in edit mode. Only the translated descriptions can be edited.

To add a new location, click Add. If the location should be set active, check the box in the Active column. The code and description in the default language are mandatory fields.

Visit Reasons

Only used in visits, the reasons are a predefined list of options for why the visit takes place, for example, Audit Follow-up or Complaint Investigation. The Visit Reasons page has the same format as the Audit/Visit Issue Types page shown in Figure 7-27.

To edit the list of reasons, select the Edit action. The table opens in edit mode. Only the translated descriptions can be edited.

To add a new reason, click Add. If the reason should be set active, check the box in the Active column. The code and description in the default language are mandatory fields.

Checklist Templates

A checklist is the breakdown of items to be assessed as part of an audit or visit. The items may correspond to individual clauses in corporate standards or policy documents. A checklist template is the grouping together of checklist questions and their permissible answers to form reusable common questionnaires for completion during an audit.

Figure 7-29 Checklist Templates Page

This figure shows the Checklist Templates page.

To edit a template, select the Edit action. The template record opens in edit mode.

To add a new checklist:

  1. Select the New Checklist Template action. The New Checklist Template tab opens.

    Figure 7-30 New Checklist Template Page

    This figure shows the New Checklist Template page.
  2. In the Details section:

    • Code: A unique Code must be entered when the template is created, after which it is read-only. This field is mandatory.

    • Checklist Name: Enter the name that appear in the audit/visits. The name must be unique. The name is editable after the record has been created. Enter any translations. This field is mandatory.

    • Status: The status is set to Deactivated.

    • General Comments: If set to Yes, a general comments field is included in the checklist.

  3. In the Questions section: To add questions, click Add. The Select Glossary Questions dialog box appears with the list of available questions. Select questions and then click Ok.

  4. In the Block Answer Options section: Allow block answers adds an option to the checklist to allow the user to block answer all the questions with the answers specified here, where it is one of the permissible answers for the question. For example, if block answering is set to Not Assessed, all questions in the checklist that have Not Assessed as one of the answer options are answered in that way. The contents of the Allow Block Answer pick-list are dynamically built based on the set of answers associated to the questions present in this checklist. Any duplicates are excluded.

  5. Select the Save action.

Checklist Answers

The sets of available checklist answers are managed using this option.

Figure 7-31 Checklist Answers

This figure shows the Checklist Answers.

Figure 7-32 shows an example of checklist answers.

Figure 7-32 Checklist Answers Example

This figure shows an example of Checklist Answers.

To edit a set of checklist answers, select the entry and then select the Edit action. The template record opens in edit mode.

To add a new set of checklist answers:

  1. Select the New Checklist Answer option. The New Glossary/Answers page opens.

    Figure 7-33 New Checklist Answer Page

    This figure shows the New Checklist Answer page.
  2. In the Details section:

    • Code: Enter a unique code for this answer set. This field is mandatory.

    • Answer Name: Enter a unique identifier of this answer set in the default language. This field is mandatory. Enter any translations.

    • Answer Type: Select the type of answer presented to the user:

      • Single Choice presents a pick-list.

      • Multi Choice presents a multi-select pick-list.

      • Text presents an auto-expanding text area.

    • Include Comments: This field determines a comment is required. If the selected answer type is Text, this field is set to No and cannot be changed.

    • Comments: Use this field to enter a comment regarding this checklist answer glossary.

    • Use Default Answer: If the answer type is Single Choice or Multi Choice, the Use Default Answer option is used to control whether a default value is to be set for this answer when presented in a checklist. If Yes is selected, the Default Answers field presents a checklist of the answers that have been added to the Answers table for one to be selected. If No is selected the selector is hidden.

  3. The table of answers defines the answer choices and is only presented if the answer type is Single Choice or Multi Choice. To add answer, click Add to add a row to the table:

    • Enter the answer in the default language. This field is mandatory.

    • The N/C Creation field determines whether, when the chosen answer is given to this question, the system should generate an issue for the question.

    • The N/C Type field determines for what issue type an issue is automatically generated. The selection is made from the Issue Types glossary, for example, Critical, Major, Minor, or Recommendation.

    • Enter the descriptions in the supported languages.

  4. Select the Save action.

Checklist Questions

The sets of available checklist questions are managed using this option.

Figure 7-34 Checklist Questions

This figure shows Checklist questions.

To edit a checklist question, select the entry and then select the Edit action. The question record opens in edit mode.

To add a checklist question:

  1. Select the New Checklist Question action. The New Glossary/Question tab opens.

    Figure 7-35 New Checklist Question Page

    This figure shows the New Checklist Question page.
  2. In the Details section:

    • Id: This is a unique identifier of each question. It is automatically assigned as an incrementing sequence number.

    • Audit Type: Select the type of audit associated with this question from the drop-down list. This field is mandatory.

    • Answer Type: Select the type of answer associated with this question from the drop-down list. This field is mandatory.

    • Section: Select the section of the questionnaire from the drop-down list. This field is mandatory.

    • Question/Text Statement: Enter the question in the default language. This field is mandatory. Enter any translations.

    • Comments: Use this field to enter a comment regarding this checklist question glossary entry.

  3. In the Answers section: The table of Answers is automatically built based on the selected answer type. The table is only applicable for Single Choice and Multi Choice answer types. For more information, see Checklist Answers

  4. Select the Save action.

Checklist Question Colour Management

This option is used to define the rules for color-coding within checklists. The system uses this table to apply to present the text in the specific color if it encountered as part of a checklist question.

To edit the list of colors, select the Edit action. The table opens in edit mode. The color and descriptions can be edited.

To add a new color, click Add. A row is added to the table. Enter the code, color, and description in the default language. Enter any translations.

Figure 7-36 Checklist Question Colour Management

This figure shows the Checklist Question Colour Management.

Checklist Question Colours

This option is used to build the list of colors available for use when defining the color-coding rules.

To edit the list of colors, select the Edit action. The table opens in edit mode. To add a new color, click Add.

Figure 7-37 Checklist Question Colours

This figure shows the Checklist Question Colours page.

Roles and Permissions

Select the Contact Roles option in the left pane. The Contact Roles page opens.

Figure 7-38 Contact Roles Page

This figure shows the Contact Roles page.

The set of contact roles is configurable. Each portal can build their own set of roles that contacts are to be recorded for at the supplier and site levels. The roles may be set as mandatory, in which case, a contact must be assigned to that role for the supplier/site account to be approved.

Some roles are mandatory because they are used by the system to automatically notify the relevant users as part of the system's workflow, for example, an Audits &Visits Main Contact would be notified when an audit requires action.

Where there are mandatory roles that have not been assigned a contact, the supplier/site administrator is alerted through the Urgent Item Manager (UIM) app.

For more information on adding and editing contact roles, see Managing Contact Roles.

System Parameters

To maintain the parameters used to support Supplier, select the System Control option and then System Parameters.

Table 7-3 shows the specific system parameters, by subtab on the System Parameters page, used to support Supplier.

Table 7-3 System Parameters to Support Supplier

Subtab Parameter Description

Audits & Visits

Allow creation of Audits from Audits List

If set to Yes, users may create new audits/visits from within the Audits & Visits area (in which case, they select the supplier and site) as well as through the Site record.

If set to No, new audits/visits are created through the Site record (in which case there is no need to select the supplier and site).

Default is No.

Audits & Visits

Max Time Spent (hours)

Sets the maximum value a user may record as the time spent on an audit/visit. This prevents excessive time being accidentally entered. Default is 20.

Audits & Visits

Use Risk Levels

Determines whether levels of risk are being assigned to Sites (based on the type of product produced).

If set to Yes, a Risk Level classification can be set on the Site record, and the frequency of an audit/visit may be set differently per risk level; thus allowing an audit/visit to be scheduled more (or less) frequently for sites that supply particular types of products.

Default is No.

Audits & Visits

Days to show Scheduled in Tasks App

Used to control when Scheduled audits/visits appear in the user's Task App in order to limit the list of audit/visits to just those that will become due in the next 28 days, for example, thereby excluding those that are currently scheduled but not due for a number of months. Default is 28. This is also used to control the due email notifications to retailer and supplier users.

Audits & Visits

Edit Score on Completion

If set to Yes, where an audit/visit is scored, the score can be assigned or changed when the audit/visit is completed (through the completion confirmation dialog box).

If set to No, any scoring has to be assigned directly within the Audit/Visit record.

Default is No.

Audits & Visits

Send Audit/Visit Due Notifications to Supplier

If checked, this will indicate that the Audit & Visit due email notifications should be sent to Supplier users. Unannounced audits/visits will not be notified.

Default is No (unchecked).

Audits & Visits

Send Audit/Visit Due Notifications to Retailer

If checked, this will indicate that the Audit & Visit due email notifications should be sent to Retailer users.

Default is No (unchecked).

Audits & Visits

Send Audit/Visit Overdue Notifications to Supplier

If checked, this will indicate that the Audit & Visit overdue email notifications should be sent to Supplier users. Unannounced audits/visits will not be notified.

Default is No (unchecked).

Audits & Visits

Send Audit/Visit Overdue Notifications to Retailer

If checked, this will indicate that the Audit & Visit overdue email notifications should be sent to Retailer users.

Default is No (unchecked).

Log On

Site Details Update Reminder

Number of working days between a reminder being shown in a user's UIM when a user has logged in. It is used to ensure that Mandatory Contact details are kept up to date on both the supplier and sites. Default is 90 days.

When the first supplier user logs in, they see an entry in the UIM drawing their attention to this. If they use the Confirm Details action, this stamps the date onto the record so that the next time a user logs in, the system checks if the current date is greater than the stamped date.

Registration

Notify Lead Technologist

If set to Yes, the Product Technologist is notified by email when a supplier completes the registration for a site for which they are the Lead Technologist. Default is No.

Registration

Notify Others

User roles, with Role Type equal to Retailer, for which users should be copied on the email sent to a Technologist when a supplier completes registration. For example, it is used to notify Auditors when sites are ready to be audited. Parameter is linked to the user roles.

Registration

Create Initial Audit

If set to Yes, additional fields are made available to allow the user to create the initial audit when a site is approved. Default is No.

Registration

Notify Accounts

If set to Yes, the Account Administrator is automatically notified by email (REG3) that an order has been created when the supplier has completed their part of the registration process (for a standard supplier registration). Default is Yes.

Registration

Create initial scorecard

If set to Yes, additional fields are made available to allow the user to create the initial scorecard when a site is approved. Default is No.

Registration

Registration Ts & Cs Active

If set to Yes, suppliers are required to accept the portal's terms and conditions during the supplier registration process. Default is Yes.

This parameter can only be seen and maintained by users with the Oracle Authorized Administrator authority profile.

Registration

Supplier Code Allocation

If Auto, the system will automatically assign supplier codes to new Suppliers.

If Auto/Edit, the system will automatically assign supplier codes, however the auto-allocated code may be manually changed to a unique alternative during the creation process.

If Manual, the retailer user must assign a unique supplier code during the creation process.

Default is Auto.

Note: This parameter can only be seen and maintained by a user with the Oracle Authorized Administrator authority profile.

Registration

Supplier Code Editable

If checked, the supplier code may be edited in the Supplier record after the account has been created.

If Supplier Code Allocation is set to Auto, this parameter is set as unchecked and cannot be changed. Default is unchecked.

Note: This parameter can only be seen and maintained by a user with the Oracle Authorized Administrator authority profile.

Registration

Supplier GLN Mandatory

Use this to control whether the GLN code is mandatory or optional in the Supplier record.

Default is unchecked/No (not mandatory).

Registration

Supplier GLN Regular Expression Validation

Validation rule for Supplier GLN code format.

By default, none is applied (no validation).

The typical value for the standard GLN 13-digit code would be:

(^([0-9]{8})$)|(^([0-9]{13})$)

Registration

Validate Supplier GLN Check Digit

A checkbox to control whether check digit validation is applied to the Supplier GLN code in the Supplier record.

Defaults to unchecked (no validation).

Registration

Site Code Allocation

If Auto, the system will automatically assign site codes to new Supplier sites.

If Auto/Edit, the system will automatically assign site codes, however the auto-allocated code may be manually changed to a unique alternative during the creation process.

If Manual, the retailer user must assign a unique site code during the creation process.

Default is Auto.

Note: This parameter can only be seen and maintained by a user with the Oracle Authorized Administrator authority profile.

Registration

Site Code Editable

If checked, the site code may be edited in the Site record after the account has been created.

If Site Code Allocation is set to Auto, this parameter is set as unchecked and cannot be changed.

Default is unchecked.

Note: This parameter can only be seen and maintained by a user with the Oracle Authorized Administrator authority profile.

Registration

Site Code Format

If Numeric, the site coding will follow an incrementing number sequence, starting at 1 for each supplier (with leading zeroes), such as, 0001 > 0002 … 9999 > 10000 …

If Alpha, the site coding will follow an incrementing alpha code sequence, starting at AAAA for each supplier, such as, AAAA > AAAB … AAAZ > AABA … AZZZ > BAAA …

This parameter cannot be changed once the first site has been created. Default is Numeric.

Note: This parameter can only be seen and maintained by a user with the Oracle Authorized Administrator authority profile.

Registration

Prefix Site Code with Supplier Code

If checked, the supplier code is automatically prepended to the site code when creating a Site account, with a hyphen, such as A0001-AABD.

This parameter cannot be changed once the first site has been created. Default is checked.

Note: This parameter can only be seen and maintained by a user with the Oracle Authorized Administrator authority profile.

Registration

Site Code Unique Across Portal

If checked, the system will continue incrementing the site code across the entire portal rather than just within the supplier, to ensure the uniqueness across the portal. For example:

If site codes are not required to be unique across the portal, the coding may be:
Supplier Site
A0001 0001 or AAAA
A0001 0002 or AAAB
B0001 0001 or AAAA

If site codes are required to be unique across the portal, the coding would be:
Supplier Site
A0001 0001 or AAAA
A0001 0002 or AAAB
B0001 0003 or AAAC

This parameter cannot be changed once the first site has been created. Default is unchecked.

Note: This parameter can only be seen and maintained by a user with the Oracle Authorized Administrator authority profile.

Registration

Minimum Site Code Length

The minimum number of digits or characters in the site code.

This parameter cannot be changed once the first site has been created. Default is 5.

Note: This parameter can only be seen and maintained by a user with the Oracle Authorized Administrator authority profile.

Registration

Site GLN Mandatory

Use this to control whether the GLN code is mandatory or optional in the Site record.

Default is unchecked/No (not mandatory).

Registration

Site GLN Regular Expression Validation

Validation rule for Site GLN code format.

By default none is applied (no validation).

The typical value for the standard GLN 13 digit code would be:

(^([0-9]{8})$)|(^([0-9]{13})$)

Registration

Validate Site GLN Check Digit

A checkbox to control whether check digit validation is applied to the Site GLN code in the Site record.

Defaults to unchecked (no validation).

Registration

Registered Company Number Mandatory at Registration

Use this to control whether the Registered Company Number is mandatory or optional when the supplier completes the Registration wizard.

Default is checked/Yes (mandatory).

Scorecards

Allow creation of Scorecards from Scorecards list

If checked, scorecards can be created from the scorecards list views. If not checked, scorecards can only be created directly from within a Site record.

Scorecards

Grace period

Select if the scorecard completion overdue grace period is in days or weeks.

Scorecards

Email Agent run on

Controls which days of the week reminder emails are generated for overdue scorecards. Specific days can be selected. Buttons are available to select or clear all days.

Scorecards

Allow ad hoc (non glossary) questions

If checked, scorecard templates have the option to have questions added that do not appear in the questions glossary.

Scorecards

Allow removal of universal questions

If checked, whether universal questions may be removed from a scorecard template (if not, all universal questions will appear on every scorecard type).

Urgent Items

Show Alert Items

If set to Yes, Alert KPIs are shown in the UIM. Default is Yes.

Urgent Items

No. Days Before Alert Response is overdue

Number of days before this KPI is shown. Default is two days.

Urgent Items

Show scorecards

If set to Yes, scorecards are shown in the UIM. Default is Yes.

Urgent Items

Scorecard Overdue Off-set days

Number of days before an overdue scorecard is shown. Default is two days.

Urgent Items

No. Days Before Audits & Visits Overdue

Used to control if and when the overdue audits/visits message appears in the user's UIM. When blank, no overdue notifications appear. Also used to control overdue email notifications to retailer and supplier users.

Urgent Items

No. Days Before Audits & Visits Issues Overdue

Used to control if and when the overdue audits/visits issues message appears in the user's UIM. When blank, no overdue notifications appear. Also used to control overdue email notifications to retailer and supplier users.