How To Fetch Payment Posted After Bill Cycle End Date but Before Bill Run (Doc ID 1957311.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Goal

How to display payments received after the end of a billing cycle in the invoice?

Some parameters/definitions/assumptions:

First cycle is from 1/1 to 2/1 and second cycle 2/1 to 3/1
First bill is B1 (for period 1/1 - 2/1) and second bill is B2 (for period 2/1 - 3/1)
First invoice is I1 (for period 1/1 - 2/1) and second invoice is I2 (for period 2/1 - 3/1)
Assume B1/I1 is run on 2/5
Assume B2/I2 is run on 3/10
Assume a payment P1 is made on 2/3

Requirement : To display P1 in I1 and NOT on I2
Note: This requirement is NOT supported in current OOB Invoicing functionality.

Solution

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