EAR: Payment Predictor With Algorithm #DTL_TLR And Underpayment Within Tolerance Using System Function WS-09 (Write Off - WO) Not Generating Balanced Worksheet Even After Applying Bug Fix 28476892 (Doc ID 2685658.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Symptoms

On : 9.2 version, Payment Predictor

ISSUE:

Having defined a Payment Predictor Method that is using delivered Algorithm #DTL_TLR, and configured at the Predictor Detail Options level the Amount and Percentage Tolerances to be used, and what functions to execute in each scenario, (For an Underpayment within Tolerance it should use System Function WS-09, Write-Off), when running the Payment Predictor AE Program (AR_PREDICT1), the results obtained are not the expected ones.
 
While the system generates a new Payment Worksheet, this one is unbalanced, because the remaining amount is not being automatically written off even though it falls within the defined tolerances.
 
System Function WS-09 (Write-Off) is the one to be used for both VAT and non-VAT Business Units. System Function WAU can not be used as it will throw VAT related errors.

REPLICATION STEPS:

    1.- Define a Payment Predictor Method using Algorithm #DTL_TLR
    2.- Configure this Payment Predictor Method at the Business Unit, and Customer set up level
    3.- At the Predictor Detail Options tab from the Receivables Options level, define Write Off Tolerances of 5 USD, and 100% of the amount, as well as state that if there is an underpayment within such Tolerance, it should be Written Off (System Function WS-09)
    4.- Create an online Pending Item for an amount of 1200 USD, and set the Group to Post Action of Batch Standard
    5.- Launch AR Update to post the new Item into the Customer's Account
    6.- Follow suite with the creation of a new Regular Deposit, with a Payment of 1199 USD, and link the Item ID created in the Detail References. Flag such Payment for Payment Predictor
    7.- Run Payment Predictor AE Program
    9.- The process should go to Success
    10.- Check the generated Payment Worksheet, and confirm it is unbalanced for a remaining amount of 1 USD

Cause

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