E1: 54R: Rental Billing Workfile Generation (R54R300) Generates Negative Amounts where Requested Billing Day Is in the Past (Doc ID 2863761.1)

Last updated on OCTOBER 12, 2022

Applies to:

Symptoms

When running Rental Billing Workfile Generation (R54R300) in a particular scenario where the Requested Billing Day is in the past, the amounts get calculated as negative without either a warning or an error.

The issue can be reproduced at will with the following steps:

1. P54R10 Create a rental contract with following dates:
      Billing Start Date 03/30/2022 (current date)
      Billing End Date   04/30/2022
      Requested Billing Day  1
2. Run R54R300 to bill the contract.
3. R54R300 Completed Normally. Check the report output. The amount is negative without any error. Note the Line Billed From - Line Billed To period is 03/30/2022 - 03/01/2022.

Changes

Cause

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