Home » SQL & PL/SQL » SQL & PL/SQL » deleting vendors from po_vendors table
| deleting vendors from po_vendors table [message #27434] |
Thu, 02 October 2003 07:50  |
Anne
Messages: 36
Registered: April 2002
|
Member |
|
|
I've been testing things in a testing environment by adding vendors with Dataload into the ap suppliers form in 11i. Would there cause any problems by me deleting these vendors from the po_vendors table by simply using this sql statement:
delete from apps.po_vendors where last_updated_by = 2545
I understand that other tables are involved such as:
AP_DISTRIBUTION_SETS_ALL
AP_TERMS_TL
FND_CURRENCIES
FND_CURRENCIES
GL_CODE_COMBINATIONS
GL_SETS_OF_BOOKS
ORG_FREIGHT_TL
PO_AGENTS
PO_VENDORS
But isn't there a trigger in the po_vendors table that will delete the information from all other tables?
Will I need to incorporate another script with the other tables that deletes the vendors?
|
|
|
|
| Re: deleting vendors from po_vendors table [message #27439 is a reply to message #27434] |
Thu, 02 October 2003 11:16  |
Art Metzer
Messages: 2480
Registered: December 2002
|
Senior Member |
|
|
Anne,
If you want to delete vendors, I'm pretty sure you have to delete the vendors from the Application by hand (i.e., no API), if Apps lets you. If Apps doesn't let you, then there must be a sound reason for it.
If Oracle learns that your vendor relationships are broken because a DELETE statement was issued from SQL*Plus, make no mistake about it, they will end your support there and then.
The interrelations in Oracle Apps are far too complicated to assume that a single DELETE will take care of matters or that some magical triggers somewhere will maintain referential integrity. I'm afraid you're going to have to bite the bullet and hit that "X" button for every vendor you want to delete.
That is the price paid for agreeing to the Oracle Apps support contract.
Good luck, Anne.
Art.
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed May 21 22:28:40 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
