Oracle ADF Desktop Integration (ADFdi)
The Application Development Framework Desktop Integration (ADFdi) option enables desktop integration with Microsoft Excel spreadsheets and manages large-volume data downloads and uploads to Oracle Fusion Cloud Applications.
ADFdi integration provides the interactivity that enables the web picker to:
- Search for valid values.
- Perform validation during data entry.
- Display error messages.
- Submit transactions directly from Microsoft Excel immediately.
Oracle Supply Chain Planning provides ADFdi support for these entities:
Supplies and Demands
Key Features
Use the Edit in Spreadsheet action to export supplies and demands to an Excel workbook, perform the edits within the workbook, and then upload the changes back into the plan.
Best Practices
Use Edit in Spreadsheet instead of the UI to edit rows in small batches.
Constraints
The document will be limited to 2000 rows. Edits will work better if the maximum number of rows is 200.
Items
Key Features
Use the Edit in Spreadsheet action to export items to an Excel workbook, perform the edits within the workbook, and then upload the changes back into the plan.
Best Practices
Use Edit in Spreadsheet instead of the UI to edit rows in small batches.
Constraints
The document will be limited to 2000 rows. Edits will work better if the maximum number of rows is 200.
Item Structures
Key Features
Use the Edit in Spreadsheet action to export item structures to an Excel workbook, perform the edits within the workbook, and then upload the changes back into the plan.
Best Practices
Use Edit in Spreadsheet instead of the UI to edit rows in small batches.
Constraints
The document will be limited to 2000 rows. Edits will work better if the maximum number of rows is 200.
Segment Members
Key Features
Use the Edit in Spreadsheet action to export segment members information to an Excel workbook, perform the edits within the workbook, and then upload the changes back into the segment members.
Best Practices
Use Edit in Spreadsheet instead of the UI to edit rows in small batches.
Constraints
The document will be limited to 2000 rows. Edits will work better if the maximum number of rows is 200.