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:

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

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