In Per_all_people_f table what is the significance
of '_f ' ?
- 6 Answers
- 26171 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 we print the multi language in report?can any one give me step bye step explanation.
2 Answers HCL, IBM, Tech Mahindra,
What is the difference between BPA AND Contract.
tell me the scenarios of between pages in reports
what are the sql attributes?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
where is setup of business group done?
What is profile and what is level of profile option and it's hierarchy
what is meant by lexical parameter
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
how to move the one file from one instance to another instance?and ur scripts also?
what are the different types of parameters avialable in reports?
what is item status? name the related table.
Oracle Apps Technical 
