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 MARCH 10, 2019

Applies to:

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


In Oracle Retail Point-of-Service (ORPOS), 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 Retail Sales Audit (ReSA).

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

  1. Select F3 POS;
  2. Enter Item (Example: 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: 04241
    Reg.: 127 Till: 129 Cashier: Applicatio Sales: Applicatio  Sale

      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 :

    FHEAD0000000001RTLG20170321115737201703164241 V.14.0:BID 20170321115737
    THEAD0000000002129 2017032111572812700001460 0 SALE SALE
      P P
    TITEM0000000003S ITEM ITEM 1002
    004800000000P000000010000EA 00000000000000100000 00000000000000100000Y
    N000000010000N 000000000000000083000
    TTEND0000000005CASH 1010 P00000000000000000000
    TTEND0000000006CASH 1010 P00000000000000108300

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




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

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