Interested to Buy Any Domain ? << Click Here >> for more details...
In Per_all_people_f table what is the significance
of '_f ' ?
- 6 Answers
- 27648 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradeep
_F these are date tracked tables, which occur in HR and
Payroll. For these there are two date columns
EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together
with the PK identifies a row uniquely. The date intervals
cannot overlap.
| Is This Answer Correct ? | 21 Yes | 1 No |
Answer / phani
Yes, I agress with the above comment.
These tables are design for the Tracking purpose.
When we try to make any changes in the Oracle apps forms
which are based on these dates. They gives us a option to
CORRECT or UPDATE.
Based on the Option we choose, It is change the same table
or else it will create new record in the table.
For the better understanding about the Oracle Apps, I
suggest you to go through the following link.
http://alloracletech.blogspot.com/2008/08/oracle-applications-concept.html
Regards,
Phani
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / prince pradeep
PLZ UNDERSTAND THE QUESTION WHAT F STANDS FOR THATS IT
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ag
It stands for FULL (i.e. full history of the person, not
just the current date tracked row)
| Is This Answer Correct ? | 3 Yes | 0 No |
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
Tell me some errors names and number what u got while developing the reports?
what are the mandatory parameters in suppler Conversion?
Can u define operating units inplace of inventory?
In oracle application how do you debug or trace errors?
Can 2 functions have same name & input parameters but differ only by return datatype ?
Attribute data types?
In unix Schell sript what is very 1st line to be wriiten .
is UOM maintained at master level or organization level or both?
What are triggers?
Form development process?
how to change the logo in template dynamically?
Oracle Apps Technical 
