RTLog For Foreign Currency Tender With 0.00 Value In Tender Line Item Causes Error In ReSA (Doc ID 2264318.1)

Last updated on MAY 16, 2017

Applies to:

Oracle Retail Point-of-Service - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Point-of-Service (ORPOS) 14.0.2, when the RTLog is generated for foreign currency tender with 0.00 value , TTEND line items gets added without the amount, this causing ORGCUR_WITHOUT_ORGCUR_AMT error in ReSA.


The issue can be reproduced at will with the following steps:

  1. Select F3 POS;
  2. Enter item 1002;
  3. On Sell Item screen , select F6 Tender;
  4. On the Tender Options screen , select F9 More;
  5. Select F6 Foreign Currency and CAD;
  6. On the CAD currency screen , change the tender amount to 0.00 and F2 Cash;
  7. A tenderline item gets added to the Tender Options screen with no amount;
  8. Select F9 More > Foreign Currency > CAD > Cash;
  9. Receipt prints example below:

    3/21/17 11:57 AM
    Trans.: 0146 Store: 01111
    Reg.: 127 Till: 129 Cashier: Applicatio Sales: Applicatio  Sale
    Barcode:[{B011111270146]
    __________________________________________

      360Commerce Item1 10.00 T
      1002 1 @ 10.00
      Advan=10.00 @ 8.2500% 0.83
     
    Subtotal 10.00
      Advan Taxable Amount 10.00
      Advan Tax 0.83
    Total Sales Tax 0.83
     
    Total 10.83
     
      Cash 0.00
      CAD Amt. Rec'd:
      Exchange Rate: 0.961317
      Cash 10.83
      CAD Amt. Rec'd: 11.27
      Exchange Rate: 0.961317

    Total Tender 10.83
    Change Due 0.00
    Number of Items Sold: 1
  10. RTLog gets generated :

    FHEAD0000000001RTLG20170321115737201703161111 V.14.0:BID 20170321115737
      POS
    THEAD0000000002129 2017032111572812700001460 0 SALE SALE
     
      P
      P P
      
      POS
    TITEM0000000003S ITEM ITEM 1002
    004800000000P000000010000EA 00000000000000100000 00000000000000100000Y
      N
    N000000010000N 000000000000000083000
      R
    IGTAX00000000040000005000DSTRCT00000000000000082500P000000000000000083000
    TTEND0000000005CASH 1010 P00000000000000000000
      CAD
    TTEND0000000006CASH 1010 P00000000000000108300
      CAD00000000000000112700
    TTAIL00000000070000000004
    FTAIL00000000080000000006

    * Notice that there is no amount next to the CAD field which causes an error in ReSA.

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