Home » Applications » Oracle Fusion Apps & E-Business Suite » how to know who deleted the sales order lines?
how to know who deleted the sales order lines? [message #648947] Tue, 08 March 2016 09:26 Go to next message
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



Re: how to know who deleted the sales order lines? [message #648960 is a reply to message #648947] Tue, 08 March 2016 14:32 Go to previous messageGo to next message
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
Senior Member
You could look at the usual columns in every EBS table:

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 Go to previous message
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:
  


Current Time: Mon Dec 23 01:19:19 CST 2024