OraFAQ Forum: SQL & PL/SQL » deleting vendors from po

Home » SQL & PL/SQL » SQL & PL/SQL » deleting vendors from po_vendors table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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?

Report message to a moderator

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.

Report message to a moderator