autoapply invoice to receipt

The user or customer prefers to create the receipt through a spreadsheet. Once the receipt is available in Oracle, it will be created and automatically applied to the corresponding invoices. The invoice apply criteria may be based on factors such as amount, customer name, or transaction type. Can we achieve this in Oracle without using lockbox concept? if yes, could you please describe the steps to accomplish it?.