My Oracle Support Banner

Cannot Update Work Definition on Planned Order Using Edit in Spreadsheet (Doc ID 2676414.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Fusion Planning Central Cloud Service - Version and later
Information in this document applies to any platform.


Cannot Update Work Definition on Planned Order Via Spreadsheet .

The business case is to update the Work Definitions for many planned orders at once.
After opening the plan in Supplies and Demands, Edit in Spreadsheet is chosen in the Actions drop down.
Once the data is exported to the spreadsheet, changes are made to the Work Definition for the planned orders.
After clicking the 'Upload' button the following error is received:

NOTE: Users are able to make this change manually in the UI.

The value entered for attribute Item Structure Name Work Definition is invalid

1. Query the planned orders in Supplies and Demands table.
2. Export the Planned orders using Actions -> Edit In Spreadsheet.
3. Edit the records in the spreadsheet by changing the Work Definition to the "Default" Work Definition name.
4. Click the 'Upload' icon in the tool bar.
5. Hit the error.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.