Main Select For Batch LATEPYMT (Doc ID 2703858.1)

Last updated on AUGUST 31, 2020

Applies to:

Goal

On : 2.6.0.0.0 version, UT - Utilities

Main select for batch LATEPYMT

It was expected the batch to select all bills on or after their late payment charge date, as from the business date provided for the batch run. This does not seem to be true, as it is throwing out so many errors that relate to bills due in 2006, while it is expected it to only select bills where the LATE_PAY_CHARGE_DT = business date?
If it ignores the business date, and only select bills where the late_pay_charge_dt has passed, how does it eventually ignore those bills from previous runs?

How does the main select statement look like?
 

Solution

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