E1: 17: Amortization Workfile Generation - R17321 Causes Rounding Issues by Printing the TOTALS Value Different From the Sum of Contract Detail Lines Amortized Amounts (Doc ID 2987413.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Symptoms

For G Generation Type records, the R17321 is printing the TOTALS on the pdf output, at the bottom of the report, where the system is summarizing the values for each account based on the individual contract detail lines.
The individual contract detail lines amortized have both the F1794 and F0911 records / values in sync.
However, the TOTALS section on the pdf output has some values summarized that are not matching the sum of the individual lines printed at the beginning of R17321 pdf output.

For instance, the system is printing the following details on the pdf output of R17321 for 2 contract detail lines:

Contract        Or        Ver        Line        Cust                Start                End                    Document         Do        Do            G/L                     Debit                     Credit                                  Amount
Number         Ty        No         #            #                   Date                Date                   Number            Ty         Co            Date                   Account                 Account
98000577     CM       006       .001        10044451         01/01/2021      31/12/2021         21104542          JE         00280       30/06/2021         280.312110           28001FR14000.421100           46.36

and

Contract        Or        Ver        Line        Cust                Start                End                    Document         Do        Do            G/L                     Debit                     Credit                                  Amount
Number         Ty        No         #            #                   Date                Date                   Number            Ty         Co            Date                   Account                 Account
98000577      CM      006      .002        10044451          01/01/2021     31/12/2021          21104542          JE         00280       30/06/2021        280.312110            28001FR14000.421100           46.36

=============== Amount total = 46.36 + 46.36 = 92.72 ===============

At the end of report, on the TOTALS section, the Total Amount is slightly different:
TOTALS         Debit Account                  Credit Account                               Total Amount
                    280.312110                    28001FR14000.421100                    93.01

The users need to reconcile the values Amount total = 92.72 with the Total Amount ( = 93.01).

STEPS:

1. P1720 / P1721 – Create a contract with several contract detail lines.
2. R1732 – Run the UBE to create workfile details.
3. R1732 – Review the pdf output of the Workfile Generation UBE.
4. P1794 – Review the Gen Type B records created in the Billing/Amortization Control Inquiry screen.
5. R17321 – run the amortization process.
6. R17321 – Review the pdf output. Summarize the amounts for a specific account, e.g. 280.312110, the Amount total = 46.36 + 46.36 = 92.72
   At the end of the report, the TOTALS section shows the Total Amount for account 280.312110 = 93.01.

A greater number of contracts and contract detail lines amortized will increase the gap between the summarized Amount specific for a particular account and the Total Amount displayed in the TOTALS section for that account.

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.