Simplified Loader’s Receivable Invoice Template offers a fully integrated Excel Spreadsheet with Oracle Fusion. The Receivable Invoice Template allows to create invoice, download, update, adjust and delete invoices. The Receivable Template supports loading file attachment from Excel.
Simplified Loader Receivable Invoice Template enhances team efficiency. It reduces the Billing team’s manual workload by providing an Excel-based tool to perform all the business functions on AR invoices. The Template is not limited to upload stand-alone AR invoices. It also enables users to adjust (write-off) existing invoices. Using Excel Template, you can download the invoice and upload the invoice back into Oracle Fusion with a revised field value.
Users of the Oracle Fusion Billing team can utilize Simplified Loader’s Excel Templates to download or upload Invoices from Excel to Oracle Fusion. Excel Template provides a feature-rich interface for the user to download invoices from Oracle Fusion. Excel Template provides a list of values for fields at Invoice Header, Lines, and Distribution’s level.
Receivable Invoice Excel Template is best suited for the Billing team in BAU or the Data Migration team. Simplified Loader Template allows loading any number of records with immediate validation feedback. The portable nature of Simplified Loader Excel sheets makes it possible to distribute the file to any user who wishes to enter Invoice details. Once the centralized Billing team receives the file populated with invoice data, they can use the same file (without a need to copy-paste data from one Excel file to another) to load data into Oracle Fusion.
Oracle provides an FBDI sheet for data upload. Compared with FBDI, Simplified loader Templates are 95% more convenient to organize data in Excel, steps involved in data upload, and resolving errors. With FBDI, the invoice is loaded into Oracle Fusion in a two-step process. In the first step, the invoice is loaded to the interface table. Then the import invoice program loads the invoice into Oracle Fusion. With Simplified Loader, the invoice is created directly in Oracle Fusion without posting the invoice to an interface table. All data validations take place at the time of invoice upload from Excel. Please review a detailed comparison with FBDI and ADFdi Template here.
Simplified Loader Receivable Template overcomes the workload challenge by providing an Excel-based invoice creation tool and reducing manual invoice creation efforts. Once the invoice details are entered, the “Create Invoices” functionality pushes the selected invoices in Excel to Oracle. The user gets responses in real-time with appropriate success or failure message.
Get Invoice functionality enables the users to download the details on an invoice existing in the Oracle Fusion. There are multiple use cases of this functionality. For example, downloaded details are updated in Excel and uploaded back to Oracle Fusion, duplicating an invoice or adjusting an invoice. Using Simplified Loader’s “Get Invoices” functionality, the users download single or multiple invoices in Excel.
Update Invoices functionality allows the users to update single or bulk AR invoices from Excel.
In case the invoices are incorrectly entered in Oracle Fusion, they can be adjusted in Oracle directly from Excel. Without Simplified Loader Template, the user would need to navigate to Oracle Fusion, search the invoice, and adjust the invoices one by one. Using Simplified Loader’s “Adjust Invoices” functionality, the users can adjust single or bulk invoices from Excel.
Get Installments operation enables the users to download installments of an existing invoice. The downloaded installments details could be modified and uploaded back to Oracle Fusion.
Update Installments functionality allows the users to update single or multiple Installment records.
If the invoice is created with incorrect information, the user can delete invoices using the “Delete Invoices” operation. Using Simplified Loader’s “Delete Invoices” functionality, the users can delete single or bulk invoices from Excel.
1) Roles or privileges required for Receivable Invoices Template.
The following privileges are required to upload Receivable Invoices.
1. Create Receivables Invoice (AR_CREATE_RECEIVABLES_INVOICE_PRIV)
2. Manage Receivables Adjustment (AR_MANAGE_RECEIVABLES_ADJUSTMENT_PRIV)