My Oracle Support Banner

ORA-01403 Credit Card Error On New Customer When Using Brand (Doc ID 2016157.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Transaction Payment

ORA-01403 Credit card error on New Customer When Using Brand

Customer applied <Patch 19273692>:R12.ONT.C to fix Credit Card unable to save issue.
Noticed this new error when trying to enter a new card on existing customer or new card on new customer.
Error happens if entering credit card brand, if you do not enter the brand- just enter the card details then there is no issue.

ERROR
-----------------------
ORA-01403: no data found in Package Oe_Oe_Form_Header Procedure Change_Attribute


Workaround:
Enter new credit card with card details and not by brand.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Order Organizer > Orders, Returns > Sales Order
3. Enter new Customer and new Credit Card using Credit Card Brand, or enter new card on existing customer using Brand >
4. Attempt to save record and you get error ORA-01403: no data found in Package Oe_Oe_Form_Header Procedure Change_Attribute


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot enter new customers using Card Brand.

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!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.