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

Last updated on APRIL 21, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms