My Oracle Support Banner

Autoinvoice Program With Incorrect Grand Total Amount. (Doc ID 2257561.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Receivables - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

In the AutoInvoice Execution Report, the Grand Totals is not equal the Currency total after applying patch:13419481.

Example:

                                   AutoInvoice Execution Report                             Date: 25-JAN-2017 14:57
                                                                                                             Page:       1 of      4
             Request Id: 27468291

           Batch Source: Sample

  Transaction Flexfield:

       Transaction Type:
Bill To Customer Number:                                          to
  Bill To Customer Name:                                          to
                GL Date:                                          to
              Ship Date:                                          to
     Transaction Number:                                          to
     Sales Order Number:                                          to
       Transaction Date:                                          to
    Ship To Cust Number:                                          to
      Ship To Cust Name:                                          to

Interface Lines:                                 Interface Distributions:

                   Selected:       2386                             Selected:       3311
     Successfully Processed:       2386               Successfully Processed:       3311
                   Rejected:          0                             Rejected:          0

Interface Salesreps:                             Interface Contingencies:

                   Selected:          0                             Selected:          0
     Successfully Processed:          0               Successfully Processed:          0
                   Rejected:          0                             Rejected:          0


Transactions Created:

   Currency Name Sample

                                      Number of     Number of     Number of     Number of     Number of    Invoice Currency
   Class                           Transactions     Lines (*) Sales Credits Distributions Contingencies              Amount
   ------------------------------ ------------- ------------- ------------- ------------- -------------   -----------------
   Credit Memo                                3            15                          13             0         (66,483.00)
   Invoice                                  922         4,752                       3,298             0         222,638.10
                                  ------------- ------------- ------------- ------------- -------------   -----------------
                                            925         4,767                                                   156,155.10


Grand Totals:

                                      Number of     Number of     Number of     Number of     Number of
   Class                           Transactions     Lines (*) Sales Credits Distributions Contingencies      Invoice Amount
   ------------------------------ ------------- ------------- ------------- ------------- ------------- -------------------
   Credit Memo                                3            15                          13                       (66,483.00)
   Invoice                                  922         4,752                       3,298                       222,647.28  <-- should be 222,638.10.
                                  ------------- ------------- ------------- ------------- ------------- -------------------
                                            925         4,767                       3,311                       156,164.28  <-- should be 156,155.10.


 

Changes

After applying patch:13419481.

Cause

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
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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