Return of a Transaction Tendered with Gift Card and Credit Card Causes Data Violation ORA-00001 (Doc ID 1125245.1)

Last updated on JUNE 07, 2021

Applies to:

Symptoms

In Oracle Retail Point-Of-Service (ORPOS), when doing a return with receipt POS generates a ORA-00001 error when the retrieved transaction is tendered with gift card and credit card.

Steps to Reproduce:

Pre-requisite: Issue a new gift card with $20.

1. Enter an item on the Sale Screen.
2. Click Tender.
3. Perform split tendering.  Enter $10 in Tender Option screen.
4. Click gift card and enter gift card number and continue.
5. Tender remaining amount with Credit Card.
6. Click Return > Return with Receipt.
7. Retrieve the transaction and move forward to Sale Screen.
8. In Sale Screen, Click Tender.
9. In Tender Option screen, click Credit.
10. Enter Customer Information. Press Next.
11. Enter Credit Card information and complete the return transaction.
    
    Observe the following error in server log:

Changes

Cause

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