Regenerate Import Map Templates

Use the Regenerate Import Map Templates scheduled process to generate smart spreadsheet templates for existing import maps in Oracle Product Hub.

The scheduled process will pick the import maps based on the criteria that was specified when scheduling the process and generates respective templates.

When to Use

When the value sets linked to any existing extensible flexfields are modified and these changes must be incorporated to the list of values shown up for these extensible flexfields on the smart spreadsheet templates, use the Regenerate Import Map Templates scheduled process instead of updating each template separately.

The scheduled process can be initiated using the Scheduled Processes task.

From Scheduled Processes work area, click Schedule New Process, select Regenerate Import Map Templates, specify the Item Class, Import Maps (All or With Templates), and Languages under Basic Options, and then click Submit.

This process will regenerate the smart spreadsheet templates and attach them to the corresponding import maps.

Privileges Required

  • Manage Item Privilege (EGP_MANAGE_ITEM_PRIV)
  • Manage Item Batch Privilege (EGI_MANAGE_ITEM_BATCH_PRIV)
  • Import Item Privilege (EGP_IMPORT_ITEM_PRIV)

Specifications

Review the following before setting up this scheduled process:

Specification Description
Job Type

Ad hoc job or scheduled.

Typically, when changes are made to the value sets for some extensible flexfields and you want to update the import map templates, you can run the process as an ad hoc job. But, if there are any anticipated changes to the value sets, and you want to make sure the existing import map templates are up-to-date, you can also schedule for a set time.
Frequency Whenever there is a change to some extensible value sets, import map templates must be updated.
Time of Day If there is a considerable number of import map templates that must be regenerated, it's recommended to run the process after work hours.
Duration Variable based on the number of import map templates as per the scheduling options.
Compatibility There’s no current functional need to run multiple instances of this process simultaneously.

Parameters

Parameter Optional or Required Description Parameter Values Special Combinations Required Notes
Item Class Optional Only import maps belonging to the selected item class must be updated. Name of the item class None N/A
Import Maps Required Choose whether the templates must be updated for all import maps or only the ones that already have templates generated.

All

With templates

None N/A
Languages Optional Choose whether the templates must be generated in all languages or a specific language.

All

Applicable Languages based on the language pack installed

None N/A

Troubleshooting Information

  • You can view the status of the regenerate import map templates process in the Scheduled Processes work area.
  • The validation errors and warning messages, if any, are displayed in the error log.
  • Any interactive warning validations aren’t performed.
  • When the program is submitted, you can resubmit, put on hold, cancel the process, or release the process as provided by the Scheduled Processes work area.

Related Topics

Importing Item Data Using Import Maps