R12.1.3 : View IBY_EXT_BANK_ACCOUNTS_V Is Missing Column ENCRYPTED, After 12.1.3 Upgrade [ID 1405164
We face the problem as described in note View IBY_EXT_BANK_ACCOUNTS_V Is Missing Column ENCRYPTED, After 12.1.3 Upgrade [ID 1405164.1]
in the note we get the instruction to raise a service request.
Additionally to the above mentioned error we found an error in the view
IBY_FNDCPT_PAYER_ALL_INSTRS_V
In the lowest section:
CREATE OR REPLACE VIEW IBY_FNDCPT_PAYER_ALL_INSTRS_V
....
...
UNION
SELECT o.account_owner_party_id, 'BANKACCOUNT', b.bank_account_id,
b.currency_code, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, b.bank_account_number,
b.bank_acct_num_hash1, b.bank_acct_num_hash2, b.bank_name,
in the note we get the instruction to raise a service request.
Additionally to the above mentioned error we found an error in the view
IBY_FNDCPT_PAYER_ALL_INSTRS_V
In the lowest section:
CREATE OR REPLACE VIEW IBY_FNDCPT_PAYER_ALL_INSTRS_V
....
...
UNION
SELECT o.account_owner_party_id, 'BANKACCOUNT', b.bank_account_id,
b.currency_code, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, b.bank_account_number,
b.bank_acct_num_hash1, b.bank_acct_num_hash2, b.bank_name,
Tagged:
0