Stored Value Card Purchase and Activation

Purpose: You can purchase a stored value card item on an order to deliver to the recipient card holder by mail or email. However, before the recipient card holder can use the stored value card as a form of payment, the card must be activated by the service bureau.

Activation processing: To activate a stored value card:

1.	A customer purchases a stored value card item on an order. If the stored value card is a virtual card, the system verifies that an email address is defined for the recipient card holder. See Purchasing a Stored Value Card.
2.	During pick slip preparation, the system creates a separate pre-generated pick for each physical stored value card. • After the picks are printed, you must: - Use Working with Physical Stored Value Card Assignment (WPSA) to assign a number to physical stored value cards by pick control number, OR - If you use an external system to assign numbers to physical cards, receive the card number in the CWPickIn XML Message. See Assigning Numbers to Physical Stored Value Cards for additional details. • For virtual stored value cards, during pick slip generation the system: - Assigns a number to the card from the Virtual Card Number Table (FLSVCA), OR - If you are using the Customer Engagement Stored Value Card Integration, assigns a number to the card by sending a Customer Engagement Generate Card Request to the Oracle Retail Customer Engagement system. See Assigning Numbers to Virtual Stored Value Cards.
3.	Once the stored value card is billed (see Billing a Stored Value Card), the system generates an SVC download trigger containing the information required to activate the card.
4.	The system sends a stored value card activation request to the service bureau for activation. • If the Use Activation / Reversal Batch Processing (I50) system control value is selected, the system does not process the SVC download trigger until you submit the batch process from the Transmitting Activation and Reversal Transactions (SSVC) menu option. In this situation, the SVC Activation integration layer job can remain inactive. • If the Use Activation / Reversal Batch Processing (I50) system control value is unselected, when active, the SVC Activation integration layer job monitors for SVC download trigger records to process immediately. See Activating a Stored Value Card.
5.	Once an approved stored value card activation is received from the service bureau, the system updates the stored value card and sends a Stored Value Card Notification Email to the customer, if defined, indicating the stored value card activation information.

Stored Value Card Activation Process:

In this chapter:

• Purchasing a Stored Value Card

- Stored Value Card Email Hierarchy

• Assigning a Stored Value Card Number

- Assigning Numbers to Physical Stored Value Cards

- Pick Stored Value Card Table

- Assigning Numbers to Virtual Stored Value Cards

• Billing a Stored Value Card

- Stored Value Card Table

• Reviewing Stored Value Card Activation Status

- Display Stored Value Cards Screen

• Activating a Stored Value Card

- Identifying SVC Download Triggers

- Generating the Stored Value Card Activation Request

- What Happens When the Stored Value Card Activation is Approved?

- Stored Value Card Notification Email

- What Happens When the Stored Value Card Activation is Declined?

Purchasing a Stored Value Card

You purchase a stored value card as you would any item.

Physical stored value cards: When you purchase a physical stored value card (SVC type Physical Card or Physical Card/Early Notify), the system:

• Reserves the item on the order, based on available inventory.

• Does not require an email address, even if the stored value card is eligible for email notification. If you ordered a physical stored value card (with email notification) and an email address is not defined, the system still allows you to accept the order; however, the Stored Value Card Notification Email is not sent.

Note: You can create a custom special handling template to capture stored value card information, such as the gift giver’s name, recipient’ name, and any gift message.

Virtual stored value cards: When you purchase a virtual stored value card (SVC type Virtual Card), the system:

• Automatically reserves the item on the order and express bills the item during pick slip generation.

• Requires an email address to send the Stored Value Card Notification Email to the recipient card holder. An email address is required because the email notification is the only way the recipient of the virtual stored value card will receive the stored value card number associated with the order. If you order a virtual stored value card item and an email address is not defined or the opt in/out value is invalid, the system displays an error and does not allow you to accept the order: Invalid e-mail address/opt in for order containing virtual SVC item. A similar error also displays when you process a web order. See Stored Value Card Email Hierarchy.

For more information: See Assigning a Stored Value Card Number for more information on how to assign a number to a stored value card.

