Updation of AP tables

[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

[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.

[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

[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