My Oracle Support Banner

Main Select For Batch LATEPYMT (Doc ID 2703858.1)

Last updated on AUGUST 31, 2020

Applies to:

Oracle Utilities Customer Care and Billing - Version and later
Information in this document applies to any platform.


On : 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?


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.