Error While Creating External Bank Using API(IBY_EXT_BANKACCT_PUB.create_ext_bank)
Hi,
I am Trying to Create external Bank using the following code and am getting the following error.
Error : Error while creating bank. E 1 - Value for created_by_module must be a value defined in lookup type HZ_CREATED_BY_MODULES.
Note : In API the value for "created_by_module" is default to 'CE' and the same lookup value is predefined in lookup type HZ_CREATED_BY_MODULES.
DECLARE
lc_output VARCHAR2(3000)
lc_msg_dummy VARCHAR2(3000);
lc_return_status VARCHAR2(3000);
lc_msg_data VARCHAR2(3000);
ln_bank_id NUMBER;
ln_msg_count NUMBER;
lr_extbank_rec apps.iby_ext_bankacct_pub.extbank_rec_type;