Solved

hrms ad otl

Posted on 2011-03-03
4
503 Views
Last Modified: 2013-12-07
hi what are the tables related to hr payroll and expenditure in oracle ebs r12
0
Comment
Question by:iamtechnical
  • 2
4 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 35036179
I can't help much with the specifics of ebs itself,  but since it's an oracle database  you can query dba_tables and dba_views to look for the information you are looking for.

If you don't have access to those,  try all_tables and all_views
0
 
LVL 4

Accepted Solution

by:
pinkuray earned 50 total points
ID: 35065153
All oracle HRMS table details are listed in the URL please check:

http://oracle.anilpassi.com/oracle-hrms-tables.html

0
 
LVL 4

Expert Comment

by:pinkuray
ID: 35065254
you can also find more detail information of the tables in oracle eTRM Version 12.0.0:
Login to : http://etrm.oracle.com/pls/etrm/etrm_search.search .

search for all tables related to payroll  and hrms in R12.
0
 

Author Closing Comment

by:iamtechnical
ID: 35235768
gud link
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question