Manage Standard Operations in a Spreadsheet

If you need to work offline, then manage your standard operations using a Microsoft Excel spreadsheet. You can mass create and update the standard operations and resources by using the Oracle Application Development Framework Desktop Integration (ADFdi).

Here's how the ADFdi feature benefits you:

• After you download the standard operation data hosted on the Oracle Fusion Cloud Manufacturing application to a spreadsheet, you can modify it even when you're disconnected from the application.

• You can perform bulk entry and update of data with ease through a spreadsheet.

To manage standard operations in spreadsheet, you must first download and run the ADFdi Installer:

1. Click Navigator > Tools > Download Desktop Integration Installer.

2. Click Save File to download the desktop integration installer.

3. Double-click the executable file to install the ADF Desktop Integration Installer.

4. Click Install to proceed with the installation process.

5. Click Close to complete the installation process.

Then, download the standard operation data:

1. Click Navigator > Work Definition.

   In the Tasks pane, click the Manage Work Definitions in Spreadsheet link to download the worksheets.

2. Select the Open with option to open the Work Definition Excel file.

   The three worksheets are Standard Operations, Standard Operations Resources, and Standard Alternate Resources.

3. Click Yes to connect to the application.

4. Login with your credentials and start working.

Here's how you manage the standard operations in a spreadsheet:

1. Create and update the standard operations and resources in bulk by using the ADFdi.

   You must create the standard operation header details first, and then define the resource details and alternate resources for it.

2. Search for the standard operation details based on the search criteria available on each spreadsheet.

   You must search for the standard operation header or resource details before you can update any of the attributes.

   You must not run a blind report with values not specified for any of the parameters.

3. Update the data by overwriting the data in the search results table.

   After the update, an indicator appears in the Changed column for each updated row. The inactive cells are read only fields and are not included in the upload process.

4. Click Upload when you're ready to synchronize the changes with the Oracle Fusion applications. Any data validation errors will be shown in the spreadsheet after the upload. Check the Row Status column to know if the upload was successful.

Note: You can upload, query, or update the descriptive flexfields details in the work definitions using ADFdi. However, while uploading or updating the descriptive flexfields in the standard operation using ADFdi, only data type validations are performed. You can also query, create, update, or delete a standard operation using a REST API.