IEX Collection Note Upload  Help

IEX Collection Note Upload creates and updates Oracle Advanced Collections notes from Excel – the same notes collectors see in the Collections work area. Each note is attached at one Note Level: Party, Account, Bill To or Collections Transaction. For transaction notes, the upload can also record an Unpaid Reason, creating the collections delinquency it needs.

When to use it

• Log the outcome of a collections call campaign or dunning run as notes on many customers at once.
• Record notes against specific open invoices, with the customer’s unpaid reason.
• Migrate collection history notes from a legacy or third-party collections system.
• Reclassify existing notes by changing their Note Type or Note Status in bulk.

Before you start

• Access to the upload in Blitz Report, with a responsibility that can see the operating units of the accounts and transactions.
• The customers, accounts, bill-to sites and open transactions the notes belong to exist in Oracle Receivables.

Step 1 – Set the parameters

Open IEX Collection Note Upload in Blitz Report and set the parameters:

Step 2 – Run to download the Excel file

Click Run. The Excel file downloads and opens with one row per existing note, or an empty sheet in Create mode.

Step 3 – Enter or change the notes

For a new note, enter the columns that identify its target and pick the Note Level, which lists only the level matching the columns you filled:

Then enter the Note (up to 2,000 characters), an optional Note Detail for longer text (cut at 4,000 characters), the Note Type and the Note Status (defaults to Public). Entered Date defaults to the current date and time. Bill To Address and Delinquency Status are filled in for information.

On a new Collections Transaction note you can also set an Unpaid Reason. Collections holds it on the transaction’s delinquency, not on the note, so it applies to every note of that transaction. If Delinquency Status is blank the transaction has no delinquency yet: set Create Delinquency to Yes to create one with status Current, as the Collections form asks.

On a downloaded note only the Note Type, Note Status and descriptive flexfield columns can be changed; the note text and its target are fixed.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and saves the file. Correct any rows it flags before uploading.

Step 5 – Upload the file

In Blitz Report click Upload and select the saved file. This submits the upload request, which creates or updates each note.

Step 6 – Review the result report

When the request completes, a result report opens listing every uploaded row with its status and message, including the bill-to site, operating unit and delinquency status the note was attached to.

What’s produced

• Collection notes created at the chosen level, or existing notes with a changed type, status or flexfield values. A note is also linked to the levels above it (bill-to site, account, party) and to the customer’s collections contact, so it shows at each of those levels in Collections.
• For transaction notes with an Unpaid Reason: the reason stored on the transaction’s delinquency, and the delinquency created when Create Delinquency is Yes.
• A result report listing every row with a status (success or error) and a message.

Common questions

Can I change the text of an existing note?
No. Only Note Type, Note Status and the descriptive flexfield can be changed on an existing note. Add a new note instead.

Can I delete notes?
No. The upload only creates and updates notes.

Why can’t I set an Unpaid Reason on a downloaded note?
The unpaid reason, like Create Delinquency, can only be set when a note is created, as in the Collections notes window.

Why does the Note Level list show only one value?
It lists the level that matches the identifying columns entered on the row. To attach a note to an account rather than the party, enter the Account Number first; to attach it to a transaction, enter the Transaction Number.

Can I add notes to closed transactions?
No. Transaction notes can only be attached to open transactions.

Troubleshooting