We have a requirement to create orders for the credit card customers. The credit cards in our case are encrypted using "Encrypt Credit Card Data” concurrent program . The process order API needs CC# to be passed in the decrypted format,i.e, full 15 digits. Now, as existing credit cards are already encrypted, the card number in the iby_creditcard table has only last 4 digits of the credit card. Once this credit card number is derived and passed to the process order API, it fails as it expects the complete credit card number. We are exploring a way to temporarily decrypt credit card based on the last 4 digits via an API/routine and pass it to the process order API.
We are on R12.1.3 version of EBS.
All pointers in this direction are appreciated.