Manage Netting Settlements not Picking up AR transactions

(Doc ID 2389932.1)

Last updated on APRIL 23, 2018

Applies to:

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

Symptoms

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

ERROR
-----------------------
AFLOG file shows:
No AR transactions: Batch ID 300000011927811

EXPECTED BEHAVIOR
-----------------------
Manage Netting Settlements should pick up AR and AP transactions.

STEPS
-----------------------
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 = 51001
  BU = Supply Chain USA
  Source = Manual
  Transaction Type = 51001
  Transaction date = 3/30/2018
  Due Date = 3/30/2018
  Bill to Name = APPLETON PACKING GASKET
  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 300000011927811
  Create Netting Batch - Batch ID 300000011927811
  No AR transactions: Batch ID 300000011927811


Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms