Page 1 of 1
Updation of AP tables
Posted: Fri May 28, 2010 11:46 pm
by madhuarepalli
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
Posted: Mon May 31, 2010 2:29 pm
by anu_uma
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.
Posted: Tue Jun 01, 2010 12:56 pm
by siva sankar
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
Posted: Sun Jun 06, 2010 8:43 pm
by liz
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