Upgrade Product Management Data
Use the Upgrade Product Management Data scheduled process to update Oracle Fusion Cloud Product Lifecycle Management functional areas to include selected features.
For each functional area there are one or more features that you can include in the upgrade. You must select each feature separately and run the Analysis or Execution process for each as required. The Analysis process posts the results of the analysis in the request log and output files for scheduled process.
When to Use
| Functional Area | Feature | When to Use |
|---|---|---|
| Import Maps | Delete Automatically Generated Import Maps | Run this process to fix any issues with specific smart spreadsheets used for item mass updates. |
| Trading Partner Items | Ensure uniqueness in trading partner item numbers | Run this process to identify and fix any duplicate trading partner item numbers that were created previously. |
| Manufacturers |
Upgrade Manufacturer Management Update all presence indicators |
You must run this process after opting in for the feature Upgrade Manufacturer Management to mass upgrade existing manufacturer objects. This upgrades product features and data by launching subprocesses for each type of update. Run this process to update data presence indicators for manufacturer objects. |
| Item Import | Update Request ID and Load Request to 0 | Run this process to set the values for REQUEST_ID and LOAD_REQUEST_ID to 0, for items imported through non file-based-import (FBDI) processes. Once these IDs are populated, you can purge the data using the Purge Tables scheduled process. |
| Item Child Entity Presence Indicators | List of data presence indicators for item child entities |
Run these processes to add data presence indicators in the item and item structure search results tables. Note: Start each process only after the
previous one completes.
|
|
Item Attribute |
Delete Orphan Extensible Flexfield Rows Item Object Types |
Run this process to delete orphan rows created in EGO_ITEM_EFF tables due to the removal of attribute groups. Run this process to enable the new operational attribute 'Item Object Type' for items and documents. This will populate the item object type column with appropriate values. This attribute can then be exposed as a filter chip in the search results. |
| Item Relationships | Update start dates on AML and display redlines | Run this process to update the start dates on existing AMLs and ensure that AML redlines are displayed correctly on change orders. |
| Proposals |
Update presence indicators Update presence indicators for attachments Update presence indicators for relationships |
Run these processes to update data presence indicators for attachments and relationships in the proposal search results tables. |
| Changes |
Upgrade Change History Upgrade data presence indicators for tasks Update data presence indicators for attachments Update data presence indicators for relationships |
Run this process to migrate the history for existing changes to an enhanced format when you opt in to the feature Track Affected Object Redlines and Other Updates on Changes. Run these processes to update data presence indicators - for tasks, attachments, and relationships. |
Privileges Required
- Manage Product Management Data Upgrade (EGO_MANAGE_PRODUCT_MANAGEMENT_DATA_UPGRADE_PRIV)
Parameters
| Feature | Commit Size | Parameters |
|---|---|---|
| Definition Application Role Uptake | 10 | None |
| Delete Automatically Generated Import Maps | NA | Parameter 1 – Enter the name of the import map that must be deleted. Or enter All to delete all automatically generated import maps. |
| Upgrade Manufacturer Management | NA | None |
| Update request ID and load request to 0 | NA | None |
| Update start dates on AML and display redlines | 10 | None |
| Upgrade Change History | 500 |
Parameter 1 – History records will be migrated using the base language defined for your system. To migrate the data in a different language, specify the language. |
| Update all data presence indicators | NA | None |
| List of data presence indicators for item child entities | NA | None |
Specifications
Review the following before setting up this scheduled process:
| Specifications | Descriptions |
|---|---|
| Job Type | Ad hoc job |
| Frequency | As required |
| Time of the Day | As and when required |
| Duration | Based on data volume |
| Compatibility | There’s no current functional need to run multiple instances of this process simultaneously. |
Troubleshooting Information
- You can view the status of the job in the Scheduled Processes work area.
- If the upgrade results in an error, you must fix the issues and rerun the Enterprise Scheduler Service process. The upgrade will only try to upgrade objects that haven't yet been upgraded.
- For opt-in features, you must ensure that you’ve opted in for the feature before running the upgrade process.