Gift card hold: If the Use Gift Card Fraud Checking (L72) system control value is selected, the system places an order on GC Gift Card order hold if it contains a stored value card item and a stored value card payment method.

Stored Value Card Email Hierarchy

When a stored value card is activated and an email address is defined, the system sends a Stored Value Card Notification Email to the recipient of the stored value card.

The system uses the following hierarchy to determine the email address used to send a Stored Value Card Notification email to the recipient card holder. This email validation occurs in order entry and maintenance and during the generic order interface edit.

1. Send to ship to email address: Send the email to the email address defined for the ship to on the order.

- Order ship to: Send the email to the email address defined for the order ship to. The system requires an email address for the order ship to if a stored value card item exists on the order: Invalid email address/opt in for order containing virtual SVC item.

- Customer ship to: If an order ship to does not exist, send the email to the email address defined for the customer ship to. The system requires an email address for the customer ship to if a stored value card item exists on the order. In addition, the Opt in/opt out setting must allow for email delivery (codes O1 or O2): Invalid email address/opt in for order containing virtual SVC item.

- Recipient (Sold To/Recipient): If an order ship to or customer ship to does not exist, send the email to the email address defined for the recipient customer. The system requires an email address for the recipient if a stored value card item exists on the order. In addition, the Opt in/opt out setting must allow for email delivery (codes O1 or O2): Invalid email address/opt in for order containing virtual SVC item.

2. Send to customer sold to email address: If a ship to does not exist on the order, send the email to the email address defined for the customer sold to. The system requires an email address for the customer sold to if a stored value card item exists on the order. In addition, the Opt in/opt out setting must allow for email delivery (codes O1 or O2): Invalid email address/opt in for order containing virtual SVC item.

Note: If the email address or opt in/opt out value changes after the order has been accepted and before the stored value card is activated, it is possible that a Stored Value Card Notification Email may not be generated.

Assigning a Stored Value Card Number

Before you can activate a stored value card, you must first assign a number to the card. Assigning a number to a stored value card occurs during or after pick slip generation, depending on if the stored value card is a physical or virtual card.

• Assigning Numbers to Physical Stored Value Cards

• Assigning Numbers to Virtual Stored Value Cards

Assigning Numbers to Physical Stored Value Cards

Follow these steps to assign a number to a physical stored value card (SVC type Physical Card or Physical Card/Early Notify):

1. Generate a pick slip for the order containing the physical stored value card.

When you generate a pick slip for an order containing a physical stored value card, the system:

• prints a separate pick slip for each order line containing a physical stored value card. However, if you wish to print a separate pick slip for each unit of the stored value card item, set up the item as ship alone (Ship alone = Ship Alone).

• creates a record in the Pick Stored Value Card Table for each unit of the stored value card item printed.

• includes the stored value card item on the Pick Unit Report.

Pick Stored Value Card Table

This table contains a record for each physical stored value card item purchased whose pick control number has not yet been confirmed. Once you confirm the pick control number, the system deletes the stored value card record from this table. The system also uses this table to validate that a number has been assigned to the physical card before the card is shipped and confirmed.

Field	Description
Company	The company where you created the pre-generated pick containing the stored value card item.
PCH control #	The pick control number assigned to the pick containing the stored value card item.
Line #	The pick control line number containing the stored value card item.
Seq#	The pick stored value card sequence number.
Card #	The number assigned to the stored value card. This field is blank when the record is created during pick slip preparation; you use the Working with Physical Stored Value Card Assignment (WPSA) menu option or the svc_card_nbr in the CWPickIn XML Message to assign a number to the physical stored value card after pick slip generation. If you use credit card encryption, the stored value card number in this table is encrypted to provide additional security of stored value card data. See the Data Security and Encryption Guide for an overview.

If you void or reprint the pick slip: The system updates the Pick Stored Value Card table if you use the Reprinting and Voiding Pick Slips (WVRP or WSVP) menu option to void or reprint a pick slip and the pick control number containing the physical stored value card item has not yet been billed.

