delete from interface

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
Racleoay
Posts: 26
Joined: Thu May 08, 2008 8:20 am
Location: United Arab Emirates

delete from interface

Post by Racleoay »

Hello

What are the consequences of deleting an invoice that was stuck in the autoinvoice interface, supposedly after clearing out the errors.

I don't get the benefit of deleting an invoice when we can create a credit memo!!!!

Can anyone please clarify this matter to me


thanks a million
hiszaki
Posts: 482
Joined: Thu May 10, 2007 9:03 am
Location: Egypt

Post by hiszaki »

Hi Racleoay

I think you can delete the invoice form interface tables using SQL plus or TOAD.

The auto-invoice program already delete the invoices from interface tables after transfer it to AR module.

Inquiry for your invoice you want to delete it then delete from interface table but you must re-work your work again.

Hope I can help you
Thanks
Hisham
admin
Posts: 2118
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

I can't understand why are you interested to delete an invoice from the interface table? Any transaction inserted by any Oracle module in the interface should be handled through system and should not be deleted from interface table as the transaction has a source document which created it. Now if you are uploaded any data from out side the Oracle then you can update or delete the data. Correct me if I have not taken your point right. thanks
Racleoay
Posts: 26
Joined: Thu May 08, 2008 8:20 am
Location: United Arab Emirates

Post by Racleoay »

Thanks Hisham & admin for your replies

I just wanted to know why would someone need to delete an invoice from the interface.


thanks again
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests