Introduction
This Post illustrates the steps required to Bank Account Creation API in Oracle EBS R12.
Script to Bank Account Creation API
DECLARE
p_init_msg_list VARCHAR2 (200);
p_acct_rec apps.ce_bank_pub.bankacct_rec_type;
x_acct_id NUMBER;
x_return_status VARCHAR2 (200);
x_msg_count NUMBER;
x_msg_data VARCHAR2 (4000);
p_count NUMBER;
BEGIN
p_init_msg_list := NULL;
— HZ_PARTIES.PARTY_ID BANK BRANCH
p_acct_rec.branch_id := 8056;
— HZ_PARTIES.PARTY_ID BANK
p_acct_rec.bank_id := 8042;
— HZ_PARTIES.PARTY_ID ORGANIZATION
p_acct_rec.account_owner_org_id := 23273;
— HZ_PARTIES.PARTY_ID Person related to ABOVE ORGANIZATION
p_acct_rec.account_owner_party_id := 2041;
p_acct_rec.account_classification := ‘INTERNAL’;
p_acct_rec.bank_account_name := ‘Test Bank Accunt’;
p_acct_rec.bank_account_num := 14256789;
p_acct_rec.currency := ‘INR’;
p_acct_rec.start_date := SYSDATE;
p_acct_rec.end_date := NULL;
ce_bank_pub.create_bank_acct (p_init_msg_list => p_init_msg_list,
p_acct_rec => p_acct_rec,
x_acct_id => x_acct_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
DBMS_OUTPUT.put_line (‘X_ACCT_ID = ‘ || x_acct_id);
DBMS_OUTPUT.put_line (‘X_RETURN_STATUS = ‘ || x_return_status);
DBMS_OUTPUT.put_line (‘X_MSG_COUNT = ‘ || x_msg_count);
DBMS_OUTPUT.put_line (‘X_MSG_DATA = ‘ || x_msg_data);
IF x_msg_count = 1
THEN
DBMS_OUTPUT.put_line (‘x_msg_data ‘ || x_msg_data);
ELSIF x_msg_count > 1
THEN
LOOP
p_count := p_count + 1;
x_msg_data := fnd_msg_pub.get (fnd_msg_pub.g_next, fnd_api.g_false);
IF x_msg_data IS NULL
THEN
EXIT;
END IF;
DBMS_OUTPUT.put_line (‘Message’ || p_count || ‘ —‘ || x_msg_data);
END LOOP;
END IF;
END;
What we expect in the script.
This script helps us to comprehend how Bank Account Creation into oracle through API. It also demonstrates the required validation taking place, and additional validation can be incorporated anytime in your package based on business requirements. Post validation correct records are being passed into APIs.
Summary
This Post described the script Bank Account Creation into oracle through API in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