In WVRP when you:	The system:
Decrease the quantity allocated	Deletes the last pick stored value card record(s) created for the order line.
Void the pick slip	Deletes the associated pick stored value card records.
Reprint the pick slip	Deletes the associated pick stored value card records referencing the old pick control number and creates new pick stored value card records for the new pick control number.
Void and unreserve the pick slip	Deletes the associated pick stored value card records.

2. Assign a number to the physical stored value card.

• Use Working with Physical Stored Value Card Assignment (WPSA) to assign a number to a physical stored value card by pick control number, OR

• Use the svc_card_nbr tag in the CWPickIn XML Message to receive a card assignment from an external system.

3. Bill the pick control number containing the stored value card item.

The Use Streamlined Stored Value Card Billing (I23) system control value determines when the physical stored value card is sent to billing.

• If this system control value is selected, the system sends the pick control number assigned to the stored value card to billing immediately after you assign a number to the card.

• If this system control value is unselected, the system sends the pick control number assigned to the stored value card to billing after you wand and bill the card at the manifesting station.

If you use the Manually Confirming Shipments (MCON) menu option to confirm a pick control number containing a stored value card item, the system verifies that the stored value card is assigned a number. If the stored value card is not assigned a number, the system does not allow you to confirm the pick control number or change the status of the pick slip to carryover and instead displays an error message: All stored value card numbers must be entered before accepting.

For more information: See Billing a Stored Value Card for more information on the processing the system performs when you bill a stored value card.

Assigning Numbers to Virtual Stored Value Cards

To assign a number to a virtual stored value card (SVC type V), generate a pick slip for the order containing the virtual stored value card.

When you generate a pick slip for an order containing a virtual stored value card, the system:

• automatically assigns a stored value card number to the virtual card, using the next available number from the Virtual Card Number Table (FLSVCA) and deletes the record from the Virtual Card Number table.

Note: Make sure a number is available in the Virtual Card Number table to assign to the virtual stored value card; if a number is not available to assign to the card, the entire order line containing the stored value card item will not be billed and the order will print on the Stored Value Card Assignment Errors Report.

• express bills the item and sends the pick control number containing the virtual stored value card to billing.

• does not include the stored value card item on the Pick Unit Report.

Oracle Retail Customer Engagement Stored Value Card integration: If you are using the Customer Engagement Stored Value Card Integration, the system does not assign a number to a virtual card from the Virtual Card Number table. Instead, the system:

• generates a Customer Engagement Generate Card Request and sends the message to Oracle Retail Customer Engagement.

• receives the Customer Engagement Generate Card Response from Oracle Retail Customer Engagement, containing the assigned card number.

• express bills the item and sends the pick control number containing the virtual stored value card to billing.

• does not include the stored value card item on the Pick Unit Report.

For more information: See Billing a Stored Value Card for more information on the processing the system performs when you bill a stored value card.

Billing a Stored Value Card

When a pick control record containing a stored value card item is billed, the system:

1. Deletes the associated record in the Pick Stored Value Card Table, if the stored value card is a physical card.

2. Determines the issue amount to apply to the stored value card.

The Stored Value Card Activation Pricing Method (I25) system control value determines the price the system uses as the amount to apply to the stored value card.

• If this system control value is set to OFFER, the stored value card amount is the offer price. If the offer price is $0.00, the system uses the order line price.

• If this system control value is set to ORDER or blank, the stored value card amount is the order line price. If the order line price is $0.00, the system uses the offer price.

If both the offer price and order line price are $0.00, the stored value card amount is $0.00.

3. Creates a record in the Stored Value Card Table for each unit of the stored value card item.

Stored Value Card Table

This table contains a record for each stored value card item that has been billed.

Once you receive an approved activation response from the service bureau, the system updates this table with the activation information. You can review the stored value card at the Display Stored Value Cards Screen.

Additionally, when you purge an order, the system deletes any associated records in this table.

