Dear All,
We would like to insert the rows in AP_BANK_BRANCHES table using text file. Is the correct procedure for inserting the rows in this table. Any effect for other tables while inserting. Please suggest.
Thanks in advance,
Madhu
Updation of AP tables
Hi,
Yes you can insert the records in AP_BANK_BRANCHES.
If you can give details of the requirement, we can suggest more.
AP_BANK_BRANCHES has the bank name and branch names
AP_BANK_ACCOUNTS_ALL has all the accounts detail
ap_bank_account_uses_all
AP_BANK_ACCOUNT_USES_ALL has the link between suppliers and bank accounts.
Yes you can insert the records in AP_BANK_BRANCHES.
If you can give details of the requirement, we can suggest more.
AP_BANK_BRANCHES has the bank name and branch names
AP_BANK_ACCOUNTS_ALL has all the accounts detail
ap_bank_account_uses_all
AP_BANK_ACCOUNT_USES_ALL has the link between suppliers and bank accounts.
-
- Posts: 130
- Joined: Sun Mar 11, 2007 1:47 am
- Location: India
Hi,
You may insert into the data in AP_BANK_BRANCHES.
The above table having triggers. You need to check before inserting into AP_BANK_BRACHES table, which is the sequence needs to be use while inserting into the data.
Otherwise, you may get the errors in front end application in bank form.
Regards,
Siva
You may insert into the data in AP_BANK_BRANCHES.
The above table having triggers. You need to check before inserting into AP_BANK_BRACHES table, which is the sequence needs to be use while inserting into the data.
Otherwise, you may get the errors in front end application in bank form.
Regards,
Siva
Hi Anu,
You are suggesting its OK to update the base tables. I believe Oracle does not support updates/instrts to base tables using any back end tools.
[quote]Hi,
Yes you can insert the records in AP_BANK_BRANCHES.
If you can give details of the requirement, we can suggest more.
AP_BANK_BRANCHES has the bank name and branch names
AP_BANK_ACCOUNTS_ALL has all the accounts detail
ap_bank_account_uses_all
AP_BANK_ACCOUNT_USES_ALL has the link between suppliers and bank accounts.
<i><div align="right">Originally posted by anu_uma
You are suggesting its OK to update the base tables. I believe Oracle does not support updates/instrts to base tables using any back end tools.
[quote]Hi,
Yes you can insert the records in AP_BANK_BRANCHES.
If you can give details of the requirement, we can suggest more.
AP_BANK_BRANCHES has the bank name and branch names
AP_BANK_ACCOUNTS_ALL has all the accounts detail
ap_bank_account_uses_all
AP_BANK_ACCOUNT_USES_ALL has the link between suppliers and bank accounts.
<i><div align="right">Originally posted by anu_uma
Who is online
Users browsing this forum: No registered users and 4 guests