This podcast details how to automate file transfers to an Oracle CPQ site using FTP, primarily for regularly updating data like pricing tables from an ERP system. It outlines a process involving preparing data in specific XML and ZIP file formats, creating upload_list.xml controller files specifying the order of processing, and uploading these to a designated FTP folder. The system prioritizes files based on modification dates, processing the most recent first. Beyond simple uploads, advanced features allow for data table manipulation (delete, upload, deploy) through structured XML files within the automated process. Crucially, the process requires initial setup via My Oracle Support and careful attention to data formatting to ensure compatibility with Oracle CPQ's import functionality.
