My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.