Field	Description
Company	The company where you processed the stored value card.
Order #	The order number where the stored value card was purchased.
Ship to #	The ship to number receiving the stored value card.
Seq #	The order line sequence number.
Seq #	The stored value card sequence number.
Card #	The stored value card number. If you use credit card encryption, the stored value card number in this table is encrypted to provide additional security of stored value card data. See the Data Security and Encryption Guide for an overview. If the Remove Stored Value Card Number After Activation (J22) system control value is selected, the words REMOVED BY SYSTEM display instead of the credit card number.
Card type	The type of stored value card. • P = Physical card • E = Physical card with email notification • V = Virtual card
Issue date	The date the stored value card was billed.
Issue amount	The amount assigned to the stored value card.
Activation date	The date the stored value card was activated; this is the date the system received and processed the approved stored value card activation response.
Activation time	The time the stored value card was activated; this is the time the system received and processed the stored value card activation response.
Email sent date	The date a Stored Value Card Notification Email was sent to the customer. The system sends an email when an approved activation response is received from the service bureau.
Auth service	The service bureau where the stored value card was sent for activation.
Response code	The activation response received from the service bureau. The system does not update this field until the system receives a stored value card activation response from the service bureau.
ID #	The ID number assigned to the stored value card.

4. Creates an SV tickler, if you Use Workflow Management (H96), for each stored value card item that was processed through billing without a number assignment.

A stored value card may be billed without a number assignment if you send the physical stored value card to the manifesting station without first using the Working with Physical Stored Value Card Assignment (WPSA) menu option to assign a number to the card. The system will not create a SVC download trigger for the stored value card until the card is assigned a number.

See SV (SVC Number Assignment) Event Processing for more information on how to resolve this tickler.

5. Creates an SVC download trigger in the Outbound Interface Transaction table for each stored value card that has been billed and is assigned a stored value card number.

You can review download triggers in the Working with Outbound Interface Transactions (WOIT) menu option. See Identifying SVC Download Triggers.

For more information: See Activating a Stored Value Card for more information on processing the SVC download triggers.

Activating a Stored Value Card

The system creates an SVC download trigger in the IL Outbound Trigger table when a stored value card item is billed (see Billing a Stored Value Card).

Identifying SVC Download Triggers

You can view all download triggers in the IL Outbound Trigger table at the Work with Outbound Interface Transactions Screen.

Each SVC download trigger in the IL Outbound Trigger table contains a:

• File code: indicating the type of information to download and which IL process job processes the trigger. For SVC download triggers, the File code is SVC.

• Key: indicating the specific record to download. For SVC download triggers, the Key identifies the specific company, order number, ship to number, order detail sequence number, and stored value card sequence number associated with the SVC download trigger. For example, the Key 555000066760010000100004 indicates the stored value card information is located in company 555 for order number 6676, ship to number 1, order detail sequence number 1, and stored value card number 4.

• Capture type: indicating the type of activity performed against the record. SVC download triggers are always capture type A indicating the stored value card was created.

SVC download triggers in a ready status are processed by the SVC_OUT integration layer job.

File code	Refers to table	Key	IL Process job
SVC	Stored Value Card	111222222223334444455555 where: 111 is the company code 22222222 is the order number 333 is the ship to number 44444 is the order detail line sequence number 55555 is the stored value card sequence number	SVC_OUT

Generating the Stored Value Card Activation Request

To generate a stored value card activation request, the system:

