Create Invoice from Spreadsheet - Automate processes in OIC possibility — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Create Invoice from Spreadsheet - Automate processes in OIC possibility

Summary:

 Create Invoice from Spreadsheet - Automate process in OIC possibility

Content (required):

Hi - We have a weekly invoice load where we currently use the Create Invoice from Spreadsheet process and it builds the invoices through the ADFDI Excel add-in. We are looking to see whether we can potentially automate the manual steps by having the file(s) placed in an SFTP location and then have an OIC integration pick them up and transform into the appropriate format and call the Fusion Scheduled Process(es) to import them into Fusion.

I first wanted to know whether the current ADFDI process loads the data from the spreadsheet into the AP Interface (Staging) table (AP_INVOICES_INTERFACE / AP_INVOICE_LINES_INTERFACE), prior to fully importing into Fusion. I looked through the Scheduled Processes history and do not see the process "Load Interface File for Import" being called for the staging tables, I just see the process "Import Payables Invoices" being called so I was hoping to get some clarity on this.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!