Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How do you check entries in Oracle?

Would there be a tab in Oracle where to check the last person updated the account ?

user-image
Question ajoutée par Janet Villanueva Tejares , Senior Marketing & Events Assistant , Emirates Diplomatic Academy
Date de publication: 2013/06/09
Janet Villanueva Tejares
par Janet Villanueva Tejares , Senior Marketing & Events Assistant , Emirates Diplomatic Academy

Can you tell me to what tab to use to check it?

Rizwan Ali
par Rizwan Ali , Oracle Techno Functional , United Millers Ltd

TOO>HELP>RECORD HISTORY , You will find window having the information of user created by and updated by

Reynan Guinto
par Reynan Guinto , Procurement Officer , Al Falah University

Basically im using Purchase Portal - So, my entry will be in PURCHASE ORDER SUMMARY

Sami Mahmoud Jwaifel
par Sami Mahmoud Jwaifel , Oracle Apps System Administrator , Ministry of Finance

help->record history

SAHAYA VALAN THOMAS CRUZ
par SAHAYA VALAN THOMAS CRUZ , HR Officer , Kemco Electrical & Mechanical EST

We can get the entry details from Records History. There is an option called Reports where we need to mention which period reports we are looking for..

Kesava Baji Durga Prasad Vemula
par Kesava Baji Durga Prasad Vemula , Officer - Oracle Financial Functional , OMAN INSURANCE

Query the record and Go to Help --> Record History. You will see Last Updated by

Ahmed Farouk Mahmoud
par Ahmed Farouk Mahmoud , Country HR Lead , Ali Bin Ali Group

Navigator->Enter and Maintains->Assignment-> Entries

Help-> Record History

Muhammad Muazzam
par Muhammad Muazzam , Assistant Manager IT , Northern Power Generation Company, TPS, Muzaffargarh

Yes

As a EBS Business user, You can see the record History like Help -> Record History As an IT user, you can check the data in Base Table columns (created_by, last_updated_by, creation_date & last_updated_date)

Ahmed Shahbou
par Ahmed Shahbou , Oracle Database Administrator/Developer. , Al-Wafa Technical Systems Services

If you are using Oracle Ebiz , you can find it n Help -> Record History .
If you are using customized Oracle ERP system, You can try using the audit option on specific table, user or even a column .
Regards

Parijatham Sivaprakasam
par Parijatham Sivaprakasam , Team Member

the data histroy captured by  WHO COLUMNS

More Questions Like This