ECM: Bank Account Number Encryption Process Abends With TR_CRYPT_AE -- RC = 1427, SQL Error: ORA-01427: Single-Row Subquery Returns More Than One Row
(Doc ID 2873149.1)
Last updated on FEBRUARY 07, 2024
Applies to:
PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Applied <Bug 33573561>- ENH: NACHA DATA SECURITY ENHANCEMENT FOR FSCM [FINANCIALS SUPPLY CHAIN MANAGEMENT], to encrypt Bank Account Numbers. The Bank Account Number Encryption process abends at TR_CRYPT_AE with an error at any given step after applying.
STEPS:
1. PeopleTools > Security > Encryption > Encryption Algorithm Keysets > for each of the Algorithm ID's noted, enter Key Value:
a. Algorithm ID = aes_ks256_cbc_encrypt
b. Algorithm ID = aes_ks256_cbc_decrypt
c. To generate Key Value, reference Tools <Document 1608091.1> - E-SEC: PET How To Create An 256 AES Encryption Profile Based On aes_ks256_cbc_encrypt
and aes_ks256_cbc_decrypt Keys
d. Key Value generated will be the same for both Algorithm IDs above
2. PeopleTools > Security > Encryption > Define Encryption Profiles
a. Setup both FSCM_ACCT_NUM_ENCRYPT and FSCM_ACCT_NUM_DECRYPT
b. Second Parameter Value is required > click magnifying glass > select Bank_Account_Number > Save
3. PeopleTools > Security > Encryption > Test Encryption Profiles
a. Encryption Profile ID = FSCM_ACCT_NUM_ENCRYPT
b. Text to be Encrypted = enter any value, i.e., 12345
c. Click 'Run Encryption' Profile
d. Encrypted Text field = HF5MKY9AN0+T+ITUdp/Ojw== (copy this value to be used in step 4c)
e. Save
4. PeopleTools > Security > Encryption > Test Encryption Profile
a. Encryption Profile ID = FSCM_ACCT_NUM_DECRYPT
b. Text to be Encrypted = HF5MKY9AN0+T+ITUdp/Ojw== (value from Step 3d)
c. Encrypted Text = 12345 (value from 3b)
d. Save
5. Set Up Financials/Supply Chain > Common Definitions > Encryption Configuration > Bank Account Number Encryption > make sure there are no financial
processes running when this process is running
a. Encryption Profile ID = FSCM_ACCT_NUM_ENCRYPT and Decryption Profile ID = FSCM_ACCT_NUM_DECRYPT
b. Click for 'Validate Profiles'
c. Profile Status = Valid
d. Process Encryption > click 'Run'
e. Process TR_CRYPT_AE abends
Changes
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 |
Changes |
Cause |
Solution |
References |