Apps Technical - a. Can someone please tell me what is the date tracked option and how to use it?b. Can I delete an e

GeekInterview.com > Interview Questions > Oracle Apps > Apps Technical

Go To First | Previous Question | Next Question

Apps Technical | Question 60 of 129

a. Can someone please tell me what is the date tracked option and how to use it?
b. Can I delete an employee from a table?
c. What is the difference between APIs and DataPumps?
d. What are user hooks?
e. Can we see the time stamp also with the "from" and "to" dates?

Total Answers and Comments: 4

Last Update: March 26, 2007 Asked by: OB

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 14, 2006 14:49:23

geetha24

Member Since: March 2006 Contribution: 27

RE: Hello, I am new to this forum and also to Or...

1. DateTrack adds the dimension of time to an application s database.

The value of a DateTracked record depends on the date from which

you are viewing the data. For example querying an employee s annual

salary with an effective date of 12 JUL 1992 might give a different

value than a query with an effective date of 01 DEC 1992. However

the application and the user see the employee s pay as a single record.

For more information to how to use it look at this document available in Oracle web site

Implementing Oracle HRMS (US)

Is this answer useful? Yes | No

December 01, 2006 02:15:14

Saurav

RE: Hello, I am new to this forum and also to Or...

a. Can someone please tell me what is the date tracked option and how to use it?

If the table had effective_start_date and effective_end_date columns then its called date tracked table. e.g. in a person table per_all_people_f it tells us when the person started and ended his employent with a company. if he is still an employee then effective_end_date 01-Dec-4712 for tht employee.

b. Can I delete an employee from a table?

you can but this is will end ur support licence. Oracle suggest that u never touch these shipped tables. its never practised by developers at all. BEWARE.. never do this.

c. What is the difference between APIs and DataPumps?

API are plsql procedures which insert data based on some validations.API's also do a host of other activities.Donno abt data pumps in detail..sorry..

d. What are user hooks?

No Idea..

e. Can we see the time stamp also with the from and to dates?

No u cant see time stamps. tht concept is not used in Apps. Only DD-MON-YYYY is available

Is this answer useful? Yes | No

December 01, 2006 15:28:11

Srinivas Garnepudi

RE: a. Can someone please tell me what is the date tra...

Hooks.if you are looking for the API Hooks see the following detailsAPI HooksAPI User Hooks allow users to extend the business logic of the standardbusiness rules that are executed by APIs. This is done by allowing customprocedures to be called at specific points in the standard APIs. For instance a user may want to implement User Hooks for one of the following reasons: . To extend the validation of data beyond what the standard system provides. . To maintain data held in extra customer specific tables (not part of Oracle Applications) as it is entered. . To send alerts when particular events happen within Oracle Human Resources Management System(HRMS.)The table HR_API_HOOKS contains all the hooks available for each API modulelisted in the HR_API_MODULES table.select module_name from hr_api_moduleswhere api_module_type 'AI'

Is this answer useful? Yes | No

March 26, 2007 17:56:23

JIT

RE: a. Can someone please tell me what is the date tra...

The Connection Manager manages the MPI listener (not the SQL*Net V2 listener process TNSLSNR) and data pumps for the MPI.
It also assigns each connection request dedicated by the MPI listener to a data pump.

Data pumps are the MPI interface between two protocol communities which are able to send and receive
SQL*Net V2 transactions in the protocol of the systems being serviced.

The data pumps do not perform protocol translation such as a router might.
The pump unpacks the SQL*Net V2 transaction in one protocol and repackages it
for sending in another protocol.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank