Automate email from Import Intercompany Transactions when using ADFDI
We process a large number of intercompany transactions, many of those transactions are loaded by users, via the ADFDI Spreadsheet loader for intercompany transactions.
The issue:
When loading these transactions, the ADFDI loader provides you the "Success/Failure" notification within the loader itself, for those rows loaded. This only indicates that the transactions were valid to send over to Oracle.
Our users would like to notified (via email ideally) if the Import Intercompany Transactions process completes and loads all their transactions, or fails to load some /all transactions.
This would eliminate the need to manually enter the system to have to check every single transaction or import process to determine if the transactions were actually fully loaded into Oracle and an intercompany batch was created.