My Oracle Support Banner

Manage Netting Settlements not Picking up AR transactions (Doc ID 2389932.1)

Last updated on APRIL 03, 2019

Applies to:

Oracle Fusion Receivables Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to create netting Settlement, the Netting process is not picking transaction from Fusion Receivables

AFLOG file shows:
No AR transactions: Batch ID 300000011927811

Manage Netting Settlements should pick up AR and AP transactions.

The issue can be reproduced at will with the following steps:
1- AP and AR transaction are created.
2. Example of one AR transaction:
  Trx_number = 12345
  BU = Supply Chain USA
  Source = Manual
  Transaction Type = 51001
  Transaction date = 3/30/2018
  Due Date = 3/30/2018
  Bill to Name = <Customer Name>
  Status = Complete
3- Go to Receivables -> Account Receivables -> Manage Netting Settlements and create a new netting Settlement
4- The Manage Netting Settlement ends with status = Selected, no transactions
 This launched ESS  process Netting Settlement Batch Process  that ends successfully
 The log file shows:
  Process Batch - Batch ID <Batch ID>
  Create Netting Batch - Batch ID <Batch ID>
  No AR transactions: Batch ID <Batch ID>


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.