1.	Creates an SVC download trigger when an order containing a stored value card item assigned a number is billed; see Identifying SVC Download Triggers.
2.	Looks for unprocessed SVC download triggers to process, based on the setting of the Use Activation / Reversal Batch Processing (I50) system control value. • If this system control value is selected, the system does not process the stored value card trigger records until you submit the batch process using the Transmitting Activation and Reversal Transactions (SSVC) menu option or the SVCACT periodic function (program name PFR0076). In this situation, the SVC Activation integration layer job can remain inactive. • If this system control value is unselected, when active, the SVC Activation integration layer job monitors for stored value card download trigger records to process at defined intervals, based on the Outbound delay time. The system: • looks for SVC download triggers with the File code SVC and a status of ready (R). • determines which stored value card activation to download, based on the Key field for the activation download trigger. • looks for a record in the Stored Value Card Table that contains this information.
3.	Looks at the Stored Value Card Activation Authorization Service (I26) system control value to determine the service bureau used to activate stored value cards.
4.	Looks at the Communication type field for the service bureau to determine how transactions are processed between Order Management System and the service bureau. • Integration Layer = The system sends activation transactions to the service bureau using the queues defined for the activation integration layer job. • Payment Link = Point-to-point integration. The system sends activation transactions to the service bureau using a point-to-point integration. You must define communication settings in Working with Customer Properties (PROP). The system does not use the activation integration layer job to communicate with the service bureau; however, the system uses the job to process activation triggers. See Process Activations Using Payment Link Communication.
	Process Activations Using Payment Link Communication If the Communication type field for the service bureau is Payment Link: • Order Management System uses the settings in Working with Customer Properties (PROP) to send the activation request directly to the service bureau in the format of the other system. • The service bureau receives the activation request, processes the activation, and sends a response back to Order Management System. See Processing Authorizations and Deposits Using Point-to-Point Communication for a list of integrations that support point-to-point communication.
5.	Order Management System processes the activation response accordingly. See: • What Happens When the Stored Value Card Activation is Approved? • What Happens When the Stored Value Card Activation is Declined?

What Happens When the Stored Value Card Activation is Approved?

A stored value card receives an approved activation if the activation response contains an authorization number. In this case, the system:

• updates the associated record in the Integration Process Control table to CMP complete (if the Communication type field for the service bureau is Integration Layer).

• updates the associated record in the Stored Value Card Table with the activation date, activation time, and activation response.

• generates a Stored Value Card Notification Email and sends the email to the recipient card holder.

You can review the activated stored value card at the Display Stored Value Cards Screen. The activated stored value card number will have an Activation date, time, and response. Additionally, if a Stored Value Card Notification Email was sent, the Email sent field will display the date the email was sent to the customer.

Note: If you receive a declined stored value card activation response after you have already received an approved response, the system does not deactivate the stored value card; the card remains activated and available to use as payment.

If a customer returns a stored value card or reports the card stolen: If a customer returns a stored value card or reports the card stolen, you must call the service bureau to deactivate the card.

Stored Value Card Notification Email

The system sends a Stored Value Card Notification email or XML message to the recipient card holder when the SVC_OUT job processes an approved stored value card activation request and:

• The SVC type field for the stored value card item is E (physical card with notification) or V (virtual card).

• An email is defined for the recipient card holder. The system uses the Stored Value Card Email Hierarchy to determine the email address used to send a Stored Value Card Notification email to the stored value card recipient.

• The Stored Value Card Email Notification Program (I30) system control value specifies a valid program name.

A separate email is sent for each unit of a stored value card item ordered. For example, if a customer purchases a stored value card for a quantity of 2 to send to a recipient customer, the recipient card holder receives 2 stored value card emails.

Note: Credit card encryption allows you to encrypt the stored value card number in the Order Management System database. If you use credit card encryption, the stored value card number will be unencrypted and unformatted in this email since the customer needs to read the stored value card number for future purchases. See the Data Security and Encryption Guide for an overview.

Order history message: The system writes an order transaction history message, indicating a stored value card notification was sent to the stored value card recipient customer: SVC Notice to bmiranda@att.net.

For more information: See Working with E-Mail Notification Templates (WEMT) for more information on how the system generates email notifications, and see Stored Value Card Notification Sample and Contents for a sample email message. Also, see the Outbound Email API for information on when the system generates the Outbound Email XML Message (CWEmailOut) instead of an email, and the XML message layout.

What Happens When the Stored Value Card Activation is Declined?

A stored value card receives a declined activation if the activation response does not contain an authorization number. In this case, the system:

• updates the associated record in the Integration Process Control table to FLD error (if the Communication type field for the service bureau is Integration Layer).

• creates a SD tickler if you Use Workflow Management (H96), indicating the stored value card activation request was declined. See SD (SVC Activation Decline) Event Processing for more information on how to resolve this tickler.

