OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » how to know who deleted the sales order lines?

Home » Applications » Oracle Fusion Apps & E-Business Suite » how to know who deleted the sales order lines?

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

how to know who deleted the sales order lines? [message #648947]

Tue, 08 March 2016 09:26

pthrinadh3@gmail.com
Messages: 14
Registered: March 2016
Location: VIZAG

Junior Member

Hi All,
I need some help determining who deleted the sales order lines with user IDs and dates.

Regards,
Thrinadh

Report message to a moderator

Re: how to know who deleted the sales order lines? [message #648960 is a reply to message #648947]

Tue, 08 March 2016 14:32

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

You could look at the usual columns in every EBS table:

Code: [Select all] [Show/ hide]

CREATION_DATE	DATE	Standard Who column
CREATED_BY	NUMBER	Standard Who column
LAST_UPDATE_DATE	DATE	Standard Who column
LAST_UPDATED_BY	NUMBER	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	Standard Who column

[Updated on: Tue, 08 March 2016 14:32]

Report message to a moderator

Re: how to know who deleted the sales order lines? [message #648961 is a reply to message #648960]

Tue, 08 March 2016 14:43

pthrinadh3@gmail.com
Messages: 14
Registered: March 2016
Location: VIZAG

Junior Member

Yes, I know there are WHO columns on EBS tables.. But actually my requirement is somebody deleted few lines in sales order.
So, I want to know who deleted those lines.
Do we have any sales order archive tables in EBS?

[Updated on: Tue, 08 March 2016 14:44]

Report message to a moderator

Previous Topic:	Duplicated entry in oracle general trial balance
Next Topic:	E-Business Suite not working on Windows 7 (64-Bit OS)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 20:32:15 CDT 2025