Business has a common requirement to mass update sourcing rules/sourcing assignments frequently for the Supply Planning/GOP Assignment Set. Sourcing assignments can be updated thru standard user interface screen (Manage Assignment Sets, but it has to updated one by one and takes a lot of time. Oracle provided an additional feature in Oracle Fusion to mass update sourcing assignments thru ADFDI (Excel Add-on).
Prerequisite:
- Install ADFDI on your desktop
- Download ADFDI Plug-In: Fusion Instance > Tools > Download Desk Integration Installer
- Download ADFDI Plug-In: Fusion Instance > Tools > Download Desk Integration Installer
- Install the Plug-In on your desktop
- Enable Macros in the Excel (Open Excel -> File > Options > Trust Center > Trust Center settings > Macro settings)
Mass updating sourcing assignments:
- Navigation: Supply Chain Planning > Supply Planning > Tasks > Manage Assignment Sets > Search for the planning assignment set
- Edit in Spreadsheet
- Downloads “SourcingAssignmentRTxx” Excel file
- Open the “SourcingAssignmentRTxx” Excel file
- Once the excel file is opened, it will prompt you to connect to the Oracle Fusion environment
- Connect to the target environment using your fusion credentials
- Click on search button from the toolbar > Brings sourcing assignment data from Fusion into Excel
- Make the necessary updates
- Once the updates are done, Please click on “Upload” to save the changes.
- Click on Ok for the above dialog box