• includes the order containing the declined stored value card on the Unactivated Stored Value Card Report. This report prints when you run the Unactivated Stored Value Cards periodic function (program name PFR0075).

• does not send a Stored Value Card Notification Email to the customer, since the stored value card was not activated.

You can review the declined stored value card at the Display Stored Value Cards Screen. The declined stored value card number will have an Activation response, but a blank Activation date and time.

To activate a declined stored value card: You must call the service bureau to activate the card. You cannot re-send an activation request to the service bureau.

Reviewing Stored Value Card Activation Status

In standard Order Inquiry, you can review the stored value cards purchased on an order at the Display Stored Value Cards screen. This screen is also helpful if the customer purchased a virtual stored value card and forgot the number to use when making a purchase.

Note: This screen is not available until the stored value card item has been assigned a number and processed through billing.

Display Stored Value Cards Screen

This screen indicates:

• the type of stored value card purchased

• the issue amount applied to the stored value card

• the card number

• the date the card was processed through billing

• the date and time the card was activated and the response received (if the card received a declined activation response, the system updates the Response field but does not update the Activation date and time)

• the date a Stored Value Card Notification Email was sent to the customer

If the Remove Stored Value Card Number After Activation (J22) system control value is selected, the words REMOVED BY SYSTEM display instead of the credit card number.

Secured features:

• If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, the stored value card number does not display on this screen.

• If you do not have authority to the Display Full Credit Card Number (B14) secured feature, the stored value card number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, 4788********1443 may display instead of the entire stored value card number. See Credit Card Number Format for an overview.

Note: Depending on the user’s authority to credit card information, the system writes a record to the Credit Card Audit table when this screen is displayed. See Logging Credit Card Data Access in the Data Security and Encryption Guide for more information.

Remove Stored Value Card numbers from the database: For additional security, run the periodic function SECRISK to replace the first 12 digits of activated Stored Value Cards in the database with asterisks (*) when the Stored Value Cards are older than the Credit Card Retention Days (K65).

How to display this screen: At the standard Order Inquiry detail screen, select SVC for an order line containing a stored value card that has been billed.

Field	Description
Order#	The order number and ship to number where the stored value card item was purchased. Order#: Numeric, 8 positions; display-only. Ship to#: Numeric, 3 positions; display-only.
Line#	The order line number containing the stored value card item. Numeric, 3 positions; display-only.
Card type	Indicates the type of stored value card purchased. • Physical card • Physical card with email notification • Virtual card Alphanumeric, 1 position; display-only.
Issue amount	The initial amount applied to the stored value card. This amount does not reflect the remaining balance on the card, if the card has already been used as payment for a purchase. Numeric, 7 positions with a 2-place decimal; display-only.
Card#	The number assigned to the stored value card. Masking: If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, the stored value card number does not display on this screen. If you do not have authority to the Display Full Credit Card Number (B14) secured feature, the stored value card number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, 4788********1443 may display instead of the entire stored value card number. See Credit Card Number Format for an overview. If the Remove Stored Value Card Number After Activation (J22) system control value is selected, the words REMOVED BY SYSTEM display instead of the credit card number. For additional security, run the periodic function SECRISK to replace the first 12 digits of activated Stored Value Cards in the database with asterisks (*) when the Stored Value Cards are older than the Credit Card Retention Days (K65). Alphanumeric, 20 positions; display-only.
Issue date	The date the stored value card was processed through billing. Numeric, 6 positions (user date format); display-only.
Activation date	The date the stored value card was activated; this is the date the SVC_OUT process received and processed the approved stored value card activation response. Numeric, 6 positions (user date format); display-only.
Activation time	The time the stored value card was activated; this is the time the SVC_OUT process received and processed the stored value card activation response. Numeric, 6 positions (user date format); display-only.
Activation response	The activation response received from the service bureau. Alphanumeric, 10 positions; display-only.
Email sent	The date a Stored Value Card Notification Email was sent to the customer. The system sends an email when an approved activation response is received from the service bureau. Numeric, 6 positions (user date format); display-only.