Gift Card Number Does Not Populate Into SA_TRAN_ITEM.VOUCHER_NO When A New Gift Card Is Being Sold (Doc ID 3073844.1)

Last updated on FEBRUARY 25, 2025

Applies to:

Symptoms

On XOCS 24.x:

Problem Description
---------------------------
Gift card Number does not populate into SA_TRAN_ITEM.VOUCHER_NO when a new gift card is being sold.

Based on Doc ID 3040426.1 and MFCS V19 Operation Guide 2, REF_NO8 should be voucher type id (4040, 4030). But currently in V24, this field keeps the gift card number, and the item type is 'NMITEM' instead of 'GCN'.
Looks like the RTLOG Generator has conflicted with Eftlink GC authorization has generated an APPROVALFLAG is always TRUE in the lineitem property on PosLog. RTLOG generator has generated GC item with 'NMITEM' type and Gift Card No to REF_NO8.
**Current gift card in SA_TRAN_ITEM:
- ITEM_TYPE: 'NMITEM'

- NON_MERCH_ITEM: Gift Card SKU

- VOUCHER_NO:

- REF_NO8: Gift Card Number

**Expectation for the gift card in SA_TRAN_ITEM table:
- ITEM_TYPE: 'GCN'

- NON_MERCH_ITEM: Gift Card SKU

- VOUCHER_NO: Gift Card Number

- REF_NO8: 4040/4030


STEPS
-----------------------
Sell a new gift card on Xstore, check the related field in ReSA, VOCHER_NO is not populated in the SA_TRAN_ITEM in the required field. Plus, the issue data is not populated in the SA_VOUCHER table.

Cause

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