LockBox in Oracle Fusion

 

What is a LockBox in Oracle Fusion?

In Oracle Fusion, a Lockbox is the automated process that takes 

   Bank remittance files (customer payments) 

   and imports them into Receivables(AR). 

   The system validates the data, 

             creates receipts, applies them to invoices, 

and then posts accounting entries to GL without manual intervention.

 

1.Navigate → Receivables Work Area

2.Select Manage Lockbox Transmission

3.Upload Bank File to UCM after we populate the data 

4.Run ESS Job -  Process Receipts Through Lockbox process

5.Monitor Scheduled Process

6.Manage Receipts → Verify Application

Process of the Lockbox Import Interface process in Oracle Fusion Applications.

Showing the two ESS (Enterprise Scheduler Service) jobs involved

Step 1 — Prepare Table Data

Use the Excel template for each interface table.

Follow bubble text on column headers for data type and instructions.

Common tasks: data merge setup and internal ID lookup.

Step 2 — Generate CSV File

Click Generate CSV File → creates a ZIP containing parent and child CSVs.

This ZIP is the input for the next ESS job.

Step 3 — ESS Job 1: Load Interface File for Import

Run Load Interface File for Import (first ESS job).

Upload the ZIP file to populate interface tables.

Validates and loads data into staging tables.

Step 4 — ESS Job 2: Process Receipts Through Lockbox process

Reads data from interface tables and applies receipts to customer accounts.

Completes reconciliation and updates AR transactions.

---Documented by Venkat--------